问题:客户端Net Manager服务命名无反应,且PL/SQL无法连接本地数据库(远程连接无问题) ;另enterprise manager console 添加新的数据库会报TNS-04605错误
客户端tnsnames.ora中:
PADIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.180.170)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdais)
)
)
服务端tnsnames.ora中:
PADIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.180.170)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PADIS)
)
)
处理:将客户端小写改为大写(或将客户端tnsnames.ora配置替换为服务端tnsnames.ora配置)