ORA-12514错误,
来源:学生作业帮 编辑:大师作文网作业帮 分类:综合作业 时间:2024/10/11 02:23:58
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肯定没有问题,测试已经通过了,另外删掉文件重配也试过了,不成啊,别人的机子同样的配置都没有问题,
晕.
用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肯定没有问题,测试已经通过了,另外删掉文件重配也试过了,不成啊,别人的机子同样的配置都没有问题,
晕.
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配置试试
(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配置试试
请问oracle数据库中 一直有错误ora-01555,请问怎么解决
ora 12514和 ora 12560问题都有.oracle新年第一个问题 跪谢,祝新年快乐!
( 1 ). How many rice do you want?这句英文有什么错误 (2).Hhow much ora
欧美歌手rita ora外号?
ORA-00936 Missing expression
ORA-01031:权限不足
ORA-01034:ORACLE not available ORA-27101:shared memory realm
借助sqlplus如何查找 spfile.ora,listener.ora ,tnsnames.ora,以及listen
Da ora in poi,voi tutti,ti
Ora Che Ci Sei的意思?
java.sql.SQLException:ORA-00917:缺失逗号
rita ora r.i.p 中英文歌词