一、查监听状态–blocked
[oracle@edbjr2p1 ~]$ lsnrctl status
Service “PROD1.us.oracle.com” has 2 instance(s).
Instance “PROD1”, status UNKNOWN, has 1 handler(s) for this service…
Instance “PROD1”, status BLOCKED, has 4 handler(s) for this service…
二、查进程
[oracle@edbjr2p1 ~]$ ps -ef | grep ora_dbw0_PROD1
oracle 9369 1 0 06:33 ? 00:00:00 ora_dbw0_PROD1
oracle 10626 10400 0 06:43 pts/4 00:00:00 grep ora_dbw0_PROD1
三、杀进程
格式:kill -9 pid
[oracle@edbjr2p1 ~]$ kill -9 9369
四、再查进程
[oracle@edbjr2p1 ~]$ ps -ef | grep ora_dbw0
oracle 9624 1 0 06:33 ? 00:00:00 ora_dbw0_PROD2
oracle 10821 10400 0 06:47 pts/4 00:00:00 grep ora_dbw0
五、启库
[oracle@edbjr2p1 ~]$ export ORACLE_SID=PROD1
[oracle@edbjr2p1 ~]$ sqlplus / as sysdba
SYS@PROD1>startup
SYS@PROD1>startup nomount; ORA-01012: not logged on或ORA-01075: you are currently logged o
最新推荐文章于 2021-04-12 03:22:59 发布