首页 > 代码库 > Oracle 监听器无法启动(TNS-12555,TNS-12560,TNS-00525)
Oracle 监听器无法启动(TNS-12555,TNS-12560,TNS-00525)
启动监听器无法打开,报错!
1 [oracle@localhost ~]$ lsnrctl start 2 3 LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-AUG-2014 19:40:52 4 5 Copyright (c) 1991, 2009, Oracle. All rights reserved. 6 7 Starting /opt/oracle/11g/bin/tnslsnr: please wait... 8 9 TNSLSNR for Linux: Version 11.2.0.1.0 - Production10 System parameter file is /opt/oracle/11g/network/admin/listener.ora11 Log messages written to /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml12 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))13 TNS-12555: TNS:permission denied14 TNS-12560: TNS:protocol adapter error15 TNS-00525: Insufficient privilege for operation16 Linux Error: 1: Operation not permitted17 18 Listener failed to start. See the error message(s) above...
观察发现,提示没有权限:
查看.oracle文件:
[root@localhost ~]# ls -lrtd /var/tmp/.oracledrwxrwxrwt. 2 root root 4096 8\u6708 5 21:48 /var/tmp/.oracle[root@localhost ~]# ls -lrtd /tmp/.oracledrwxrwxrwt. 2 root root 4096 8\u6708 5 20:33 /tmp/.oracle
发现权限虽然是777,但是用户组和所有者不对,改成oracle:dba
[root@localhost ~]# chown -R oracle:dba /var/tmp/.oracle[root@localhost ~]# chown -R oracle:dba /tmp/.oracle[root@localhost ~]# ls -lrtd /tmp/.oracledrwxrwxrwt. 2 oracle dba 4096 8\u6708 5 20:33 /tmp/.oracle[root@localhost ~]# ls -lrtd /var/tmp/.oracledrwxrwxrwt. 2 oracle dba 4096 8\u6708 5 21:48 /var/tmp/.oracle
再次启动,成功!
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。