EBS Upgrade Part 7 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7
Now we have moved database form 9i RHEL 4 to 11gR2 OEL 6. We should be good to start with the 12.1 Upgrade. The below procedure will help Upgrading Application from 11.5.9 to 12.1.1
- Stage CD Creation
- Source adjkey –initialize
- Restart DB with 1000 as process parameter
- Apply 11i.AD.I.6 , Superseeded by 11i.AD.I.7
- Run TUMS utility , install patch 7705743
- Convert to Multiple Organizations architecture
- Drop event alert triggers in custom schemas
- Review sizes of old and new tablespaces
- Run AD preparation scripts
- Convert Oracle Alert E-mail Processing to the WF Mailer
- Customer Relationship Management Tasks
- Incentive Compensation
- TeleService
- Mobile Field Service
- Financials and Procurement Tasks
- General Ledger
- iPayments
- Internet Expenses
- Subledger Accounting
- Leasing and Finance Management Tasks
- Projects Tasks
- Public Sector/University Tasks
- Supply Chain Management Tasks
- Depot Repair
- Enterprise Asset Management
- Process Manufacturing
- Service Contracts
- Drop MRC Schema
- Enable Maintenance Mode
- Gather schema statistics
- Build Repo and enable addons channel in .repo file
- yum install oracle-ebs-server-R12-preinstall -y
- mv /usr/bin/unzip /usr/bin/unzip-ver6
- replace unzip with https://oss.oracle.com/el4/unzip/unzip.tar
- Run Rapid Install to install the upgrade file system
- Enable Maintenance Mode
- Perform Task from 2057857.1 to avoid relink errors
- Merge Upgrade Driver 7461070,9474320,9179588
- ADPatch Merged Upgrade Driver from /u03/soft/upgrade_driver
- Download Apply PreInstall patch as per Note : 1448102.2
- mv /dev/random /dev/random_original;ln -s /dev/urandom /dev/random
- SQL> GRANT UNLIMITED TABLESPACE TO apps and applsys
- Apply PreInstall + u6678700.drv -- following Note : 1448102.2
- Disable Maintenance Mode
- Run Rapid Install to Configuration the Application 12.1.1
- Apply FIx 879522.1
- Copy JRE from MT to DB keep under appsutil folder
- Perform Finish the Upgrade Task
- Help Patch u6746000.drv
- Backup
Refer to the Index Page to see the full flow of the upgrade.
