ERR--今天連StandbyDB遇到ORA-12500

最新推荐文章于 2021-04-10 04:40:07 发布

cuifan5176

最新推荐文章于 2021-04-10 04:40:07 发布

阅读量98

点赞数

因測試用的standby db上還有其實的應用，不知道在什么時候做了重啟。當在CMD的方式下做connect的時候遇到ora-12500的error.

檢查及解決全過程
1.出錯信息的產生
C:Documents and SettingsAdministrator>sqlplus /nolog

SQL> conn sys/password@standby as sysdba
ERROR:
ORA-12500: TNS:監聽器無法啟動專用伺服器處理作業

SQL>

12500, 00000, "TNS:listener failed to start a dedicated server process"
// *Cause: The process of starting up a dedicated server process failed.
// The executable could not be found or the environment may be set up
// incorrectly.
// *Action: Turn on tracing at the ADMIN level and reexecute the operation.
// Verify that the ORACLE Server executable is present and has execute
// permissions enabled. Ensure that the ORACLE environment is specified
// correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
// called may not be installed on the local hard drive. Please check that
// the correct Protocol Adapter are successfully linked.
// If error persists, contact Oracle Customer Support.

2.檢查lsnrctl狀態，并啟動
C:Documents and SettingsAdministrator>lsnrctl start

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-5月 -2005 11:42:37

正在啟動 tnslsnr: 請稍候...

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
系統參數檔案是 D:oracleora92networkadminlistener.ora
日誌訊息寫入至D:oracleora92networkloglistener.log
監聽之處: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.225)(PORT=1521)))

監聽之處: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC0ipc)))

連線至 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.60.225)(PORT=1521)))
LISTENER 的 STATUS
------------------------
別名                     LISTENER
版本                   TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
啟動日期                05-5月 -2005 11:42:40
正常咦鲿r間                    0 days 0 hr. 0 min. 2 sec
追蹤級次               off
安管                  OFF
SNMP                      OFF
監聽器參數檔案   D:oracleora92networkadminlistener.ora
監聽器日誌檔         D:oracleora92networkloglistener.log
監聽終止點摘要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.225)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC0ipc)))
服務摘要...
服務 "PLSExtProc" 有 1 個執行處理.
執行處理 "PLSExtProc", 狀態 UNKNOWN, 有 1 個此服務的處理程式...
服務 "orcl9i.vongates.com" 有 1 個執行處理.
執行處理 "orcl9i", 狀態 UNKNOWN, 有 1 個此服務的處理程式...
命令順利地完成

C:Documents and SettingsAdministrator

3.確認Windows中的SID的service是啟動的。
C:>net start OracleServiceorcl9i
OracleServiceorcl9i 服務正在啟動 .
OracleServiceorcl9i 服務已經啟動成功。

C:>

4.重新connect并啟動standby DB

SQL> conn sys/password@standby as sysdba
連線至閒置的執行處理.
SQL> startup nomount;
已啟動 ORACLE 執行處理.

Total System Global Area 227613456 bytes
Fixed Size                   453392 bytes
Variable Size              75497472 bytes
Database Buffers          150994944 bytes
Redo Buffers                 667648 bytes
SQL> alter database mount standby database;

已更改資料庫.

SQL> alter database recover managed standby database disconnect from session;

已更改資料庫.

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29987/viewspace-51775/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29987/viewspace-51775/