重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 启动监听报错TNS-12555: TNS:permission denied [打印本页]

作者: monkeybird 时间: 2013-3-20 12:56
标题: 启动监听报错TNS-12555: TNS:permission denied

$ lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 20-MAR-2013 12:50:58

Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver2)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
IBM/AIX RISC System/6000 Error: 1: Not owner

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

今天在启动监听时报了以上错误信息，解决办法：

经了解，是关于/var/tmp目录下的.oracle文件权限

[oracle@oracle tmp]$ ls -al
total 12
drwxrwxrwt 3 root root 4096 Nov 13 15:32 .
drwxr-xr-x 22 root root 4096 Aug 25 2011 ..
drwxrwxrwt 2 root root 4096 Nov 13 15:30 .oracle (注意这个文件是隐藏文件)
chmod 777 /var/tmp/.oracle

或者是

[oracle@oracle tmp]$ chown -R oracle.dba .oracle/

问题解决

如何以上方法不行，就只有重新创建监听。

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)