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

[JamalNUMAN]

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

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?

[AyanPalit]

@JamalNUMAN 

1. ArcGIS Pro is 64-bit application so 64-bit Oracle Client compatible with the database must be installed on the client machine. 
2. Also, 64 bit Oracle Net Client path should be provided in the beginning of Environment Variables "path" on the client machine.Reference: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/database-connections-in-arcgis-pro.htm 

[George_Thompson]

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.

[JamalNUMAN]

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

[AyanPalit]

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