nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

JohnGraham2

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.htm#GUID-73C89253-593A-4170-AD56-FA2A44A1485F

All comments

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.

JohnGraham2

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

mvolz47

Does Monitor support Oracle 12.2.x?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.