ORA-12504: TNS: listener was not given the Service_name in connect_dataRSS

• • Reply
  venkatzeus

  Participant

  1422 Points

  1932 Posts

  ORA-12504: TNS: listener was not given the Service_name in connect_data

  Feb 11, 2019 11:58 AM|venkatzeus|LINK

  Hi.

  I am trying to connect to Oracle Exadata 12 c database from a C# Web application ( VS2010).

  I have used the below code

  //web.config
  <add name="con" connectionString="DataSource=servername;userId=uid;password=pwd" providerName="Oracle.DataAccess.Client" />
  
  // c# cs code
  string oradb = System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString;
  
  OracleConnection conn = new OracleConnection(oradb);
  conn.Open()
  
  

  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)
  (PORT=port number)
  )
  (CONNECT_DATA=
  (SERVER=dedicated)
  (SERVICE_NAME=t1_exa_abc.domain.com)
  )
  )

  How to fix this?

• • Reply
  mgebhard

  All-Star

  37991 Points

  15467 Posts

  Re: ORA-12504: TNS: listener was not given the Service_name in connect_data

  Feb 11, 2019 03:10 PM|mgebhard|LINK

  venkatzeus

  How to fix this?

  Contact your Oracle DBA for assistence. Otherwise, you need to enter the correct TNS name if you are using local configuration.  See the Oracle support if you are the admin or Google the error for more information.

  https://community.oracle.com/thread/609935?start=0&tstart=0

  https://stackoverflow.com/questions/29659264/sqlplus-errorora-12504-tnslistener-was-not-given-the-service-name-in-connect

  https://github.com/oracle/node-oracledb/issues/641

• • Reply
  Lannie

  Contributor

  3412 Points

  1327 Posts

  Re: ORA-12504: TNS: listener was not given the Service_name in connect_data

  Feb 13, 2019 01:22 AM|Lannie|LINK

  Try a fully qualified connection string, essentially bypassing tnsnames.ora

  Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={SERVER_IP_ADDRESS})(PORT={WHAT PORT IS YOUR ORACLE LISTENING ON?}))(CONNECT_DATA=(SERVICE_NAME=t1_exa_abc.domain.com)));
  User Id={your login name};Password={your login password};