Skip to main content
Question

FME oracle DATABASE Connection issue

  • January 29, 2019
  • 1 reply
  • 123 views

f.kemminje
Contributor
Forum|alt.badge.img+11

I created the oracle connection inside named connection window. and tested, its good. But when i use the same connection for sql executor i am getting the following error

 

Connecting to ORACLE database `EGIS_T' with user name of `EGIS' and password of `***'
Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`EGIS_T', userName=`EGIS', password=`***', dbname=`')
ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `EGIS_T', user name `EGIS', password `***'
ORACLE Reader:

fme is not mapping the connection name to connection object.

where is the problem ?

 

1 reply

david_r
Celebrity
  • January 29, 2019

Sounds like an Oracle client configuration issue. Have you got a tnsnames.ora file with a defintion of EGIS_T?

What happens if you execute the following on the command line:

tnsping EGIS_T

You will need the full Oracle client for this (the instant client does not include tnsping, I believe).

See also this article:

https://knowledge.safe.com/articles/130/how-to-setup-an-oracle-instant-client-for-use-with.html


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings