针对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...
Facing the below error while connecting to the Oracle database even we have given the proper TNS entries in tnsnames.ora file. Can some one help us on this issue. "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA" Labels: Need Help Message 1 ...
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA#641 dotmaik1opened this issueMar 3, 2017· 17 comments Labels question Comments Hi At the documentation said that we can connect with the name of the instance, can you clarify an example to do so please?
Hey guys, I'm facing the problem every time I want to open a connection to a database ( same for full connection string, tnsnames.ora entry or ezconnectstring): ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA I was...
This error occurs when there was no default service configured for the listener and SERVICE_NAME was missing from the request received by the listener. When a user tries to connect to the listener, it may be servicing several different databases. If user
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=SERVERNAM...
Hi I installed, Azure Data Studio, Downloaded the extension for Oracle . However while connecting to an Oracle database Im getting the following error ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA This is not an issue with the…
在使用robot framework的关键字Connect to Database Using Custom params连接Oracle数据库: 报错 ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA 解决