Oracle lsnrctl无法启动处理过程
故障现象:
listener无法启动
-bash-3.2$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on
08-MAY-2009 17:54:52
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /test/oracle/oracle/product/10.2.0/db_3/bin/tnslsnr:
please wait…
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is
/test/oracle/oracle/product/10.2.0/db_3/network/admin/listener.ora
Log messages written to
/test/oracle/oracle/product/10.2.0/db_3/network/log/listener.log
Error listening on:
(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable
www.2cto.com
处理过程:
1.排除语法问题
重建了listener.ora,依然无法启动
2.检查其它
检查listener.ora,sqlnet.ora以及其它文件没发现异常
3.启动trace跟踪
listener.ora增加:
TRACE_LEVEL_LISTENER=16
查看trc文件
……
[08-MAY-2009 18:06:15:862] sntuscrt: failed to create dir
/var/tmp/.oracle
[08-MAY-2009 18:06:15:863] sntuscrt: exit
[08-MAY-2009 18:06:15:863] snlsodx_lookup: entry
[08-MAY-2009 18:06:15:863] snlsodx_lookup: Can't open shared
object library
……
起初以为是权限不足,赋予权限,手工touch /var/tmp/.oracle文件没问题
比对其它系统,才发现没仔细看,原来上面已经很清楚了。oracle是一个目录
mkdir .oracle报错:空间不足
找到真正原因。
总结: www.2cto.com
1.不细心,起初在Error listening on:
(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))提示信息
迷失方向,后来没仔细看文件夹提示,更要命的是,压根没注意系统的情况。毕竟预先假设测试服务器系统没问题。
事后疑问:为啥报错不明示空间不足那?应该可以做到的!
2.trace监听
1)。TRACE_LEVEL_LISTENER=16
2)。lsnrctl trace 16
3)。trcasst格式化Oracle Net 服务产生的trace文件
Doc ID: 779226.1
Subject: Troubleshooting Oracle Net
Doc ID: 219968.1
SQL*Net, Net8, Oracle Net Services - Tracing and Logging at a
Glance
TRACE_LEVEL_LISTENER = USER
TRACE_DIRECTORY_LISTENER =
/opt/oracle/product/9ir2/network/trace
TRACE_FILE_LISTENER = LISTENER1.trc