topic Re: New DB server, Oracle 19c, Failed to connect to the specified DBMS instance in Geodatabase Questions

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

MagalyClément-Zaber — Thu, 31 Aug 2023 13:56:33 GMT

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

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

MarceloMarques — Thu, 31 Aug 2023 18:44:59 GMT

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.

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

MagalyClément-Zaber — Fri, 01 Sep 2023 07:10:35 GMT

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.

🙏

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

MarceloMarques — Sat, 02 Sep 2023 03:11:43 GMT

Glad to assist.