出现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:TNS:无监听程序”的问题，就先

查看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

 

 

6.45服务器的数据库密码:Root@1234

lsnrctl start：开启监听

lsnrctl stop：关闭监听

lsnrctl status：监听状态