连接linux数据库Oracle时报错ORA-12541: TNS: 无监听程序-CSDN博客

1、远程登录服务器
输入远程账号 root （回车），然后输入密码

2、查看oracle 端口是否存在，查看命令如下

netstat -ntlp

3、登录Oracle

su – oracle
sqlplus  "/as sysdba"

原本的画面会变为
SQL>
4、启动oracle

SQL> startup

SQL> exit

查看oracle 监听状态

lsnrctl status

启动监听

lsnrctl start

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/
————————————————
版权声明：本文为CSDN博主「布丁很胖」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/li66934791/article/details/84337897