oracle listener 監聽啟動不起來處理案例一則

paulyibinyi發表於2011-10-25
環境: 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
 
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)))
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
 
 
 

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

相關文章