针对ORA-12504错误:“TNS was not given the service name in CONNECT_DATA”,这是一个常见的Oracle数据库连接错误,通常是由于配置问题导致的。下面我将按照你提供的tips逐一分析和解答: 1. 确认错误信息的含义 ORA-12504错误表明,在尝试连接到Oracle数据库时,监听器(listener)没有接收到包含服务名(SERVICE_NAME)...
ORA-12504: TNS:listener wasnot given the SERVICE_NAMEin CONNECT_DATA 解决办法: 说明:其实上面出现这样的情况是在tnsname.ora中配置错了,将tnsname.ora中的ADDRESS_LIST参数去掉就行了。 最终的tnsname.ora中的配置变为: [oracle@sm2 admin]$ cat tnsnames.ora sm2 = ( DESCRIPTION = ( ADDRESS = (PROT...
orcl=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.39.199)(PORT=1521)) (CONNECT_DATA=(SERVICE=DEDICATED) (SERVICE_NAME=orcl) ) ) 解决方案:修改tnsname.ora文件内容如下: 172.16.39.199=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.39.199)(PORT=1521)) (CONNECT_DATA=(SERVICE=DEDICATED) (SE...
Once the DEFAULT_SERVICE parameter is configured, reload the listener to bring this change into effect:- lsnrctl reload Sol 2. If using a service name, check that the connect descriptor corresponding to the service name in TNSNAMES.ORA of the client has a SERVICE_NAME ...
I am getting the error: ORA-12504: TNS: listener was not given the Service_name in connect_data , when the Open connection is called. The tns entry has the below: t1_exa_abc= (DESCRIPTION= (ADDRESS= (PROTOCOL = TCP) (HOST=SERVERNAME)...
1.客户端使用SCANIP连接RAC数据库时的报错:ORA-12545: Connect failed because target host or object does not exist 解决方法是:修改RAC的local_listener参数,将参数值中HOST=的值改为当前节点的VIP或者scanip- -注意是IP而不是hostname,客户端可以通过SCANIP或者VIP都可以连接到RAC数据库库 2.数据链连接其它库...
) On some client machines i get below error when i try use sqlplus to log on datbase like (sqlplus username/passwd@DBNAMESERVER) but on other client machines(in the same configuration) it's work perfectly;) ORA-12504: TNS:listener was not given the SID in CONNECT_DATA ...
百度试题 结果1 题目ORA-12505,TNS:listener does not currently know of SID given in connect descriptor怎么解决?求大师 相关知识点: 试题来源: 解析 把你要连的TNSNAME String传上来看看,应该是service_name的值与监听服务的SID不一致 反馈 收藏
Listener refused the connection with the following error:ORA-12514,TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zsl)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=...
把你要连的TNSNAME String传上来看看, 应该是service_name的值与监听服务的SID不一致