Database instance cannot be started after ORA-39700 Oracle 10g upgrade
Upgrade Oracle Database 10.2.0.1 to 10.2.0.5 today
An error occurred while starting the database:
ORA-01092: The ORACLE instance terminated. Disconnection forced instance is terminated and forcibly disconnected.
View the database alarm log. The default address is $ ORACLE_BASE/admin/$ ORACLE_SID/bdump/aler_SID.log in the directory.
[Oracle @ RedHat4 bdump] $ cd $ ORACLE_BASE/admin/$ ORACLE_SID/bdump/
[Oracle @ redhat4 bdump] $ pwd
/U01/app/oracle/admin/crab/bdump
[Oracle @ redhat4 bdump] $ vim alert_crab.log
Recent log error message:
Mon Jun 09 13:54:51 CST 2014
ARC0: Becoming the heartbeat ARCH
Mon Jun 09 13:54:51 CST 2014
Thread 1 opened at log sequence 14
Current log #1 seq #14 mem #0:/u01/app/oracle/oradata/crab/redo01.log
Successful open of redo thread 1
Mon Jun 09 13:54:51 CST 2014
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 09 13:54:51 CST 2014
SMON: enabling cache recovery
Mon Jun 09 13:54:57 CST 2014
Errors in file/u01/app/oracle/admin/crab/udump/crab_ora_2768.trc:
ORA-00704: bootstrap process failure.
ORA-39700: database must be opened with UPGRADE option
Mon Jun 09 13:54:57 CST 2014
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704.
Instance terminated by USER, pid = 2768
ORA-1092 signalled during: alter database open...
Locate the problem
Oracle 10g Official documentation shows:
ORA-39700: database must be opened with UPGRADE option
Cause: A normal database open was attempted, but the database has not been upgraded to the current server version.
Action: Use the UPGRADE option when opening the database to run catupgrd. SQL (for database upgrade), or to run catalog. SQL and catproc. SQL (after initial database creation)
I only installed the upgrade package and did not perform the Database Upgrade process.
Go to the database and start to upgrade.
Sqlplus/as sysdba
Startup upgrade
@/U01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog. SQL
@/U01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc. SQL
These two scripts are slow. I ran them for half an hour.
Alternatively, you can @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd. SQL
Close the database and start the database.
SQL> select open_mode from v $ database;
OPEN_MODE
----------
READ WRITE
1 row selected.
SQL> show user
USER is "SYS"
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian