oracle listener 監聽啟動不起來處理案例一則
環境: oracle 10.2.0.4 +AIX 6.1
問題: 監聽啟動不成功
$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 26-OCT-2011 07:37:20
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /software/oracle/product/10.2/db_1/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
IBM/AIX RISC System/6000 Error: 29: Illegal seek
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
IBM/AIX RISC System/6000 Error: 29: Illegal seek
ps -ef|grep tns
監聽程式不存在
處理過程
用netca刪除監聽和重配監聽
配置監聽時提示已經在執行
檢查/etc/hosts檔案
#127.0.0.1 loopback localhost # loopback (lo0) name/address
120.1.1.65 db10-new
發現127.0.0.1已經註釋掉
取消註釋,顯示如下:
127.0.0.1 loopback localhost # loopback (lo0) name/address
120.1.1.65 db10-new
啟動監聽成功:
$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 26-OCT-2011 07:37:50
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /software/oracle/product/10.2/db_1/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /oracle/product/10.2/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db10-new)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
System parameter file is /oracle/product/10.2/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db10-new)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db10-new)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 26-OCT-2011 07:37:52
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db10-new)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 26-OCT-2011 07:37:52
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db10-new)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-709656/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle啟動案例一則Oracle
- oracle listener 靜態監聽與動態監聽的一些小事Oracle
- 【listener】oracle靜態監聽和動態監聽 【轉載】Oracle
- oracle動態和靜態監聽listenerOracle
- TNS監聽起不來的原因分析
- ORACLE啟動監聽器 The listener supports no services 問題解決方法Oracle
- Oracle 監聽異常處理Oracle
- 一節點啟動不起來(ocssd)CSS
- oracle rac 其中第一個節點監聽偶爾中斷處理案例Oracle
- 動態註冊監聽Listener
- 比較罕見的一個問題,磁碟檔案數目太多導致的LISTENER監聽起不來
- 【LISTENER】Oracle監聽TNS-12545及TNS-00515錯誤處理一例Oracle
- ORACLE listener監聽設定密碼Oracle密碼
- Oracle啟動兩個監聽Oracle
- linux 111 錯誤 監聽起不來Linux
- ORACLE之手動註冊監聽listener。alter system set local_listener="XXX"Oracle
- 設定 Oracle 監聽器密碼(LISTENER)Oracle密碼
- 【故障處理】【LISTENER】主機名修改為IP地址後LISTENER無法監聽到例項
- 【LISTENER】謹防相同的 IPC key導致多監聽無法啟動--TNS-1106故障處理
- Oracle監聽日誌2g-監聽啟動報錯Oracle
- listener監聽監控指令碼指令碼
- oracle case處理案例(一)Oracle
- 自動重新啟動oracle監聽程式 for windowsOracleWindows
- Oracle監聽啟動後自動關閉Oracle
- 啟動監聽報TNS-01150錯誤處理
- oracle 監聽器動態與靜態註冊服務_listenerOracle
- rac scan listener log 清理監聽日誌 oracleOracle
- Oracle資料庫修改LISTENER的監聽埠Oracle資料庫
- Oracle監聽服務無法啟動Oracle
- oracle 監聽重啟Oracle
- TNS-12537監聽程式啟不來
- 一次Oracle監聽無法動態註冊處理過程排查分析Oracle
- 【LISTENER】Oracle通過監聽連線緩慢分析Oracle
- 【LISTENER】修改 LISTENER的監聽埠為1526(動態註冊)
- oracle監聽器日誌過大-處理辦法Oracle
- ORACLE動態監聽與靜態監聽Oracle
- oracle靜態監聽和動態監聽Oracle
- 【oracle】動態監聽與靜態監聽Oracle