listener启不来，报TNS-12560: TNS:protocol adapter error Error: 2: No such file or directory

最新推荐文章于 2023-07-29 11:41:11 发布

unm_www

最新推荐文章于 2023-07-29 11:41:11 发布

阅读量4.1k

点赞数 1

文章标签： file oracle solaris socket sun list

本文链接：https://blog.csdn.net/unm_www/article/details/4331417

版权

在RHEL3 U2环境下，由于Oracle监听器无法启动，报错TNS-12560: TNS:protocol adapter error，错误代码2表示找不到文件或目录。创建/var/tmp/.oracle目录并授权给oracle用户，重启监听器后问题得到解决。

摘要由CSDN通过智能技术生成

建立 /var/tmp/.oracle 并授权给oracle，重起监听。问题解决！
补充一下我的环境是 RHEL3 U2 + oracle9204

原文来自：

十萬火急!!!! listener啟不啟來!!!

$ lsnrctl start

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 29-APR-2004 13:43:52

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Starting /export/home/oracle/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
System parameter file is /export/home/oracle/network/admin/listener.ora
Log messages written to /export/home/oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory