Oracle监听日志2g-监听启动报错

 

32bit suse linux 10 oracle 9.2.4版本

 

1.监听启动，报错：

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 数据库连接正常

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17252115/viewspace-747853/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17252115/viewspace-747853/