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.
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
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?
Please also try connecting with dotConnect for Oracle via 3 separate connections, specifying each of these three servers, respectively. Are the connections established successfully?