分类导航

Linux 发布时间：2022-04-01 发布网站：大佬教程 code.js-code.com

大佬教程收集整理的这篇文章主要介绍了linux – oracle lsnrctl TNS-12545：连接失败,因为目标主机或对象不存在，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

概述

我正在尝试连接到我的Oracle数据库.我无法让听众开始.这是我尝试过的.

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 08:19:58

Copyright (C) 1991,2007,Oracle.  All rights reserved.

StarTing /u01/app/Oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /u01/app/Oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect Failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect Failed because target host or object does not exist

 
# tnsnames.ORA Network Configuration File: 
# /u01/app/Oracle/product/10.2.0/db_1/network/admin/tnsnames.ora 
# 

EXTPROC_CONNECTION_DATA.test = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
    ) 
    (CONNECT_DATA = 
      (SID = DEVDB) 
        (PRESENTATION = RO) 
      ) 
    ) 

DEVDB = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCp)(HOST = localhost)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (service_name = DEVDB.test)
    ) 
  ) 

DEBDB.test = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCp)(HOST = DEVDB.test)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (service_name = DEVDB.test)
    ) 
  )

以下是在具有类似设置的其他计算机上成功启动的示例.没有listner.ora文件只是tnsname s.ora.

$lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 11:38:51

Copyright (C) 1991,Oracle.  All rights reserved.

StarTing /u01/app/Oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /u01/app/Oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Oracletest)(PORT=1521)))

ConnecTing to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                20-JAN-2012 11:38:51
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/Oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints SumMary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Oracletest)(PORT=1521)))
The listener supports no services
The command completed @R_197_6048@sfully