ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Posted: 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.
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.