sqlplus中prelim / as sysdba宕機且無法進入怎么辦

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

遇到一個系統，數據庫無法正常運行，查看數據庫的進程發現數據庫已宕，結果如下：

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

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

用超級管理員用戶登錄數據庫時，系統報 ORA-00020 的錯誤，很奇怪，數據庫未啟動，還報進程數超上限的錯誤。

[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 錯誤，加大processes的參數值即可，但是需要正常啟動數據庫并成功登陸后才能修改，但是現在數據庫都無法正常啟動，一時想不到解決方法，最后求助資深DBA解決，方法如下：

首先通過加參數 “-prelim” 成功登陸數據庫

[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> 

此時就可以正常關閉和開啟數據庫，安裝如下命令操作解決問題：

shutdown immediate;

startup;

show parameter processes;

alter system set processes=1000 scope=spfile;

startup force;

show parameter processes;

exit;

************************************************************************************************
未完全關閉數據庫導致ORA-01012: not logged的解決
首先使用SHUTDOWN NORMAL方式關閉數據庫，在數據庫未關閉時CTRL+Z停止執行，退出用SQLPLUS重登陸，出現報錯：ORA-01012: not logged on

實驗如下：

首先執行

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.

解決方法：

找到進程，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宕機且無法進入怎么辦”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注億速云行業資訊頻道！