ORA-01012: not logged on处理
(2014-02-23 15:12:30)
标签:
ora-01012notloggedon |
分类: ASM |
SQL> startup nomount
ORA-01012: not logged on
SQL> startup
ORA-01012: not logged on
SQL> shutdown immediate
ORA-24324: service handle not
initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are
permitted
查看alert日志:
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp
3
SUCCESS: diskgroup SYS_DG was mounted
SUCCESS: ALTER DISKGROUP ALL MOUNT
NOTE: diskgroup resource ora.DATA_DG.dg is online
NOTE: diskgroup resource ora.DG_FRA.dg is online
NOTE: diskgroup resource ora.SYS_DG.dg is online
Sat Feb 22 19:38:59 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
Sat Feb 22 19:44:02 2014
SHUTDOWN: Active processes prevent shutdown
operation
Sat Feb 22 19:49:04 2014
SHUTDOWN: Active processes prevent shutdown
operation
[grid@myrac1 trace]$ date
Sat Feb 22 21:07:46 PST 2014
[grid@myrac1 trace]$ tail -f alert_+ASM.log
Sat Feb 22 19:38:59 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
Sat Feb 22 19:44:02 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 19:49:04 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 21:09:49 2014
License high water mark = 4
从日志可以发现是实例出现异常,导致无法启动shutdown,尝试强行停止
SQL> shutdown abort
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area
Fixed
Size
Variable
Size
ASM
Cache
ASM diskgroups mounted