ora-12154 TNS无法处理服务名”的解决办法之tnsnames.ora模板

本文链接：https://blog.csdn.net/masuwen/article/details/53668028

本文介绍如何配置 Oracle 数据库连接文件 tnsnames.ora，详细解释了网络服务名、主机名/IP、端口号及 SID 的设置方法，并提供了多个实例供参考。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//------------------------------------------------tnsnames.ora把此文件copy到D:\plsql developer中

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

#XIEHENG_192.168.16.20 =
# (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.20)(PORT = 1521))
#    )
#    (CONNECT_DATA =
#      (SID = XIEHENG)
#      (SERVER = DEDICATED)
#    )
# )

## 配置说明:
# --XIEHENG_192.168.16.20指的是网络服务名,可用SID_HOST来命名(按个人习惯)
# --HOST指Oracle服务器的机器名或IP
# --PORT指端口,默认为1521
# --XIEHENG指的是Oracle的SID
# --SERVER = DEDICATED 不用改

# 请参照以下连接的例子

XIEHENG_192.168.16.20 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.20)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = XIEHENG)
      (SERVER = DEDICATED)
    )
)

GCBORA_192.168.1.3 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = GCBORA)
      (SERVER = DEDICATED)
    )
)

ORCL29 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.29)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)
ORCL10 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)

ORCL11 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 115.29.137.58)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)

ORCL32 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.6.32)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)