ORA-12514错误,用sqlplus连接oracle数据库,登陆时出现ORA－12514错误,说service－name不能解析?oracle中net端已经配置好并测通了sqlplus中tnsnames.ora文件如下：LISDB=(DESCRIPTION=(ADDRESSLIST=(ADDRESS=(PROTOCOL=T

Question

ORA-12514错误,
用sqlplus连接oracle数据库,登陆时出现ORA－12514错误,说service－name不能解析?oracle中net端已经配置好并测通了
sqlplus中tnsnames.ora文件如下：
LISDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.22.141)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lisdb)
)
)
将service_name变为sid这个不行啊,而且Configuration Assistant配过很多次了已经,
lisdb肯定没有问题,测试已经通过了,另外删掉文件重配也试过了,不成啊,别人的机子同样的配置都没有问题,
晕.

Answer 1

LISDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.22.141)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lisdb)
)
)
要不行,把tnsnames.ora删掉,用Configuration Assistant重新建
还不行啊,你确定lisdb是正确的?配的时候测试是否通过?
把..\Network\Admin\下的文件全删掉,再用Configuration Assistant配置试试