PL/SQL 用了几天后再登陆提示监听程序当前无法识别连接描述符中请求的服务，绞尽脑汁各种搜索找到以下解决方案-修改listener.ora文件

一般文件存在：app\Administrator\product\12.2.0\dbhome_1\network\admin

原文件代码如下：

 1 # listener.ora Network Configuration File: C:\app\Administrator\product\12.2.0\dbhome_1\network\admin\listener.ora
 2 # Generated by Oracle configuration tools.
 3 
 4 SID_LIST_LISTENER =
 5   (SID_LIST =
 6     (SID_DESC =
 7       (SID_NAME = CLRExtProc)
 8       (ORACLE_HOME = C:\app\Administrator\product\12.2.0\dbhome_1)
 9       (PROGRAM = extproc)
10       (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\12.2.0\dbhome_1\bin\oraclr12.dll")
11      )
12    )
13 
14 LISTENER =
15   (DESCRIPTION_LIST =
16     (DESCRIPTION =
17       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.44.128)(PORT = 1521))
18       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
19     )
20   )

原文件

添加后代码如下：

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

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\Administrator\product\12.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\12.2.0\dbhome_1\bin\oraclr12.dll")
    
     )
     ---------------------------新增以下代码-并重启TNSListener服务----------------------
     (SID_DESC =
      (GLOBAL_DBNAME = GWAMRTHB)
      (ORACLE_HOME = C:\app\Administrator\product\12.2.0\dbhome_1)  
      (SID_NAME = GWAMRTHB)
     )
     ----------------------------------------------------------------
   )

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

修改后

 

版权声明：本文为laughing666原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/laughing666/p/11428128.html