Oracle监听启动故障诊断
凌晨2:02分，还在电信机房奋斗。闲来无事，再写一篇文章。
在linux 32位环境下，启动监听出现如下故障
Instance "active", status UNKNOWN, has 1 handler(s) for this service...
Service "king" has 1 instance(s).
Instance "king", status UNKNOWN, has 1 handler(s) for this service...
Service "ora9i" has 1 instance(s).
Instance "ora9i", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

至此我们不仅要问，当listener.log无权限访问时，会出现什么错误呢？
引用[root@hzmc log]# chown root:root listener.log
[root@hzmc log]# su - oracle
[oracle@hzmc ~]$ lsnrctl stop

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 03-MAR-2011 01:12:19

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.122.1)(PORT=1585)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@hzmc ~]$ ps -ef|grep tns
ora10g 27661 1 0 Mar02 ? 00:00:00 /ora10g/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
oracle 28779 28587 0 01:12 pts/1 00:00:00 grep tns
[oracle@hzmc ~]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 03-MAR-2011 01:12:28

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
NL-00280: error creating log stream /oracle/app/oracle/product/9.2.0/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above..