CNDBA社区
启动监听 TNS-00525 Insufficient privilege for operation 错误处理方法
作者：
dave
启动监听报错：
[ora11g@cndba.cn trace]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-MAR-2016 22:57:46 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /u11/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u11/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u11/app/oracle/diag/tnslsnr/dave1/listener/alert/log.xml 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 Listener failed to start. See the error message(s) above...
这里的测试环境上我安装了2个版本的Oracle。 Oracle 11g 和 Oracle 12c。
Oracle 12c 的安装用户是oracle。 Oracle 11g 的安装用户是ora11g。
这里提示权限不足，需要检查如下2个位置：/tmp/.oracle 和 /var/tmp/.oracle。
将其修改当前启用环境的用户:ora11g.
[root@cndba.cn tmp]# pwd /var/tmp [root@cndba.cn tmp]# ll -la total 16 drwxrwxrwt. 4 root root 4096 Mar 25 12:21 . drwxr-xr-x. 23 root root 4096 Dec 28 14:15 .. drwxrwxrwt 2 root root 4096 Mar 30 22:53 .oracle drwxr-x--- 3 oracle oinstall 4096 Mar 1 17:39 oradiag_oracle -rw-rw-rw- 1 root root 0 Dec 28 16:24 srp_daemon_mlx4_0_1 -rw-rw-rw-. 1 root root 0 Dec 28 14:25 srp_daemon_mlx4_0_2 [root@cndba.cn tmp]# chown -R ora11g:oinstall /var/tmp/.oracle [root@cndba.cn tmp]#
然后启动就正常了：
[ora11g@cndba.cn ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-MAR-2016 23:00:06 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /u11/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u11/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u11/app/oracle/diag/tnslsnr/dave1/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.230)(PORT=1522))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 30-MAR-2016 23:00:07 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u11/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u11/app/oracle/diag/tnslsnr/dave1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.230)(PORT=1522))) The listener supports no services The command completed successfully [ora11g@cndba.cn ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-MAR-2016 23:01:41 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 30-MAR-2016 23:00:07 Uptime 0 days 0 hr. 1 min. 33 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u11/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u11/app/oracle/diag/tnslsnr/dave1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.230)(PORT=1522))) Services Summary... Service "anqing" has 1 instance(s). Instance "anqing", status READY, has 1 handler(s) for this service... Service "anqingXDB" has 1 instance(s). Instance "anqing", status READY, has 1 handler(s) for this service... The command completed successfully [ora11g@cndba.cn ~]$
版权声明：本文为博主原创文章，未经博主允许不得转载。
