设为首页 加入收藏

TOP

ora-01092 oracle instance terminated的解决(一)
2014-11-23 21:54:42 来源: 作者: 【 】 浏览:34
Tags:ora-01092 oracle instance terminated 解决

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_
首页 上一页 1 2 3 下一页 尾页 1/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇ORA-00600:internal error code.... 下一篇创建表,提示ORA-00959:表空间..

评论

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