Oracle 监听器无法启动（TNS-12555，TNS-12560，TNS-00525）

用户1154259

发布于 2018-01-18 11:26:28

1.3K0

发布于 2018-01-18 11:26:28

文章被收录于专栏：xingoo, 一个梦想做发明家的程序员xingoo, 一个梦想做发明家的程序员

启动监听器无法打开，报错！

 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 - Production
10 System parameter file is /opt/oracle/11g/network/admin/listener.ora
11 Log messages written to /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
12 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
13 TNS-12555: TNS:permission denied
14  TNS-12560: TNS:protocol adapter error
15   TNS-00525: Insufficient privilege for operation
16    Linux Error: 1: Operation not permitted
17 
18 Listener failed to start. See the error message(s) above...

观察发现，提示没有权限：

查看.oracle文件：

[root@localhost ~]# ls -lrtd /var/tmp/.oracle
drwxrwxrwt. 2 root root 4096 8\u6708   5 21:48 /var/tmp/.oracle
[root@localhost ~]# ls -lrtd /tmp/.oracle
drwxrwxrwt. 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/.oracle
drwxrwxrwt. 2 oracle dba 4096 8\u6708   5 20:33 /tmp/.oracle
[root@localhost ~]# ls -lrtd /var/tmp/.oracle
drwxrwxrwt. 2 oracle dba 4096 8\u6708   5 21:48 /var/tmp/.oracle

再次启动，成功！

本文参与腾讯云自媒体分享计划，分享自作者个人站点/博客。

原始发表：2014-08-06 ，如有侵权请联系 cloudcommunity@tencent.com 删除

oracle