New DB server, Oracle 19c, Failed to connect to the specified DBMS instance

[MagalyClément-Zaber]

Hi,

Our actual configuration is :

• Arcgis Enterprise 10.8.1
• Oracle 12c

We want to test the connection with a new version of Oracle : Oracle 19c.

The server is installed and connexion with "sql manager" works fine.

On my local machine, i have installed Oracle Client 19.

I want to create a geodatabase.

I modified the tsname.ora to put the new config:

SIGIMGPROD19C =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MYINSTANCE)
)
)

The connection test with tnsping works fine.

But when I use the tool "Create Enterprise Geodatabase", I've got an error :

Failed to connect to the specified DBMS instance (Échec d'accès au serveur DBMS)

I use a batch to execute arccatlog to use specific path :

Set PATH=C:\oracle\product\19c\cli19c32\client_1\bin;C:\Program Files (x86)\ArcGIS\Desktop10.8\bin

START ArcCatalog.exe

I there something I forgot to configure ?

Thanks for help

[MarceloMarques · Accepted solution]

First test the connection to the Oracle database using Oracle SQL Plus.

This will help determine if Oracle Instant Client is configured correctly.

Oracle Instant Client requires the Microsoft C++ Redistributable Library.

Look the Oracle Instant Client Installation documentation.

See my communuity.esri.com white paper.

How to Install the Oracle Database Client for ArcGIS?

I hope this helps.

[MagalyClément-Zaber]

Hi,

Thanks a lot ! This helps me. 

lsnrctl status  show me the error in tnsname.ora !

The service name was not complete, I have forgotten the complete DNS name.

🙏

[MarceloMarques]

Glad to assist.