ORA-12500: TNS:listener failed to start a dedicated server process

paulyibinyi發表於2007-12-20

今天早上連到standby資料庫時,報以下錯誤 


alert_paul.log 記錄的更詳細

ORA-12500: TNS:listener failed to start a dedicated server process

*** 2007-12-20 10:12:41.629
Error 12500 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'test'
Error 12500 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'test'
Heartbeat failed to connect to standby 'test'. Error is 12500.

 ORA-12500 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 re-execute 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. Check that the correct Protocol Adapter are successfully linked. If the error persists, contact Oracle Support Services.

因為oracle資料庫是執行在windows下 檢查下oracleservicetest服務沒起來,而且啟動型別為手動

手工啟動後,並且改為自動,就一切正常 記錄下 

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-923/,如需轉載,請註明出處,否則將追究法律責任。

相關文章