ORA-12514错误,用sqlplus连接oracle数据库,登陆时出现ORA-12514错误,说service-name不能解析?oracle中net端已经配置好并测通了sqlplus中tnsnames.ora文件如下:LISDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = T
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/15 20:16:59
![ORA-12514错误,用sqlplus连接oracle数据库,登陆时出现ORA-12514错误,说service-name不能解析?oracle中net端已经配置好并测通了sqlplus中tnsnames.ora文件如下:LISDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = T](/uploads/image/z/14706742-22-2.jpg?t=ORA-12514%E9%94%99%E8%AF%AF%2C%E7%94%A8sqlplus%E8%BF%9E%E6%8E%A5oracle%E6%95%B0%E6%8D%AE%E5%BA%93%2C%E7%99%BB%E9%99%86%E6%97%B6%E5%87%BA%E7%8E%B0ORA%EF%BC%8D12514%E9%94%99%E8%AF%AF%2C%E8%AF%B4service%EF%BC%8Dname%E4%B8%8D%E8%83%BD%E8%A7%A3%E6%9E%90%3Foracle%E4%B8%ADnet%E7%AB%AF%E5%B7%B2%E7%BB%8F%E9%85%8D%E7%BD%AE%E5%A5%BD%E5%B9%B6%E6%B5%8B%E9%80%9A%E4%BA%86sqlplus%E4%B8%ADtnsnames.ora%E6%96%87%E4%BB%B6%E5%A6%82%E4%B8%8B%EF%BC%9ALISDB+%3D%28DESCRIPTION+%3D%28ADDRESS_LIST+%3D%28ADDRESS+%3D+%28PROTOCOL+%3D+T)
ORA-12514错误,用sqlplus连接oracle数据库,登陆时出现ORA-12514错误,说service-name不能解析?oracle中net端已经配置好并测通了sqlplus中tnsnames.ora文件如下:LISDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = T
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肯定没有问题,测试已经通过了,另外删掉文件重配也试过了,不成啊,别人的机子同样的配置都没有问题,
晕.
ORA-12514错误,用sqlplus连接oracle数据库,登陆时出现ORA-12514错误,说service-name不能解析?oracle中net端已经配置好并测通了sqlplus中tnsnames.ora文件如下:LISDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = T
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配置试试