Good morning,
I cannot open an SDE connection to an Oracle database in ArGIS Pro but it works in ArcCatalog.
My Python Pro script fails.
Do you have the Oracle Clients referenced in your Path environmental variable?
Here is some additional guidance on how to configure the clients in the Path variable.... https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-oracle.htm