Wednesday, December 2, 2020

EBS Upgrade Part 2 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

EBS Upgrade Part 2 - 11.5.9 Database 9i RHEL 4 to EBS 12.2 Database 19c OEL 7

Wow had a change to upgrade 9i database after a long time. 

Upgrade Database from 9.2.0.3 to 9.2.0.8

  • Download and Unzip p4547809_92080_LINUX.zip 32bit
  • Shutdown Application and Database
  • Backup 9.2.0.3 Oracle Home
  • Run 9.2.0.8 Patch Set Update on 9.2.0.3 Oracle Home
  • Complete Post Install Action on for Patch 4547809
  • Database and Server was Hung
  • Changed Database to NoArchive Log Mode
  • Restarted Post Install Action on for Patch 4547809
  • Restart Database and Recompile Invalids
  • Start Database and Application + Health Check
  • Cold Backup with all Service Down

We are now at 9.2.0.8 which is eligible for a direct upgrade to 10.2.0.5. In the next step I will be upgrading the database to 10g.

Refer to the Index Page to see the full flow of the upgrade.

Popular Posts