Troubleshooting ORA-01090: shutdown in progress,ORA-01081

发表于:2007-06-22来源:作者:点击数: 标签:
现象: SQL > shutdown immediate ORA-01090: shutdown in progress - connection is not permitted SQL> startup ORA-01081: cannot start a lr eady-running ORACLE - shut it down first 解决方法: dragon1> ps -ef|grep oracle 9|grep _rac1|grep -v gr

   
  现象:
  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
  然后就可以起来了。

原文转自:http://www.ltesting.net