ora-12154 无法处理服务器名错误如何处理?

发布网友 发布时间：2022-04-29 17:28

我来回答

共2个回答

热心网友 时间：2022-04-13 17:34

ora-12154 无法处理服务器名错误解决方法如下：

编辑代码：

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)

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

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

热心网友 时间：2022-04-13 18:52

1.首先检查配置文件(tnsnames.ora)是否设置正确
找到 tnsnames.ora 文件
查找方法:
打开安装日志文件(installActions.log),查找到%ORACLE_HOME%所在位置;
默认在C:\Program Files\Oracle\Inventory\logs文件夹下;
在另一个安装日志文件中,通过查找"TNSNAMES.ORA" 找到"TNSNAMES.ORA"所在位置;
本例为:
ToLocation = ORACLE_HOME = C:\oracle\ora90
TNSNAMES.ORA ->%ORACLE_HOME%/NETWORK/ADMIN/TNSNAMES.ORA
1.2 查看其中的设置是否正确
打开TNSNAMES.ORA文件，可以看到以下设置
mrfuDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mrfu-bkfd73842)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mrfuDB)
)
)

mrfuDB:          所访问的数据库名,也就是在oracle SQL*Plus 中主机字符串一栏中输入的名字;
mrfu-bkfd73842: 所登录的oracle数据库服务器名,也就是在 oracle Enterprise Manager Console   中
Management Server(M)一栏中输入的名字;
1251：           数据库服务器接收访问的端口;
TCP:             访问数据库服务器的通信协议;