我将oracle10g升级到10.2.0.4后，oracle就启动不了，查看服务oracledbconsoleorcl 和
oracleDb10g_home1TNSlistener都是启动的。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 293601280 bytes
Fixed Size 1296332 bytes
Variable Size 79693876 bytes
Database Buffers 205520896 bytes
Redo Buffers 7090176 bytes
数据库装载完毕。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01092: ORACLE 实例终止。强制断开连接。
alter_orcl.log 如下：
Sat Sep 04 07:06:39 2010
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sat Sep 04 07:06:40 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_pmon_3212.trc:
ORA-00704: bootstrap process failure
Sat Sep 04 07:06:40 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_reco_2596.trc:
ORA-00704: bootstrap process failure
Sat Sep 04 07:06:40 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_smon_3172.trc:
ORA-00704: bootstrap process failure
Sat Sep 04 07:06:41 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_ckpt_4044.trc:
ORA-00704: bootstrap process failure
Sat Sep 04 07:06:41 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_mman_592.trc:
ORA-00704: bootstrap process failure
Sat Sep 04 07:06:41 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_psp0_1424.trc:
ORA-00704: bootstrap process failure
Sat Sep 04 07:06:41 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_lgwr_1692.trc:
ORA-00704: bootstrap process failure
Sat Sep 04 07:06:41 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_dbw0_4032.trc:
ORA-00704: bootstrap process failure
Instance terminated by USER, pid = 3868
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sat Sep 04 07:08:52 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
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.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 71303168
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 293601280
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 205520896
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0\db_1/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 96468992
PMON started with pid=2, OS id=4024
PSP0 started with pid=3, OS id=3356
MMAN started with pid=4, OS id=3468
DBW0 started with pid=5, OS id=2404
LGWR started with pid=6, OS id=3544
CKPT started with pid=7, OS id=2804
SMON started with pid=8, OS id=1228
RECO started with pid=9, OS id=2060
CJQ0 started with pid=10, OS id=3044
MMON started with pid=11, OS id=2056
Sat Sep 04 07:08:52 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Sep 04 07:08:52 2010
starting up 1 shared server(s) ...
MMNL started with pid=12, OS id=612
Sat Sep 04 07:08:53 2010
ALTER DATABASE MOUNT
Sat Sep 04 07:08:58 2010
Setting recovery target incarnation to 2
Sat Sep 04 07:08:58 2010
Successful mount of redo thread 1, with mount id 1256585093
Sat Sep 04 07:08:58 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Sep 04 07:11:09 2010
alter database open
Sat Sep 04 07:11:09 2010
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Sat Sep 04 07:11:09 2010
Started redo scan
Sat Sep 04 07:11:09 2010
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Sat Sep 04 07:11:09 2010
Started redo application at
Thread 1: logseq 10, block 2, scn 731996
Sat Sep 04 07:11:09 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 10 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sat Sep 04 07:11:09 2010
Completed redo application
Sat Sep 04 07:11:09 2010
Completed crash recovery at
Thread 1: logseq 10, block 3, scn 751998
0 data blocks read, 0 data blocks written, 1 redo blocks read
Sat Sep 04 07:11:10 2010
Thread 1 advanced to log sequence 11 (thread open)
Thread 1 opened at log sequence 11
Current log# 1 seq# 11 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Sat Sep 04 07:11:10 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Sep 04 07:11:10 2010
SMON: enabling cache recovery
Sat Sep 04 07:11:10 2010
Errors in file d:\oracle\product\10.2.0\db_1\admin\orcl\udump\orcl_ora_1332.trc:
ORA-00704: 引导程序进程失败
ORA-39700: 必须用 UPGRADE 选项打开数据库
3 个解决方案
#1
http://hi.baidu.com/izouying/blog/item/ab36e3dee289b853ccbf1a32.html
#2
升级成功了吗？ 升级之后的几个catalog.sql脚本执行没有？
#3
谢谢各位，问题已经解决。
在升级过程中，只安装了补丁软件，没升级数据字典，因而造成数据库打不开，报ORA-00704:bootstrap process failure错误，后按照正常升级数据字典的步骤进行即可。
SQL>startup upgrade
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catalog.sql
SQL>shutdown immediate
SQL>startup
数据库启动成功
在升级过程中，只安装了补丁软件，没升级数据字典，因而造成数据库打不开，报ORA-00704:bootstrap process failure错误，后按照正常升级数据字典的步骤进行即可。
SQL>startup upgrade
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catalog.sql
SQL>shutdown immediate
SQL>startup
数据库启动成功
#1
http://hi.baidu.com/izouying/blog/item/ab36e3dee289b853ccbf1a32.html
#2
升级成功了吗？ 升级之后的几个catalog.sql脚本执行没有？
#3
谢谢各位，问题已经解决。
在升级过程中，只安装了补丁软件，没升级数据字典，因而造成数据库打不开，报ORA-00704:bootstrap process failure错误，后按照正常升级数据字典的步骤进行即可。
SQL>startup upgrade
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catalog.sql
SQL>shutdown immediate
SQL>startup
数据库启动成功
在升级过程中，只安装了补丁软件，没升级数据字典，因而造成数据库打不开，报ORA-00704:bootstrap process failure错误，后按照正常升级数据字典的步骤进行即可。
SQL>startup upgrade
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql
SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catalog.sql
SQL>shutdown immediate
SQL>startup
数据库启动成功