ArcGIS Monitor and Setting up Oracle Client

[AlexStevenson]

Hi All,

I've followed the Help documentation and downloaded/installed the Oracle Instant Client on the server hosting ArcGIS Monitor.  I now see a "Oracle in instantclient_12_2" entry in the Drivers tab when looking at the ODBC Data Source Administrator (64-bit).  However, when trying to test out an Oracle query in the Monitor Administrator, the test fails with a message of "Error: [Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error".  

I'm wondering if my Driver string is correct.  The syntax I have is as follows:

DRIVER={Oracle in instantclient_12_2};SERVER=oracleservername:1521/oracledatabase; UID=sdeusername; PWD=sdepassword

Any ideas?

Thanks,

Alex

[MichaelVolz]

Does Monitor support Oracle 12.2.x?

[JohnGraham2 · Accepted solution]

Contact Esri Technical Support for help with the Driver string and connecting to the database.

ArcGIS Monitor and ArcGIS Server support the same versions of Oracle. So, Oracle 12.2.x would be supported: http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/database-requirements-oracle.h...

[lvargas]

Hello,

I use Monitor 10.8.1 and Oracle Client 64x 12 (12.2.0.1.0), works with this connection string.
DRIVER={Oracle in OraClient12Home1};Dbq=TNSNAME; UID=sde; PWD=password

Regards.