Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. Underlying DBMS error[ORA-12637]

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2023.0

Symptom

When FME is attempting to create a Feature Class in an Enterprise Geodatabase FME via an Oracle client returns the following error:

"Could not open the Enterprise Geodatabase. The error number from ArcObjects
is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS
error[ORA-12637: Packet receive failedNo extended error.]}"

 

Cause

There are three different causes for this error, see their corresponding number in the Resolution section:

  1. The connection or authentication to the underlying database failed.
  2. 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.
  3. The bitness (32-bit or 64-bit) of the underlying Oracle Database is different from the bitness of the Oracle client and FME.

 

Resolution

Resolution 1:

Ensure you have correct permissions for the database operation you are attempting (i.e. create table). In some cases the error may be caused by a mismatch in the type of database user authentication. For example, the authentication may be set to:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

In the sqlnet.ora file in Oracle folder. This may not be compatible with the Geodatabase authentication and you may need to comment out that line in the sqlnet.ora file.
 

Resolution 2:

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

Resolution 3:

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

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.