GeoMedia Discussions

Search for an answer, post a question, or answer other users' questions in our GeoMedia support discussions. This discussion board is a great way to collaborate with industry peers around the world. It is intended for discussion and support of the GeoMedia Desktop and Add-on applications.
Showing results for 
Search instead for 
Do you mean 
Reply
Contributor
Posts: 28
Registered: ‎10-18-2017

Unable to connect to Oracle Database Containing G/Technology Data

Hi All,

 

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.

GTFOW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = in-ucpxssrv.ingrnet.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GTFOW.in-ucpxssrv.ingrnet.com)
)
)

 

Please give suggestions.

 

Aroop