解决Linux下Oracle无法关闭数据库的问题

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