ArcGIS Enterprise 10.9.1: Pro fails to connect to oracle 19.3 from a client machine,

Question

I couldn’t figure out why Pro fails to connect to oracle 19.3 from a client machine despite the fact that the oracle client 19.3 is installed in the client machine. The “ping” detects the server machine from the client machine

What could be the issue here?

Ayan Palit · Answer

Added recommendations:

* The customer must avoid 19.3 which was the first 19c release back in 2019.
* The customer must upgrade to the latest available Oracle 19c Release Update - Oracle 19.16 ( 19-JUL-2022) RU
* Oracle Database Client must be updated on all the ArcGIS machines
* Oracle Full Client 19.16
* Oracle Instant Client 19.15

Also reference the related post

JamalNUMAN · Answer

The installation of Oracle Home and Oracle Client gets complicated in 19.3C

I’m advised to apply the following commands on the Oracle Home machine

sqlplus sys/Oracle123@M1 as sysdba

select name open_mode from v$pdbs;

sqlplus sys/Oracle123@M1pdb as sysdba

select name open_mode from v$pdbs;

ALTER PLUGGABLE DATABASE OPEN;

This is in addition to some editing on the listener.ora and tnsnames.ora files

George_Thompson · Answer

if you are connecting as "sys" from Pro, you need to have "password as sysdba" for the password string.

Usually do not recommend connecting as SYS in Pro or any ArcGIS client.