EBS Upgrade Part 6 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7
With the Database now running on OEL5 , the 11g Database did not open properly so decided to move to OEL6 server. Now follow the below procedure to migrate Database 11gR2 from OEL5 64Bit to OEL6 64Bit.
- Shutdown DB
- Backup Database and OraData
- Move Binaries from OEL5 to OEL6
- Create User/Group and RPM/Kernel Settings
- Unzip Oracle Home and OraData , Create User/Groups
- Cloning an Oracle Home
- Set Environment for SID EBSDB
- Create spfile to pfile
- Modify Refrences for file system mount
- Create pfile from spfile
- ReCreate Control File by taking trace
- Validate Alert.log
- Start Database
- alter system set compatible='11.2.0.4' scope=spfile;
- Restart Database and validate alert.log
- alter system set optimizer_features_enable='11.2.0.4' scope=spfile;
- Restart Database and validate alert.log
- Configure Listener
- Backup Database and OraData
- Transfer and untar appsutil from 9i MT to 11g MT , NO Autoconfig
- Update EBS 11.5.9 Context File with the New Database Hostname
- Update /etc/hosts with the IP and Hostname
- Run Autoconfig and verify logs for no errors
- Validate apps login from MT 11.5.9
- --DO NOT START APPLICATION 11.5.9 Services---
- Shutdown DB and Apply 11.2.0.4 RDBMS patch ( 7 patches )
Refer to the Index Page to see the full flow of the upgrade.
