關(guān)于數(shù)據(jù)庫無法進(jìn)入nomount狀態(tài)狀態(tài)的問題

guzhengming

我的數(shù)據(jù)庫版本是Oracle9i Enterprise Edition Release 9.2.0.1.0，在CMD下登陸sqlplus sys/* as sysdba后再輸入startup nomount卻提示錯誤如下：
SQL> startup nomount
ORA-00106: 無法在連接到調(diào)度程序時啟動/關(guān)閉數(shù)據(jù)庫
請問這是為什么？謝謝！

jieyancai

00106, 00000, "cannot startup/shutdown database when connected to a dispatcher"
//  *Cause: An attempt was made to startup/shutdown database when connected to
//          a shared server via a dispatcher.
// *Action: Re-connect as user INTERNAL without going through the dispatcher.
//          For most cases, this can be done by connect to INTERNAL without
//          specifying a network connect string.

guzhengming

請問這是什么意思？是不是用普通用戶再登一遍就好？可是我試了用SYS用戶及普通用戶都會顯示這樣的錯誤這是為何？

numenhuang

是不是一臺服務(wù)器上有多個數(shù)據(jù)庫實例在運(yùn)行？

1. set ORACLE_SID=xxxx

2. sqlplus / as sysdba

guzhengming

恩有兩個數(shù)據(jù)庫實例，但是我把其中一個數(shù)據(jù)庫服務(wù)關(guān)上再重復(fù)上面步驟，還是那樣，而且只要用conn / as sysdba連上后就已經(jīng)是open狀態(tài)，輸入shutdown immediate或shutdown abort都會顯示相同的錯誤。用alter database nomount也還會出現(xiàn)此錯誤：ORA-00106: 無法在連接到調(diào)度程序時啟動/關(guān)閉數(shù)據(jù)庫。

numenhuang

SET ORACLE_SID？

jieyancai

set ORACLE_SID=xxxx