ArcGIS Monitor and Setting up Oracle Client

637
3
Jump to solution
03-20-2018 02:50 PM
AlexStevenson
New Contributor II

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

0 Kudos
1 Solution

Accepted Solutions
JohnGraham2
Occasional Contributor

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...

View solution in original post

0 Kudos
3 Replies
MichaelVolz
Esteemed Contributor

Does Monitor support Oracle 12.2.x?

0 Kudos
JohnGraham2
Occasional Contributor

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...

0 Kudos
lvargas
New Contributor III

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.

0 Kudos