oracle10g的一個老專案,突然資料庫就進不去了。sqlplus 登錄輸入賬號密碼,等好久,提示12560錯誤。請問大佬這應該怎么解決。
uj5u.com熱心網友回復:
sqlplus "/as sysdba"看看上面的,能進去不?
把你之前的實驗,截個圖上來。
uj5u.com熱心網友回復:
版主好
Listener:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXXXX)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
——————————————————
tnsnames:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HWSERVER10)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXXXX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
__________________________________________
也用過sqlplus / as sysdba登陸過,和正常登陸一樣,等半天提示12560
uj5u.com熱心網友回復:
你確定你的監聽服務正常啟動了,或者你重新啟動下監聽服務uj5u.com熱心網友回復:
這種操作不下十次了。。。。
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/36496.html
標籤:基礎和管理
上一篇:Oracle中Null與0的區別
