|
作者提出的问题是这样的：
一台测试的服务器，停电再起来后发现listener起不来，报错如下：
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.191.100)(PORT=1521)))
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.191.100)(PORT=1521)))
TNS-12549: TNSperating system resource quota exceeded
TNS-12560: TNSrotocol adapter error
TNS-00519: Operating system resource quota exceeded
Linux Error: 28: No space left on device
对于这个提示，一般的直觉反映是磁盘空间用完了，不过这个错误肯定大家都能发现：
首先查看log文件，已经2G了，打开看看日志里面也没发现什么异常，认为日志是自然增长到这么大的，于是直接cat /dev/null>listener.log把日志清空。然后listener还是起不来，仍然报上面的错误。之后重启机器，还是不行，检查磁盘空间也没有问题。
?
显然没这么简单，以前的一些经验，当系统信号量不足时也可能导致这类错误提示。
不过作者最后发现的问题是inode耗尽。
在Linux上，我们可以用df -i来查看inode的分配情况：
[
[email?protected] elog]$ df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/hda3 131616 25376 106240 20% /
/dev/hda1 66264 35 66229 1% /boot
/dev/hda5 1048576 37166 1011410 4% /data1
/dev/hda9 294336 6020 288316 3% /home
/dev/hda6 1048576 20467 1028109 2% /opt
none 64193 1 64192 1% /dev/shm
/dev/hda8 524288 87362 436926 17% /usr
/dev/hda7 524288 1598 522690 1% /var
?
如果inode耗尽，则系统上将不能创建文件。监听器就可能无法启动。
作者当时耗尽的/var下的inode，那么Oracle监听器是否需要使用var下的空间呢？
我们看一下测试：
[
[email?protected] tmp]$ strace -o lsnrctl.log lsnrctl start
?
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 09-JUL-2007 15:45:09
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=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.33.11)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
umovestr: Input/output error
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 09-JUL-2007 15:45:09
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=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.33.11)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc",status UNKNOWN,has 1 handler(s) for this service...
Service "eygle" has 1 instance(s).
Instance "eygle",has 1 handler(s) for this service...
Service "julia" has 1 instance(s).
Instance "eygle",has 1 handler(s) for this service...
The command completed successfully
?
检查一下跟踪文件：
[
[email?protected] tmp]$ grep var lsnrctl.log?
execve("/opt/oracle/product/9.2.0/bin/lsnrctl",["lsnrctl","start"],[/* 33 vars */]) = 0
connect(4,{sa_family=AF_UNIX,path="/var/run/.nscd_socket"},110) = -1 ENOENT (No such file or directory)
access("/var/tmp/.oracle",F_OK) = 0
access("/var/tmp/.oracle/sEXTPROC",F_OK) = 0
connect(4,path="/var/tmp/.oracle/sEXTPROC"},110) = 0
? （编辑：晋中站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
