执行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 ./*
用户组也相应修改了,搞定!