Oracle数据库ORA-12154: TNS: 无法解析指定的连接标识符解决方法

傷城~ 2023-02-23 01:28 9阅读 0赞

对于这个问题，对于我这种初学者来说是经常遇到的，今天就把可靠的解决发法记于此，希望能帮助到大家。

## ORA-12154: TNS: 无法解析指定的连接标识符 ##

第一步：  
查看自己的Oracle服务是否打开。

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70]  
OracleServiceORCL，OracleOraDb10g\_home1TNSListener都需要开启，前者是主服务，后者是监听服务。  
第二步  
配置好服务后就可以通过我们配置的网络服务名访问Oracle数据库了。找到“ D:\\app\\lcb\\product\\11.2.0\\dbhome\_1\\NETWORK\\ADMIN” 目录（就是你oracle安装时app目录下）  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70 1]  
打开tnsnames.ora文件

# tnsnames.ora Network Configuration File: D:\app\lcb\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
    # Generated by Oracle configuration tools.
    
    LISTENER_ORCLWWENG =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = LISTENER_ORCLWWENG)
        )
      )
    
    ORCL =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = ORCL)
        )
      )

然后在原本的基础上添加：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70 2]  
保存后即可。

第三步  
打开cmd，输入tnsping orcl (我配置的是booksales)  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70 3]  
显示已使用适配器来解析别名表示已成功

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200704182308179.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200704182530899.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200704182624176.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200704182712113.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xhbjM2Mjk3OTY=,size_16,color_FFFFFF,t_70