Solution to ora-01092 oracle instance terminated

Solution environment for ora-01092 oracle instance terminated:
Solaris10 64bit, oracle10gR2 64bit
Operation:
Mainly for database software upgrade, from 10.2.0.1 to 10.2.0.5
After the software upgrade is completed, log on with DBA permission through sqlplus and run startup to report the error-bash-3.00 $ sqlplus/as sysdba SQL * Plus: release 10.2.0.5.0-Production on Sat Jun 9 15:47:30 2012 Copyright (c) 1982,201 0, Oracle. all Rights Reserved. connected to an idle instance. www.2cto.com SQL> startup UPGRADE
ORACLE instance started. Total System Global Area 167772160 bytesFixed Size 2094800 bytesVariable Size 100665648 bytesDatabase Buffers 58720256 bytesRedo Buffers 6291456 bytesora-01092 oracle instance terminated query error:
View admin/ORCL/bdump/alert_ORCL.log:
Sat Jun 9 14:21:41 2012 Starting background process EMN0EMN0 started with pid = 28, OS id = 7636Sat Jun 9 14:21:41 2012 Shutting down instance: further logons disabledSat Jun 9 14:21:41 2012 Stopping background process QMNCSat Jun 9 14:21:41 2012 Stopping background process CJQ0Sat Jun 9 14:21:43 2012 Stopping background process MMNLSat Jun 9 14:21:44 2012 Stopping background process MMONSat Jun 9 14:21:45 Shutting down instance (immediate) license high water mark = 19Sat Jun 9 14:21:45 2012 Stopping Job queue slave processesSat Jun 9 14:21:45 2012Job queue slave processes stoppedAll dispatchers and shared servers shutdownSat Jun 9 14:21:57 2012 fail PMON failed to acquire latch, see PMON dumpPMON failed to acquire latch, see PMON dump
Sat Jun 9 14:22:09 2012 PMON failed to acquire latch, see PMON dumpPMON failed to acquire latch, see PMON dumpSat Jun 9 14:22:13 2012 alter database close NORMALSat Jun 9 14:22:14 2012 SMON: disabling tx recoverySMON: disabling cache recoverySat Jun 9 14:22:14 2012 Shutting down archive processesArchiving is disabledSat Jun 9 14:22:19 2012 ARCH shutting downARC1: Archival stoppedSat Jun 9 14:22:24 2012A RCH shutting downARC0: Archival stoppedSat Jun 9 14:22:25 2012 Thread 1 closed at log sequence 3 Successful close of redo thread 1Sat Jun 9 14:22:25 2012 Completed: alter database close NORMALSat Jun 9 14:22:25 2012 www.2cto.com alter database DISMOUNTCompleted: alter database dismountarch: Archival disabled due to shutdown: 1089 Shutting down archive processesArchiving is disabledArchive process shut Down avoided: 0 activeARCH: Archival disabled due to shutdown: 1089 Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeSat Jun 09 14:48:07 CST 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0 Shared memory segment for instance monitoring createdPicked latch-free SCN scheme 3 IMODE = BRILAT = 18LICENSE_MAX_USERS = 0SYS aud Iting is disabledksdpec: called for event 13740 prior to event group initializationStarting up oracle rdbms Version: 10.2.0.5.0.System parameters with non-default values: processes = 150 _ shared_pool_size = 92274688 _ bytes = 4194304 _ java_pool_size = 4194304 _ streams_pool_size = 0 sga_target = 167772160 control_files =/oracle/oradata/ORCL/control01.ctl, /oracle/oradata/ORCL/control0 2. ctl, /oracle/oradata/ORCL/control03.ctl db_block_size = 8192 www.2cto.com _ db_cache_size = 58720256 compatible = 10.2.0.1.0 success =/oracle/arch/log_archive_format = % t _ % s _ % r. dbf authorization = 8 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile = EXCLUSIVE db_domain = dispatchers = (PROTOCOL = TCP) (SERVICE = ORCLXDB) job_queue_proces Ses = 10 background_dump_dest =/oracle/admin/ORCL/bdump user_dump_dest =/oracle/admin/ORCL/udump core_dump_dest =/oracle/admin/ORCL/cdump audit_file_dest =/oracle/admin/ ORCL/adump db_name = ORCL open_cursors = 300 pga_aggregate_target = 148897792PSP0 started with pid = 3, OS id = 18694 PMON started with pid = 2, OS id = 18692 MMAN started with pid = 4, OS id = 18696DBW0 started with pid = 5, OS id = 18698 LGWR s Tarted with pid = 6, OS id = 18700 CKPT started with pid = 7, OS id = 18702 SMON started with pid = 8, OS id = 18704 RECO started with pid = 9, OS id = 18706CJQ0 started with pid = 10, OS id = 18708 MMON started with pid = 11, OS id = 18710Sat Jun 09 14:48:09 CST 2012 starting up 1 dispatcher (s) for network address '(ADDRESS = (PARTIAL = YES) (PROTOCOL = TCP ))'... www.2cto.com MMNL started with pid = 12, OS id = 18712Sat Jun 09 14:48:09 CST 2012 starting up 1 shared server (s )... sat Jun 09 14:48:10 CST 2012 alter database MOUNTSat Jun 09 14:48:16 CST 2012 Setting recovery target incarnation to 2Sat Jun 09 14:48:16 CST 2012 Successful mount of redo thread 1, with mount id 1313337388Sat Jun 09 14:48:16 CST 2012 Database mounted in Exclusive ModeCompleted: alter database MOUNTSat Jun 09 14:48:17 CST 2012 alter database OPENSat Jun 09 14: 48: 17 CST 2012 LGWR: starting arch PROCESSESARC0 started with pid = 16, OS id = 18720Sat Jun 09 14:48:17 CST 2012ARC0: Archival startedARC1: Archival startedLGWR: starting arch processes COMPLETEARC1 started with pid = 17, OS id = 18722ARC1: Becoming the 'no fal' ARCHARC1: Becoming the 'no srl' ARCHSat Jun 09 14:48:17 CST 2012ARC0: becoming the heartbeat ARCHSat Jun 09 14:48:17 CST 2012 Thread 1 opened at l Og sequence 3 Current log #2 seq #3 mem #0: /oracle/oradata/ORCL/redo02.logSuccessful open of redo thread 1Sat Jun 09 14:48:17 CST 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setSat Jun 09 14:48:17 CST 2012 SMON: enabling cache recoverySat Jun 09 14:48:19 CST 2012 Errors in file/oracle/admin/ORCL/udump/orcl_ora_18718.trc: ORA-00704: bootstrap process failureORA-39700: databas E must be opened with UPGRADE optionSat Jun 09 14:48:19 CST 2012 Error 704 happened during db open, shutting down databaseUSER: terminating instance due to error 704 Instance terminated by USER, pid = 18718ORA-1092 signalled: alter database open... the error info is displayed in red at www.2cto.com.
Query the/oracle/admin/ORCL/udump/orcl_ora_18718.trc file:/oracle/admin/ORCL/udump/login Database 10g Enterprise Edition Release 10.2.0.5.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORACLE_HOME =/oracle/product/10.2.0System name: SunOSNode name: solaris10ora10gr2x64Release: 5.10 Version: Generic_141445-09Machine: i86pcInstance name: ORCLRedo thread mounted by this instance: 1 Oracle process number: 15 Unix process pid: 18718, image: oracle @ solaris10ora10gr2x64 (TNS V1-V3) *** action name :() 14:48:19. 068 *** module name :( sqlplus @ solaris10ora10gr2x64 (TNS V1-V3) 14:48:19. 068 *** service name :( SYS $ USERS) 14:48:19. 068 *** session id: (159.3) 14:48:19. 068ORA-00704: bootstrap process failureORA-39700: database must be opened with UPGRADE option
Solution:
The reason is that after the upgraded version is completed, the content of the data dictionary is modified. You need to use the catalog. SQL and catproc. SQL scripts to run and update the data dictionary. Run the "startup upgrade" command to start the database and then run catupgrd. run "@ ORACLE_HOME \ rdbms \ admin \ catupgrd. SQL ", this statement will be executed for a long time, I operate on a PC, and executed for about 12 minutes. After the execution is complete, close the database, start the database in normal mode, and run the utlrp. SQL script to re-compile some invalid objects. OK. -Bash-3.00 $ sqlplus/as sysdba SQL * Plus: Release 10.2.0.5.0-Production on Sat Jun 9 15:47:30 2012 Copyright (c) 1982,201 0, Oracle. all Rights Reserved. connected to an idle instance. www.2cto.com SQL> startup UPGRADEORACLE instance started. total System Global Area 167772160 bytesFixed Size 2094800 bytesVariable Size 100665648 bytesDatabase Buffers 58720256 bytesRedo Buffers 6291456 bytesDatabase mounted. database opened. SQL>
Author: Blue Paper