What you'll learn
- Oracle EBS DBA
- Upgrade from R12.1.3 to R12.2.10
- Cloud DBA's who are interested in upgrade
- Upgrade Students
Requirements
- Oracle EBS DBA
Description
Step by Step approach from Oracle EBS R12.1.3 to R12.2, here are the course contents
Upgrade Oracle EBS from R12.1.3 to R12.2.10. 1
Environment used for the Upgrade. 3
Source – Oracle EBS R12.1.3 with 12c. 5
Database and System Administration Tasks. 7
Oracle EBS R12.2 upgrade preparation steps on OEL 7.x. 8
Install Oracle EBS R12.2 in upgrade mode. 8
Upgrade R12.1.3 to Oracle E-Business R12.2. 24
Preparing the System for Upgrade. 24
Run EBS Technology Codelevel Checker (ETCC) utility on Database node. 24
Upgrade DST Version. 28
Ensure that Maintenance Mode is enabled. 31
Update the profiles. 31
Apply AD 12.2 upgrade driver. 31
Apply all Consolidated Upgrade Patches (CUPs) 34
122 Master Merge. 39
Check Free space in tablespaces. 40
Apply 12.2 American English upgrade patch driver. 40
Disable Maintenance Mode. 42
Compile Invalid Objects. 42
Run Rapid Install to configure. 43
Run autoconfig on apps Tier and db tier. 50
Enable online patching. 55
Apply the latest Oracle E-Business Suite Online Patching Readiness and GSCC Report Patch. 64
Fix data dictionary or time stamp mismatch. 65
Run the Online Patching Enablement - Readiness Reports. 67
Verify database tablespace free space. 67
Run the Online Patching Enablement - Status Report 69
Apply the Online Patching Enablement patch. 71
Database Initialization Parameter. 74
Upgrade from Oracle EBS R12.2 to R12.2.10. 75
Set Database Parameter (Conditional) 75
Apply Consolidated Seed Table Upgrade Patch (Required) 75
Applying the Latest AD and TXK. 76
Update Database Tier to Latest Code. 78
Apply EBS R12.2.10 patch. 80
Apply help patch. 80
Run Preclone and take a backup. 80
Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1) 82
Issues and solutions. 82
Execute an Empty patching cycle. 85
Solution. 85
Submit Gather Schema Stats. 86
Custom Top Registration. 86
Problems and solutions. 89
Who this course is for:
- EBS DBA who want to upgrade from R12.1.3 to R12.2.10
Instructor
![Kishore A](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 402 Reviews
- 3,695 Students
- 32 Courses
Kishore A is an Oracle E-Business DBA, Oracle Cloud Infrastructure Consultant and Oracle 12c/19c DBA consultant who takes a leadership role in Planning, Installing, and implementing innovative business process and system solutions using state-of-the-art approaches and technology. Creative problem-solver who always goes the extra mile, is adept at learning new systems and processes, and has proven ability to work effectively. Strong customer/user advocate, apt negotiator with excellent analytical, collaboration, communication, decision-making, and organization skills. He also has experience on Oracle Identity and Access Management (SSO) for 8 years including Integrating PaaS, SaaS and Azure AD/ADFS and also has worked in RAC 19c environment. He is also a Distinguished Toastmaster (DTM). He has 15 OCI certifications.
Kishore has below Certifications for his credit
Oracle Cloud Database Services 2021 Certified Specialist
Oracle Database Cloud Administrator 2021 Certified Professional
Oracle Cloud Infrastructure 2021 Certified Architect Professional
Oracle Cloud Infrastructure 2021 Certified Cloud Operations Associate
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Cloud Database Migration and Integration 2021 Certified Specialist
Oracle Cloud Infrastructure 2021 Certified Architect Associate
Oracle Cloud Infrastructure Foundations 2021 Certified Associate
Oracle Cloud Infrastructure 2021 Enterprise Workloads Certified Associate
Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator
Oracle Database Cloud Service 2020 Certified Specialist
Oracle Database Cloud Administrator 2020 Certified Professional
Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate
Oracle Cloud Infrastructure 2020 Certified Architect Associate
Oracle Cloud Infrastructure Foundations 2020 Certified Associate
Oracle Cloud Infrastructure 2019 Certified Architect Professional
Oracle Autonomous Database Cloud 2019 Certified Specialist
Oracle Cloud Infrastructure 2019 Certified Architect Associate
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Database Cloud Administrator Certified Professional
Oracle Database Cloud Service Operations Certified Associate
Oracle Database 11g Administrator Certified Professional
Oracle E-Business Suite R12 Applications Database Administrator Certified Professional