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; } } }

cannot connect to database in ArcGIS Pro

JerryLodge

At my work, we have too databases, one for development and the second for production. Both are oracle databases. I have no issues connecting to them in arcDesktop. I recently got a license to use ArcGIS Pro as we will be converting soonish. However ArcGIS Pro will not connect to the databases we use. I keep getting the error message

"Failed to connect to the specified DBMS instance.

A database connection exception has occurred. Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly."

I'd really appreciate any help solving this.

Thanks!

Find more posts tagged with

Accepted answers

All comments

HusseinReslan

I have same same problem failed to connect to specified DBMS instance,

I have an oracle database I have two users one could user A and user B

when I try to connect the database user A the connection succeed

but when I try to connect to the user B I got

Failed to connect to the specified DBMS instance

A database connection exception has occured underlying DBMS error[ORA-00933:SQL command not prperly endedNo extended error]

I need help please

@Michael Volz

Asrujit_SenGupta

Have you installed\configured the Oracle 64-Bit client?
What type of Oracle Client 64-bit are you using-- Oracle Full Client or the Instant Client?

The *.bat file workflow is just a workaround and not a "must have"..

DanNguyen

Jerry,

Thanks for the quick responses and the .bat file. I tried it out but still getting the error. Maybe I'm missing something else.

Thanks anyway.

-Dan.

JerryLodge

Dan,

Once you have both the 64 bit client AND ArcPRO installed copy the path below and put it in a new text document. To make this a .bat file, simply save it as .bat rather than .txt.

When you open ArcPro now you should be able to connect to your databases. Just open ArcPro by double clicking your batch file. Also, now that I've done this, every time I open a saved mxd, it automatically opens in ArcPro. If you want to work on something in ArcDesktop, just open Desktop separately and then browse to open the mxd you want to work with.

Hope this helps!

set path=C:\Oracle\product\instantclient_12_1_64bit;%path%

set TNS_ADMIN=C:\Oracle\product\instantclient_12_1_64bit

"C:\Program Files\ArcGIS\Pro\bin\ArcGISPro.exe"

DanNguyen

Hi Jerry,

I am having the same issue 'cannot connect to database because the database client software failed to load.....'

I don't have much experience in writing .bat file and was wondering if you could share the .bat file with me.

Thanks!

JerryLodge

I have 32 bit also installed. At least it should b since both programs are able to operate. Just can't connect main data base to Pro. I read somewhere earlier about setting the variable path and how that may solve the issue. I am not sure how to do that though.

MikeVolz

Do you have the 32bit Oracle Client also installed on the same computer to be able to use ArcMap? If so, the order of Oracle Client in the path environmental variable might be important for it to work correctly.

JerryLodge

Yes, the 64 - bit client is under: C:Oracle/product

MikeVolz

Do you have the 64-bit Oracle Client that is necessary to connect Pro to an Oracle database? Desktop (ArcMap) only needed 32-bit Oracle Client as it is a 32 bit application.

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.