ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
vibs
Posts: 1
Joined: Mon 05 Nov 2018 11:16

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Post by vibs » Mon 05 Nov 2018 11:26

Hi,

I'm getting the following error when trying to access the Oracle DB from test servers:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

I'm using direct mode for connection and my connection string is in the following format:

Data Source = (DESCRIPTION_LIST=(FAILOVER=on)(LOAD_BALANCE=off)(DESCRIPTION=(SDU=32767)(SEND_BUF_SIZE=65536)(RECV_BUF_SIZE=65536)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=a1.xyz.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SRVNME_SRVC1)))(DESCRIPTION=(SDU=32767)(SEND_BUF_SIZE=65536)(RECV_BUF_SIZE=65536)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=a2.xyz.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SRVNME_SRVC1)))(DESCRIPTION=(SDU=32767)(SEND_BUF_SIZE=65536)(RECV_BUF_SIZE=65536)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=a3.xyz.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SRVNME_SRVC1))));Direct=true; User Id="Oracle_User"; Password="Oracle_Password"; Licence Key="devart Licence Key";

The connection works fine from my local environment not sure why it doesn't work from the test servers.

Pinturiccio
Devart Team
Posts: 2329
Joined: Wed 02 Nov 2011 09:44

Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Post by Pinturiccio » Tue 13 Nov 2018 15:23

Please check whether these Oracle servers are available from your test servers.
Please also try connecting with dotConnect for Oracle via 3 separate connections, specifying each of these three servers, respectively. Are the connections established successfully?

Post Reply