TNS-00525: Insufficient privilege for operation

启动监听程序出现错误 TNS:permission denied

1、启动

[oracle@test admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 16-JUL-2009 17:40:44

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

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

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(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

   Linux Error: 1: Operation not permitted

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

[oracle@test admin]$ 

2、检查/tmp/.oracle的权限，发现不正确

[root@test tmp]# ls -al

total 104

...

drwxrwxrwt   2 root   root      4096 Jul 16 14:53 .oracle

...

[root@test tmp]# chown -R  oracle.oinstall /tmp/.oracle

[root@test tmp]#

3、再次启动还是报错，于是检查/var/tmp/.oracle 权限，发现也有问题

[root@test tmp]# ll /var/tmp/.oracle 

total 0

srwxrwxrwx  1 501 oinstall 0 Apr 26 20:40 s#13042.1

srwxrwxrwx  1 501 oinstall 0 Apr 26 20:40 s#13042.2

srwxrwxrwx  1 501 oinstall 0 Jul  1 16:13 s#20818.1

srwxrwxrwx  1 501 oinstall 0 Jul  1 16:13 s#20818.2

srwxrwxrwx  1 501 oinstall 0 Oct  9  2008 s#4165.1

srwxrwxrwx  1 501 oinstall 0 Oct  9  2008 s#4165.2

srwxrwxrwx  1 501 oinstall 0 Apr 26 22:38 s#4433.1

srwxrwxrwx  1 501 oinstall 0 Apr 26 22:38 s#4433.2

srwxrwxrwx  1 501 oinstall 0 Apr 28  2008 s#5366.1

srwxrwxrwx  1 501 oinstall 0 Apr 28  2008 s#5366.2

srwxrwxrwx  1 501 oinstall 0 Mar 23  2008 s#5756.1

srwxrwxrwx  1 501 oinstall 0 Mar 23  2008 s#5756.2

srwxrwxrwx  1 501 oinstall 0 Nov 29  2007 s#6842.1

srwxrwxrwx  1 501 oinstall 0 Nov 29  2007 s#6842.2

srwxrwxrwx  1 501 oinstall 0 Jun 29 11:18 stestDBG_CSSD

srwxrwxrwx  1 501 oinstall 0 Oct  9  2008 sEXTPROC0

srwxrwxrwx  1 501 oinstall 0 Jun 29 11:18 sOCSSD_LL_test_localhost

srwxrwxrwx  1 501 oinstall 0 Jun 29 11:18 sOracle_CSS_LclLstnr_localhost_0

[root@test tmp]# cd ..

[root@test /]# chown -R oracle.oinstall /var/tmp/.oracle

再次启动，OK