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:
- The connection or authentication to the underlying database failed.
- 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.
- 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.