oracle监听启动报错

最新推荐文章于 2024-09-05 09:52:46 发布

布丁很胖

最新推荐文章于 2024-09-05 09:52:46 发布

阅读量958

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/li66934791/article/details/84337897

版权

oracle 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

现象：

lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-NOV-2018 13:35:12

Starting /u01/app/oracle/product/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0//network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jituan-nc-test01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.102.54)(PORT=1521)))
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...

问题解决

查看权限

[root@jituan-nc-test01 ~]# ls -lrtd /var/tmp/.oracle/
drwxrwxrwt 2 root root 4096 Nov 22 13:35 /var/tmp/.oracle/

更改权限

# chown -R oracle.oinstall /var/tmp/.oracle/

重启服务

lsnrctl reload

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-NOV-2018 13:42:19

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jituan-nc-test01.bjzbvm)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 22-NOV-2018 13:42:05
Uptime 0 days 0 hr. 0 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0//network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/jituan-nc-test01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jituan-nc-test01.bjzbvm)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully