Oracle监听起步故障诊断
日期：2014-05-16 浏览次数：20422 次
Oracle监听启动故障诊断
凌晨2:02分，还在电信机房奋斗。闲来无事，再写一篇文章。
在linux 32位环境下，启动监听出现如下故障
其中监听配置如下，并没有问题
根据提示：
凌晨2:02分，还在电信机房奋斗。闲来无事，再写一篇文章。
在linux 32位环境下，启动监听出现如下故障
引用
[oracle@hzmc admin]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 02-MAR-2011 23:37:53
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oracle/app/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
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 02-MAR-2011 23:37:53
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oracle/app/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
其中监听配置如下，并没有问题
引用
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hzmc)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9i)
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = ora9i)
)
(SID_DESC =
(GLOBAL_DBNAME = active)
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = active)
)
(SID_DESC =
(GLOBAL_DBNAME = king)
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = king)
)
)
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hzmc)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9i)
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = ora9i)
)
(SID_DESC =
(GLOBAL_DBNAME = active)
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = active)
)
(SID_DESC =
(GLOBAL_DBNAME = king)
(ORACLE_HOME = /oracle/app/oracle/product/9.2.0)
(SID_NAME = king)
)
)
根据提示：
引用
Linux Error: 32: Broken pipe
管道发生错误，猜测应该是Oracle写监听日志时出现故障，查看监听日志发现已经达到2G，将其清空，监听启动正常。引用
-rwxrwxr-x 1 oracle oinstall 2147483647 Dec 22 10:48 listener.log
[oracle@hzmc log]$ >listener.log
[oracle@hzmc network]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 02-MAR-2011 23:39:14
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oracle/app/oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hzmc)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hzmc)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 02-MAR-2011 23:39:14
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/9.2.0/network/admin/listener.ora
Listener
[oracle@hzmc log]$ >listener.log
[oracle@hzmc network]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 02-MAR-2011 23:39:14
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oracle/app/oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hzmc)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hzmc)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 02-MAR-2011 23:39:14
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/9.2.0/network/admin/listener.ora
Listener
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
