用PLSQL Developer连接Oracle数据库时报错,.\Oracle\product\10.2.0\db_1\network\ADMIN\tnsnames.ora 文件为手工配置
经多次尝试,发现是\tnsnames.ora文件中命名的多了空格导致的问题,去掉后就可以了。
如下:
错误格式:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.62)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
BSDORCL_44 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.50.44)(PORT = 1521))
)
(CONNECT_DATA =
(SID = bsdorcl)
(SERVER = DEDICATED)
)
)
将BSDORCL_44 = 前面的空格去掉即可(即顶格)