Oracle DB: 18.104.22.168
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!
Solved! Go to Solution.
- 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.
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.
If you using EzConnect there is no reason to change the SQLNET file. Does the SQLNET file look something like this?
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.
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!
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.