首页 > 开发 > 综合 > 正文

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

2024-07-21 02:36:00
字体:
来源:转载
供稿:网友

  现象:
  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 -efgrep oracle9grep _rac1grep -v grepawk '{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
  然后就可以起来了。

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表