sqlplus中prelim / as sysdba宕機(jī)且無法進(jìn)入怎么辦

這篇文章主要介紹sqlplus中prelim / as sysdba宕機(jī)且無法進(jìn)入怎么辦，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

遇到一個(gè)系統(tǒng)，數(shù)據(jù)庫(kù)無法正常運(yùn)行，查看數(shù)據(jù)庫(kù)的進(jìn)程發(fā)現(xiàn)數(shù)據(jù)庫(kù)已宕，結(jié)果如下：

[oracle@xiaowu ~]$ ps -ef | grep ora_

oracle 6218 6161 0 09:39 pts/2 00:00:00 grep ora_

用超級(jí)管理員用戶登錄數(shù)據(jù)庫(kù)時(shí)，系統(tǒng)報(bào) ORA-00020 的錯(cuò)誤，很奇怪，數(shù)據(jù)庫(kù)未啟動(dòng)，還報(bào)進(jìn)程數(shù)超上限的錯(cuò)誤。

[oracle@xiaowu ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 23 10:48:12 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:

ORA-00020:maximum number of processes (500) exceeded

Enter user-name:

解決 ORA-00020 錯(cuò)誤，加大processes的參數(shù)值即可，但是需要正常啟動(dòng)數(shù)據(jù)庫(kù)并成功登陸后才能修改，但是現(xiàn)在數(shù)據(jù)庫(kù)都無法正常啟動(dòng)，一時(shí)想不到解決方法，最后求助資深DBA解決，方法如下：

首先通過加參數(shù) “-prelim” 成功登陸數(shù)據(jù)庫(kù)

[oracle@xiaowu ~]$ sqlplus -prelim / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 23 11:10:09 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> 

此時(shí)就可以正常關(guān)閉和開啟數(shù)據(jù)庫(kù)，安裝如下命令操作解決問題：

shutdown immediate;

startup;

show parameter processes;

alter system set processes=1000 scope=spfile;

startup force;

show parameter processes;

exit;

************************************************************************************************
未完全關(guān)閉數(shù)據(jù)庫(kù)導(dǎo)致ORA-01012: not logged的解決
首先使用SHUTDOWN NORMAL方式關(guān)閉數(shù)據(jù)庫(kù)，在數(shù)據(jù)庫(kù)未關(guān)閉時(shí)CTRL+Z停止執(zhí)行，退出用SQLPLUS重登陸，出現(xiàn)報(bào)錯(cuò)：ORA-01012: not logged on

實(shí)驗(yàn)如下：

首先執(zhí)行

SYS@bys1>shutdown

ORA-01013: user requested cancel of current operation

[oracle@bys001 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 7 09:05:08 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected.

ERROR:

ORA-01012: not logged on

Process ID: 0

Session ID: 0 Serial number: 0

SYS@bys1>startup

ORA-01012: not logged on

SYS@bys1>conn / as sysdba

Connected to an idle instance.

ERROR:

ORA-01012: not logged on

Process ID: 0

Session ID: 0 Serial number: 0

SYS@bys1>conn bys/bys

ERROR:

ORA-01090: shutdown in progress - connection is not permitted

Process ID: 0

Session ID: 0 Serial number: 0

Warning: You are no longer connected to ORACLE.

解決方法：

找到進(jìn)程，kill掉就可以了。

[oracle@bys001 ~]$ ps -ef |grep ora_dbw0_

oracle    6519     1  0 Sep06 ?        00:00:15 ora_dbw0_bys1

oracle   20947 20924  0 09:08 pts/0    00:00:00 grep ora_dbw0_

[oracle@bys001 ~]$ kill -9 6519

[oracle@bys001 ~]$ ps -ef |grep ora_dbw0_

oracle   20949 20924  0 09:08 pts/0    00:00:00 grep ora_dbw0_

[oracle@bys001 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 7 09:08:22 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@bys1>startup

ORACLE instance started.

Total System Global Area  631914496 bytes

Fixed Size                  1338364 bytes

Variable Size             264242180 bytes

Database Buffers          360710144 bytes

Redo Buffers                5623808 bytes

Database mounted.

Database opened.

SYS@bys1>

以上是“sqlplus中prelim / as sysdba宕機(jī)且無法進(jìn)入怎么辦”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注億速云行業(yè)資訊頻道！