如何解决ERROR:ORA-12154:TNS:无法处理服务器名

来源：百度知道 编辑：UC知道 时间：2024/07/07 21:20:33
用SQL/PLUS登陆完全没有问题，但是用PLSQL登陆就会出现这个错误信息
我的tnsnames.ora文件内容如下
# TNSNAMES.ORA Network Configuration File: E:\ORACLE\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORA9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 7e8caf86a541481)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora9)
)
)

DBSERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 7e8caf86a541481)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNE

数据库系统标识，一般和数据库同名
)
)
3）保存文件。启动PL/SQL 工具登陆即可

1）打开目录E:\\oracle安装目录\\ora9\\network\\admin中的文件tnsnames.ora。
2）增加如下代码：
TRAFFIC_DB =#NET服务名，可任意起
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) #HOST为连接的数据库服务器的IP地址，PORT为连接的数据库服务器的端号，一般缺省为1521)
(CONNECT_DATA =
(SID = carsys) #数据库系统标识，一般和数据库同名
)
)
3）保存文件。启动PL/SQL 工具登陆即可