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
解决方法:
oracle> ps -ef|grep oracle |grep _rac1|grep -v grep |awk '{print "kill -9 "$2}'
oracle> chmod +x mykill
oracle> ./mykill
oracle>. ./mykill
oracle> 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 '用ipcrm -m 命令来从UNIX中释放占用的RAM内存
dragon1> ipcrm -m 1028