topic ORA-12637 packet receive failed in ArcGIS Enterprise Questions

ORA-12637 packet receive failed

HiteshJilka — Mon, 30 Apr 2018 10:19:09 GMT

Oracle DB: 12.1.0.2

ArcSDE : 10.4.1

We recently created a new database on new server which has firewall configured and only port opened is 1521 to connect to Oracle Database from source server.

I am able to connect to database from SQL prompt from source server but while from ArcMAP 10.4.1 database connection, I am facing the error "ORA-12637 packet receive failed".

For other DB on different servers, I am able to connect through ArcMAP from source server.

For ArcMAP or ArcCatalog do we need some other ports to be opened for database connection? Thanks!

Re: ORA-12637 packet receive failed

George_Thompson — Mon, 30 Apr 2018 12:47:55 GMT

- How are you connecting to the Oracle DB: TNS or EzConnect?

It looks like there is a connection issue between the ArcGIS Client and the DBMS. No sure if it is related to ArcGIS yet.

***Adding Geodatabase‌ for more visibility.

Re: ORA-12637 packet receive failed

HiteshJilka — Mon, 30 Apr 2018 13:21:15 GMT

Hello George, thanks for looking into this matter.

I am connecting using EzConnect. I tried changing SQLNET Authentication parameter at client and at server which is one of source for the error but it didn't help.

Re: ORA-12637 packet receive failed

George_Thompson — Mon, 30 Apr 2018 13:28:45 GMT

If you using EzConnect there is no reason to change the SQLNET file. Does the SQLNET file look something like this?

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

This would be under the 32-bit full client.

Have you reached out to the DBA and see if there are any error messages on the DBMS side at the time that you are connection.

Re: ORA-12637 packet receive failed

HiteshJilka — Tue, 01 May 2018 10:39:06 GMT

Hello George, from other client application also facing similar error, It has some firewall or network connectivity issue and not related to ArcGIS. I will inform concerned team to resolve the issue. Thank you!

Re: ORA-12637 packet receive failed

George_Thompson — Tue, 01 May 2018 10:42:10 GMT

Hi Hitesh Jilka thanks for the follow up. If other non-ArcGIS applications are having the same issues, then that confirms a possible cause. Please follow up when you have a final answer from the other teams as this may help another user down the road.

Re: ORA-12637 packet receive failed

HiteshJilka — Thu, 17 May 2018 06:23:56 GMT

Hello George, finally it has been resolved. There was an issue with configured Firewall, they reconfigured it and now ArcGIS and other applications are working fine.