I am attempting to setup a Geodatabase/SDE direct connection via an Oracle client using my reader and writer.

But when I press ok, after entering the details of the connection,

it results in the error message:

"Could not open the Enterprise Geodatabase. Please check that the connection parameters specified are correct. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specified No extended error.]}"

I am confused what I did wrong, I followed the same procedure which FME mentioned on their website.

Any help is much more appreciated.

CodePudding user response：

The problem you are facing is because of 2 reasons:

Cause 1

FME was installed in the C:\Program Files (x86)\ directory as a 32 bit application on a 64 bit OS. The oracle client has an issue with the () in the path name.

Resolution 1

Reinstall FME to a different location - e.g. c:\apps.

Cause 2

The bitness (32-bit or 64-bit) of the underlying Oracle Database is different to the bitness of the Oracle client and FME.

Resolution 2

Make sure the witness of FME and the Oracle client match with the underlying Oracle Database of the Geodatabase/SDE direct connection.