ora-01092 oracle instance terminated的解决   环境：
  solaris10  64bit   、oracle10gR2 64bit
  操作：
  主要是做数据库软件升级，由10.2.0.1升级到10.2.0.5
  当完成升级软件安装后，通过sqlplus 用DBA权限登录，执行startup时报错   -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, 2010, Oracle.  All Rights Reserved.   Connected to an idle instance.   www.2cto.com   SQL> startup UPGRADE
  ORACLE instance started.   Total System Global Area  167772160 bytes Fixed Size                  2094800 bytes Variable Size             100665648 bytes Database Buffers           58720256 bytes Redo Buffers                6291456 bytes ora-01092 oracle instance terminated   查询错误：
  查看admin/ORCL/bdump/alert_ORCL.log内容：
  Sat Jun  9 14:21:41 2012 Starting background process EMN0 EMN0 started with pid=28, OS id=7636 Sat Jun  9 14:21:41 2012 Shutting down instance: further logons disabled Sat Jun  9 14:21:41 2012 Stopping background process QMNC Sat Jun  9 14:21:41 2012 Stopping background process CJQ0 Sat Jun  9 14:21:43 2012 Stopping background process MMNL Sat Jun  9 14:21:44 2012 Stopping background process MMON Sat Jun  9 14:21:45 2012 Shutting down instance (immediate) License high water mark = 19 Sat Jun  9 14:21:45 2012 Stopping Job queue slave processes Sat Jun  9 14:21:45 2012 Job queue slave processes stopped All dispatchers and shared servers shutdown Sat Jun  9 14:21:57 2012  www.2cto.com   PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump
  Sat Jun  9 14:22:09 2012 PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump Sat Jun  9 14:22:13 2012 ALTER DATABASE CLOSE NORMAL Sat Jun  9 14:22:14 2012 SMON: disabling tx recovery SMON: disabling cache recovery Sat Jun  9 14:22:14 2012 Shutting down archive processes Archiving is disabled Sat Jun  9 14:22:19 2012 ARCH shutting down ARC1: Archival stopped Sat Jun  9 14:22:24 2012 ARCH shutting down ARC0: Archival stopped Sat Jun  9 14:22:25 2012 Thread 1 closed at log sequence 3 Successful close of redo thread 1 Sat Jun  9 14:22:25 2012 Completed: ALTER DATABASE CLOSE NORMAL Sat Jun  9 14:22:25 2012  www.2cto.com   ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sat Jun 09 14:48:07 CST 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Shared memory segment for instance monitoring created Picked latch-free SCN scheme 3 IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.5.0. System parameters with non-default values:   processes                = 150   __shared_pool_size       = 92274688   __large_pool_size        = 4194304   __java_pool_size         = 4194304   __streams_pool_size      = 0   sga_target               = 167772160   control_files            = /oracle/oradata/ORCL/control01.ctl, /oracle/oradata/ORCL/control02.ctl, /oracle/oradata/ORCL/control03.ctl   db_block_size            = 8192  www.2cto.com     __db_cache_size          = 58720256   compatible               = 10.2.0.1.0   log_archive_dest_1       = LOCATION=/oracle/arch/   log_archive_format       = %t_%s_%r.dbf   db_file_multiblock_read_count= 8   undo_management          = AUTO   undo_tablespace          = UNDOTBS1   remote_login_passwordfile= EXCLUSIVE   db_domain                =   dispatchers              = (PROTOCOL=TCP) (SERVICE=ORCLXDB)   job_queue_processes      = 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     = 148897792 PSP0 started with pid=3, OS id=18694 PMON started with pid=2, OS id=18692 MMAN started with pid=4, OS id=18696 DBW0 started with pid=5, OS id=18698 LGWR started 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=18706 CJQ0 started with pid=10, OS id=18708 MMON started with pid=11, OS id=18710 Sat 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=18712 Sat Jun 09 14:48:09 CST 2012 starting up 1 shared server(s) ... Sat Jun 09 14:48:10 CST 2012 ALTER DATABASE   MOUNT Sat Jun 09 14:48:16 CST 2012 Setting recovery target incarnation to 2 Sat Jun 09 14:48:16 CST 2012 Successful mount of redo thread 1, with mount id 1313337388 Sat Jun 09 14:48:16 CST 2012 Database mounted in Exclusive Mode Completed: ALTER DATABASE   MOUNT Sat Jun 09 14:48:17 CST 2012 ALTER DATABASE OPEN Sat Jun 09 14:48:17 CST 2012 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=16, OS id=18720 Sat Jun 09 14:48:17 CST 2012 ARC0: Archival started ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC1 started with pid=17, OS id=18722 ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH Sat Jun 09 14:48:17 CST 2012 ARC0: Becoming the heartbeat ARCH Sat Jun 09 14:48:17 CST 2012 Thread 1 opened at log sequence 3   Current log# 2 seq# 3 mem# 0: /oracle/oradata/ORCL/redo02.log Successful open of redo thread 1 Sat Jun 09 14:48:17 CST 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Jun 09 14:48:17 CST 2012 SMON: enabling cache recovery Sat Jun 09 14:48:19 CST 2012 Errors in file /oracle/admin/ORCL/udump/orcl_ora_18718.trc: ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Sat Jun 09 14:48:19 CST 2012 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 18718 ORA-1092 signalled during: ALTER DATABASE OPEN...    www.2cto.com   以上红色表示出现的error info。
  根据上述提示，查询/oracle/admin/ORCL/udump/orcl_ora_18718.trc文件：   /oracle/admin/ORCL/udump/orcl_ora_18718.trc Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /oracle/product/10.2.0 System name: SunOS Node name:     solaris10ora10gr2x64 Release:  5.10 Version:   Generic_141445-09 Machine: i86pc Instance name: ORCL Redo thread mounted by this instance: 1 Oracle process number: 15 Unix process pid: 18718, image: oracle@solaris10ora10gr2x64 (TNS V1-V3)   *** ACTION NAME:() 2012-06-09 14:48:19.068 *** MODULE NAME:(sqlplus@solaris10ora10gr2x64 (TNS V1-V3)) 2012-06-09 14:48:19.068 *** SERVICE NAME:(SYS$USERS) 2012-06-09 14:48:19.068 *** SESSION ID:(159.3) 2012-06-09 14:48:19.068 ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
  解决方案：
  原因是由于在完成升级版本后，数据字典的内容被修改了，需要使用catalog.sql和catproc.sql这两个脚本再运行一下把数据字典再更新一下。于是使用命令"startup upgrade"启动数据库，再运行catupgrd.sql这个脚本，即运行"@ORACLE_HOMErdbmsadmincatupgrd.sql"，这条语句会执行比较久的时间，我是在PC机上操作的，执行了12分钟左右。执行完成以后，关闭数据库，再使用正常模式启动数据库，再运行一下utlrp.sql这个脚本来重新编译一下一些无效的对象。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, 2010, Oracle.  All Rights Reserved.   Connected to an idle instance.   www.2cto.com   SQL> startup UPGRADE ORACLE instance started.   Total System Global Area  167772160 bytes Fixed Size                  2094800 bytes Variable Size             100665648 bytes Database Buffers           58720256 bytes Redo Buffers                6291456 bytes Database mounted. Database opened. SQL>
    作者 蓝红石