ORA-01012: not logged on處理

ORA-01012: not logged on處理

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  284565504 bytes
Fixed Size                  1336036 bytes
Variable Size            258063644 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted