07-08-2019 05:03 AM
I am trying to connect to oracle object data server read write option, using new warehouse capability. The G/technology data server resides in Oracle 12 version.
However, connecting to it gives TNS-ORA 12504 error:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
An error occurred in the underlying database
I have defines TNS_ADMIN, ORACLE_HOME in environment variables for ease. The tnsnames.ora file value, I have added for reference;
# tnsnames.ora Network Configuration File: C:\oracle\app\client\product\12.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = TCP)(HOST = in-ucpxssrv.ingrnet.com)(PORT = 1521))
(SERVICE_NAME = GTFOW.in-ucpxssrv.ingrnet.com)
Please give suggestions.