TNS-12555: TNS:permission denied

执行lsnrctl start命令监听时,有时会报如下错误:

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
   Linux Error: 1: Operation not permitted

这种情况就是某些文件权限问题啦,可以查看/var/tmp目录下文件:

[oracle@fund-rac1 tmp]$ pwd
/var/tmp
[oracle@fund-rac1 tmp]$ ll -a
total 12
drwxrwxrwt.  3 root root 4096 Feb 19 11:53 .
drwxr-xr-x. 20 root root 4096 Feb 25 16:25 ..
drwxrwxrwt   2 root root 4096 Feb 12 21:20 .oracle
[oracle@fund-rac1 tmp]$ cd ./.oracle/
[oracle@fund-rac1 .oracle]$ ll
total 0
srwxrwxrwx 1 xx_oracle xx_oracle 0 Feb 12 21:20 s#30472.1
srwxrwxrwx 1 xx_oracle xx_oracle 0 Feb 12 21:20 s#30472.2
srwxrwxrwx 1 xx_oracle dba         0 Jan 13 12:22 s#881.1
srwxrwxrwx 1 xx_oracle dba         0 Jan 13 12:22 s#881.2
srwxrwxrwx 1 xx_oracle xx_oracle 0 Feb 12 21:20 sEXTPROC1521

这里的xx_oracle是我之前操作的用户,现在是直接改成oracle了,去掉了前面的一部分,所以这里只要把/var/tmp/.oracle目录下所有文件所有者都改成oracle就好啦!

sudo chown -R oracle:oinstall ./*

用户组也相应修改了,搞定!


版权声明:本文为yang1018679原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。