设为首页 加入收藏

TOP

ora-01092 oracle instance terminated的解决(二)
2014-11-23 21:54:42 来源: 作者: 【 】 浏览:33
Tags:ora-01092 oracle instance terminated 解决
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 Ente
首页 上一页 1 2 3 下一页 尾页 2/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇ORA-00600:internal error code.... 下一篇创建表,提示ORA-00959:表空间..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: