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

曾经终败给现在 2022-03-18 06:35 3462阅读 0赞

这个问题一般是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：监听状态