Monitoring Oracle Enterprise Data

texasgis · ‎08-17-2023

Has anyone been able to connect to an Oracle Enterprise database from the new Monitor? ESRI support can't find the issue. I can connect on the Monitor server using sqlplus and ArcGIS Pro with no issues. I'm pretty sure that the new Monitor has hard coded part of the connection string.

GeoJosh · ‎08-17-2023

Hello, I have a few Oracle databases registered with Monitor 2023.2. Can you share what error you're seeing?

KimCloud · ‎08-17-2023

Yes, we were able to connect to our Oracle Enterprise geodatabases. Our server engineers did have to update the host-based firewall rules on the database server to allow port 1521. Otherwise nothing special. We used the fully qualified domain name of the server, port, name of the database and provided the sde credentials.

IrisHadarStltd · ‎08-24-2023

Yes ,
We also managed to connect to an Oracle database .Attached Screenshot of the data we entered.
I think it's worth checking from the monitor machine itself:
1. Is it possible to make a connection using SQLPLUS to the DB
2. TNSPING works properly