weixin_42693699
枭筱龙
2019-03-25 12:11

oracle 监听问题 --sqlplus可以登录,其他程序不可以连接

  • oracle

图片说明

???????????????
ip什么的根本不管,直接就能登录本地oracle

在其他程序连接oracle报错:
oracle 错误代码:ora-12541

图片说明

请问这种情况怎么解决?

以下是 listener.ora代码
为了解决这个问题,重新配置了一个监听
所以有两个监听程序,但是依旧不好使!

# listener.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = KX8G3P6HOZLYPJ9)(PORT = 1512))
    )
  )

ADR_BASE_LISTENER2 = E:\app\Administrator

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = KX8G3P6HOZLYPJ9)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = E:\app\Administrator

SID_DESC =
  (GLOBAL_DBNAME = ORCL)
  (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
  (SID_NAME = ORCL)


以下是tnsnames.ora代码,
前两天还能用,今天一连接就开始报错!!

# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = KX8G3P6HOZLYPJ9)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

============补==================

以下是lsnrctl stat 执行结果

图片说明

以下是tnsping orcl执行结果

图片说明

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

2条回答