ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ERR--今天連StandbyDB遇到ORA-12500

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

原创 Linux操作系统 作者:vongates 时间:2019-05-12 09:45:05 0 删除 编辑

因測試用的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

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

正在啟動 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    448
  • 访问量
    290310