Skip to main content

Unable to run the FME Master workflow which has 39 workflows as single workflow through FME Server. It used to run fine until 2 weeks back. Now,It is returning an ORA-12154 error in the log file. Please help

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Feature Type: `FEATURE_TYPE'

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Attribute(string): `_reader_error' has value `Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`*****', serverName=`*****', userName=`', password=`***', dbname=`')'

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Attribute(string): `fme_type' has value `fme_no_geom'

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Geometry Type: Unknown (0)

 

Hi,

Do you connect to Oracle using local naming (tnsnames.ora file)?

If so, you might want to check the following:

  • Verify that a tnsnames.ora file exists and is in the proper directory and is accessible.
  • Check that the net service name used as the connect identifier exists in the tnsnames.ora file.
  • Make sure there are no syntax errors anywhere in the tnsnames.orafile. Look for unmatched parentheses or stray characters. Errors in a tnsnames.ora file may make it unusable.

Simon


Reply