반품
-
제목
TNS:listener was not given the SERVICE_NAME in CONNECT_DATA -
설명
When attempting to configure a connection to Oracle in Quick Connect, the following error is observed:
The specified SQL Server instance cannot be contacted. Details: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATAORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA -
원인
The local Oracle tnsnames.ora file has invalid connection data contained within. -
해결 방안
Locate the local tnsnames.ora file and resolve any invalid connection data in the data.