這篇文章主要介紹sqlplus中prelim / as sysdba宕機(jī)且無(wú)法進(jìn)入怎么辦，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！
我們提供的服務(wù)有：網(wǎng)站設(shè)計(jì)制作、網(wǎng)站設(shè)計(jì)、微信公眾號(hào)開(kāi)發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、博樂(lè)ssl等。為成百上千家企事業(yè)單位解決了網(wǎng)站和推廣的問(wèn)題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的博樂(lè)網(wǎng)站制作公司
遇到一個(gè)系統(tǒng)，數(shù)據(jù)庫(kù)無(wú)法正常運(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ù)都無(wú)法正常啟動(dòng)，一時(shí)想不到解決方法，最后求助資深DBA解決，方法如下：
首先通過(guò)加參數(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)閉和開(kāi)啟數(shù)據(jù)庫(kù)，安裝如下命令操作解決問(wèn)題：
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ī)且無(wú)法進(jìn)入怎么辦”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！
重慶分公司
重慶分公司
