:~> 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. 查看监听日志
> 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日志
:~> cat /dev/null > listener.log
4. 启动监听
oracle@SHSH-PS> 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
数据库连接正常