Oracle監聽日誌2g-監聽啟動報錯

oracle@SHSH-PS:~> lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 29-OCT-2012 17:14:26

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

Starting /opt/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNS-12547: TNS:lost contact
 TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   Linux Error: 32: Broken pipe

2. 檢視監聽日誌

oracle@SHSH-PS:~/product/9.2.0/network/log> ls -ltrh
total 2.1G
-rw-r--r-- 1 oracle oinstall    0 2004-02-18 15:59 z
-rw-r--r-- 1 oracle oinstall 2.0G 2012-10-29 16:41 listener.log

3.清空listener.log日誌

oracle@SHSH-PS:~> cat /dev/null > listener.log

4. 啟動監聽
oracle@SHSH-PS:~/product/9.2.0/network/log> lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 29-OCT-2012 17:18:54

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

Starting /opt/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SHSH-PS-WAP1-STAT05)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                29-OCT-2012 17:18:54
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File         /opt/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SHSH-PS-WAP1-STAT05)(PORT=1521)))
Services Summary...
Service "CMCCWAP" has 1 instance(s).
  Instance "CMCCWAP", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

資料庫連線正常