解决ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

电玩女神 2022-04-08 12:43 243阅读 0赞

第一步：打开Oracle Net Manager

进行如下配置：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plYWw5cw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plYWw5cw_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plYWw5cw_size_16_color_FFFFFF_t_70 2]  
第二步:找到查看listener.ora文件：位于oracle 安装目录的app文件夹目录下面

我的位置是：D:\\app\\lenovo\\product\\11.2.0\\dbhome\_1\\NETWORK\\ADMIN\\listener.ora,打开大致如下

# listener.ora Network Configuration File: D:\app\lenovo\product\11.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 = D:\app\lenovo\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:D:\app\lenovo\product\11.2.0\dbhome_1\bin\oraclr11.dll")
        )
    
    
      )
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        )
      )
    
    ADR_BASE_LISTENER = D:\app\lenovo

第三步：添加一段配置：  
在这个后面添加一段配置  
![在这里插入图片描述][20181214093915190.png]

(SID_DESC =
          (GLOBAL_DBNAME = ORCL)
          (ORACLE_HOME = D:\app\lenovo\product\11.2.0\dbhome_1)  
          (SID_NAME = ORCL)
        )

添加完成的文件内容为:

# listener.ora Network Configuration File: D:\app\lenovo\product\11.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 = D:\app\lenovo\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:D:\app\lenovo\product\11.2.0\dbhome_1\bin\oraclr11.dll")
        )
        (SID_DESC =
          (GLOBAL_DBNAME = ORCL)
          (ORACLE_HOME = D:\app\lenovo\product\11.2.0\dbhome_1)  
          (SID_NAME = ORCL)
        )
    
      )
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        )
      )
    
    ADR_BASE_LISTENER = D:\app\lenovo

SID\_NAME 对应网络服务命名；GLOBAL\_DBNAME 对应服务名，修改完成后重启服务就好了！  
注意：有可能你的数据库密码会出现过期的问题，解决方法请参照：[oracle数据库密码过期问题][oracle]

**说在最后的话：编写实属不易，若喜欢或者对你有帮助记得点赞+关注或者收藏哦~**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plYWw5cw_size_16_color_FFFFFF_t_70]: /images/20220405/d34df8caf8af43408fb34d76801d8a20.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plYWw5cw_size_16_color_FFFFFF_t_70 1]: /images/20220405/0b80b281b2dd42d9a7c463083a309ca4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plYWw5cw_size_16_color_FFFFFF_t_70 2]: /images/20220405/97ffdc6ae1c84b87bc5d656b01cecc91.png
[20181214093915190.png]: /images/20220405/21298fb3f0bf4cf0be6d23a2b91464d7.png
[oracle]: https://blog.csdn.net/zeal9s/article/details/84998337