Category Archives: Oracle Database Upgrade

Oracle Database Upgrade

ORA-00704: bootstrap process failure

Bootstarp error indicates version mismatch between datafile headers and oracle binaries, which are being used to start the database. I’m starting the database using Oracle 12.1.0.2 binaries, where as datafiles are from 11.2.0.4. $ sqlplus / as sysdba SQL*Plus: Release … Continue reading

Posted in Oracle Administration, Oracle Database Upgrade, Startup issues | Tagged , , , | Leave a comment

ORA-27211: Failed to load Media Management Library

Recently after database out-of-place upgrade to a higher version (11.2.0.x to 11.2.0.x+1), TAPE backup started failing with following error RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE SBT; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure … Continue reading

Posted in Oracle Database Backup, Oracle Database Upgrade, Oracle Recovery Manager | Tagged , , | Leave a comment

Oracle Restart upgrade fails with INS-40406 – The installer detects no existing Oracle Grid Infrastructure software

While upgrading 11203 Oracle restart environment to 11204, screen 2 – Selected option – “Upgrade oracle grid infra or oracle ASM”, fails with INS-40406 – The installer detects no existing Oracle Grid Infrastructure software Error. Following inventory entries were present, … Continue reading

Posted in Oracle Database Upgrade, Oracle Software Inventory | Tagged , , | Leave a comment

Oracle 11.2.0.2 In-Place & Out-of-Place Upgrade

We can perform database upgrade from 11.2.0.1 to 11.2.0.2 in 2 ways 1. In-Place 2. Out-of-Place (Oracle’s recommended approach) In prior releases, how it worked DB Upgrade 8i to 10g (Out-Of-Place) We install Oracle binaries for 10g at new location, then … Continue reading

Posted in Oracle 11.2.0.x, Oracle 11g Enhancements, Oracle Database Upgrade | Tagged | 5 Comments

Database upgrade from 10.2.0.3 to 10.2.0.4

Database – Oracle Enterprise Edition 10.2.0.3 Platform – Sun SPARC Solaris 10 64-bit I recently upgraded my Oracle RAC database to 10.2.0.4. Software upgrade worked fine. But after manually upgrading the database, Component ‘Oracle Database Server’ becomes INVALID Oracle Database … Continue reading

Posted in Oracle Database Upgrade | Tagged | 3 Comments

OCI-21500: internal error code, arguments: [koxsihread1]

While upgrading the database from 8i to 10g, I faced following error OCI-21500: internal error code, arguments: [koxsihread1], [0], [0], [4], [], [], [], [] Cause The commands “set serveroutput on / off” in the following scripts prvtpb.plb catproc.sql c1001000.sql … Continue reading

Posted in Oracle Database Upgrade | Tagged | 2 Comments