oracle启动监听无权限,/tmp文件系统无权限导致监听listener启动失败

启动监听失败：

cli19-hx8uat$lsnrctl start TPI3HX8

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 23-FEB-2016 11:41:10

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /orahome/app/oracle/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production

System parameter file is /orahome/app/oracle/network/admin/listener.ora

Log messages written to /orahome/app/oracle/network/log/tpi3hx8.log

Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.104.119)(PORT=3526)))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

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

cli19-hx8uat$

查看日志：

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 23-FEB-2016 10:32:45

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

System parameter file is /orahome/app/oracle/network/admin/listener.ora

Log messages written to /orahome/app/oracle/network/log/tpi3ww8.log

Trace information written to /orahome/app/oracle/network/trace/tpi3ww8.trc

Trace level is currently 0

Started with pid=5963812

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.104.119)(PORT=3525)))

Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.104.119)(PORT=3525)))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

没有有效信息，查看trc文件/orahome/app/oracle/network/trace/tpi3ww8.trc提示不存在。

从网上查到，可能是缺少目录： /var/tmp/.oracle

经查，此目录是存在的：

cli19-hx8uat$ls -al /var/tmp

total 360

drwxrwxrwt    3 bin      bin            4096 Feb 23 12:34 .

drwxr-xr-x   36 bin      bin            4096 Mar 30 2015  ..

drwxrwxrwt    2 root     system          256 Aug 12 2014  .oracle

于是，想trace一下监听启动过程，listener.ora增加参数：

TRACE_LEVEL_LISTENER=16

但启动还是报错，且trace level还是保持为0，并没有设置为16，奇怪.

这时，我想查看一下操作系统版本，却发现：

cli19-hx8uat$oslevel

/usr/bin/oslevel[627]: /tmp/sh7012526.13: 0403-005 Cannot create the specified file.

原来是/tmp路径下无权限！

找系统管理员授予权限后，监听启动正常。