ORA-12547: TNS:lost contact+oracle 开启监听失败

最新推荐文章于 2023-08-21 10:57:30 发布

勤径苦舟

最新推荐文章于 2023-08-21 10:57:30 发布

阅读量4.3w

点赞数 5

分类专栏： oracle

本文链接：https://blog.csdn.net/zhou920786312/article/details/77600790

版权

oracle 专栏收录该内容

213 篇文章 2 订阅

订阅专栏

1、ORA-12547: TNS:lost contact

[root@dbserver /]# sqlplus sys/xiniu123 as sysdba                        

SQL*Plus: Release 12.2.0.1.0 Production on Sat Aug 26 12:55:34 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-12547: TNS:lost contact


Enter user-name: 
ERROR:
ORA-12547: TNS:lost contact


Enter user-name: 
ERROR:
ORA-12547: TNS:lost contact

原因权限不够
确认$ORACLE_HOME/bin/oracle文件权限是否有问题

最初的权限
[root@dbserver /]#  ll $ORACLE_HOME/bin/oracle  
-rwxr-x--x. 1 oracle dba 407988851 Aug  1 12:50 /usr/oracle/product/bin/oracle

修改后正确的权限
[root@dbserver /]# chmod 6751 $ORACLE_HOME/bin/oracle  
[root@dbserver /]# ll $ORACLE_HOME/bin/oracle  
-rwsr-s--x. 1 oracle dba 407988851 Aug  1 12:50 /usr/oracle/product/bin/oracle

以上就可以解决了ORA-12547: TNS:lost contact问题了

2、oracle 开启监听失败

[root@dbserver bin]# lsnrctl start 

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-AUG-2017 10:49:54

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Starting /usr/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
NL-00280: error creating log stream /usr/oracle/product/network/log/listener.log
 NL-00278: cannot open log file
  SNL-00016: snlfohd: error opening file
   Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

做了1上面的授权操作这个问题没了，但是有引入新的问题

[oracle@dbserver trace]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-AUG-2017 13:28:31

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Starting /usr/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /usr/oracle/product/network/admin/listener.ora
Log messages written to /usr/oracle/product/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=196.160.1.211)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
 NL-00303: syntax error in NV string

Listener failed to start. See the error message(s) above...

我做了如下操作，没有找到为什么监听失败的原因，但是已经可以连接了
步骤1
listener.ora
将**xxx**的内容删除

            **SID_LIST_LISTENER =  
               (SID_LIST =  
                    (SID_DESC =  
                      (SID_NAME = CLRExtProc)  
                      (ORACLE_HOME = /usr/oracle/product)  
                       (PROGRAM = extproc)  
                       (ENVS = "EXTPROC_DLLS=ONLY:/usr/oracle/product")  
                    )  
                )  
            (SID_DESC =
                (GLOBAL_DBNAME = ORCL)
                (ORACLE_HOME = /usr/oracle/product)
                (SID_NAME = ORCL)
            )**
LISTENER =
  (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 196.160.1.211)(PORT = 1521))
        )
    )

ADR_BASE_LISTENER = /usr/oracle/product

步骤2 启动监听

[oracle@dbserver trace]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-AUG-2017 13:28:31

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Starting /usr/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /usr/oracle/product/network/admin/listener.ora
Log messages written to /usr/oracle/product/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=196.160.1.211)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
 NL-00303: syntax error in NV string

Listener failed to start. See the error message(s) above...

[oracle@dbserver trace]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-AUG-2017 14:00:19

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Starting /usr/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /usr/oracle/product/network/admin/listener.ora
Log messages written to /usr/oracle/product/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=196.160.1.211)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                26-AUG-2017 14:00:19
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /usr/oracle/product/network/admin/listener.ora
Listener Log File         /usr/oracle/product/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=196.160.1.211)(PORT=1521)))
The listener supports no services
The command completed successfully

步骤3 将步骤1删除的内容重新添加上
listener.ora

**SID_LIST_LISTENER =  
               (SID_LIST =  
                    (SID_DESC =  
                      (SID_NAME = CLRExtProc)  
                      (ORACLE_HOME = /usr/oracle/product)  
                       (PROGRAM = extproc)  
                       (ENVS = "EXTPROC_DLLS=ONLY:/usr/oracle/product")  
                    )  
                )  
            (SID_DESC =
                (GLOBAL_DBNAME = ORCL)
                (ORACLE_HOME = /usr/oracle/product)
                (SID_NAME = ORCL)
            )**

步骤4 关闭数据库shutdown abort
步骤5打开数据库startup
以上就解决问题了