摘自CSDN 主要解答者:lzp_lrp 提交人:zhangdatou
[@more@]ORA-01090 shutdown in progress - connection is not permitted
Cause: The SHUTDOWN command was used to shut down a running Oracle instance, disallowing
any connects to Oracle.
Action: Wait for the instance to restart or contact the database administrator
Troubleshooting ORA-01090: shutdown in progress,ORA-01081
现象:
SQL> shutdown immediate
ORA-01090: shutdown in progress - connection is not permitted
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
解决方法:
dragon1> ps -ef ¦grep oracle9 ¦grep _rac1 ¦grep -v grep ¦awk '{print "kill -9 "$2}' >mykill
dragon1>. ./mykill
dragon1> ipcs -m
Shared Memory:
T ID KEY MODE OWNER GROUP
m 128 0 --rw-r----- oracle8 dba
m 129 0 --rw-r----- oracle8 dba
m 130 0xe9d0aaa8 --rw-r----- oracle8 dba
m 1027 0 --rw-r----- oracle9 dba
m 1028 0xe0bb589c --rw-r----- oracle9 dba
dragon1> ipcrm -m 1027
dragon1> ipcrm -m 1028
然后就可以起来了。
---------------------------------------------------------------
有可能是有dba权限的人用shutdown, 关闭数据库, 此时oracle处理死掉了
主要解答者:lzp_lrp 提交人:zhangdatou
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/166555/viewspace-787049/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/166555/viewspace-787049/