出现ORA-12541:TNS:无监听程序解决方案-蒲公英云

出现ORA-12541:TNS:无监听程序解决方案

这个问题一般是oracle服务的监听挂掉了：查询oracle监听的状态，如果挂掉了，重启即可。也有可能是数据库也挂掉了，那样的话需要重启数据库。

1.首先进入oralce用户：

su - oracle

2.查询当前数据库的状态

ps -ef|grep ora_smon*

如果发现当前没有oracle进程，则是oracle数据库挂了。

如果数据库没有挂，应该显示信息如下所示：

oracle    5382     1  0 17:02 ?        00:00:00 ora_smon_testdb
oracle    8450  4593  0 17:25 pts/0    00:00:00 grep ora_smon*

3.如果数据库挂了，需要重启数据库，首先进入数据库

sqlplus "cmbcnetuser/Cmbc,1234. as sysdba"

进入oracle命令行：

SQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 19 17:02:35 2019
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>

4.然后重启即可

SQL> startup

结果显示：

ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size     2255832 bytes
Variable Size   620758056 bytes
Database Buffers 1862270976 bytes
Redo Buffers   20054016 bytes
Database mounted.
Database opened.

5.然后输入exit退出

SQL> exit

6.然后看看数据库还是显示有刚刚那个“ORA-12541无监听程序”的问题，就先

查看oracle监听程序的状态：

//查询oracle监听状态

[oracle@V_wangshenweb01 ~]$ lsnrctl status

结果：

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-FEB-2019 17:05:21
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

7.说明oracle监听挂掉了，重启监听

[oracle@V_wangshenweb01 ~]$ lsnrctl start

8.再次查看oracle监听状态

[oracle@V_wangshenweb01 ~]$ lsnrctl status

结果：

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-FEB-2019 17:12:54
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                19-FEB-2019 17:09:19
Uptime                    0 days 0 hr. 3 min. 34 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/db/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File         /home/db/oracle/diag/tnslsnr/V_wangshenweb01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=V_wangshenweb01)(PORT=1521)))
Services Summary...
Service "testdb" has 1 instance(s).
  Instance "testdb", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
  Instance "testdb", status READY, has 1 handler(s) for this service...
The command completed successfully