topic Re: cannot connect to database in ArcGIS Pro in ArcGIS Pro Questions

cannot connect to database in ArcGIS Pro

JerryLodge — Tue, 12 Dec 2017 17:37:55 GMT

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!

Re: cannot connect to database in ArcGIS Pro

MichaelVolz — Tue, 12 Dec 2017 18:22:57 GMT

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.

Re: cannot connect to database in ArcGIS Pro

JerryLodge — Tue, 12 Dec 2017 19:17:08 GMT

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

Re: cannot connect to database in ArcGIS Pro

MichaelVolz — Tue, 12 Dec 2017 19:25:14 GMT

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.

Re: cannot connect to database in ArcGIS Pro

JerryLodge — Tue, 12 Dec 2017 19:40:56 GMT

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.

Re: cannot connect to database in ArcGIS Pro

MichaelVolz — Tue, 12 Dec 2017 19:51:09 GMT

Do you know how to access the environmental variables on your workstation or server (whatever it may be)?

Re: cannot connect to database in ArcGIS Pro

JerryLodge — Tue, 12 Dec 2017 19:56:49 GMT

Unfortunately no I do not.

Re: cannot connect to database in ArcGIS Pro

MichaelVolz — Tue, 12 Dec 2017 20:07:58 GMT

Instruction for Windows 7 (Might be different for Windows 10 and you could probably do a Google search for this)

Left click on Start in lower left corner.

Dialog box should popup and on right side in middle of dialog box should be Computer

Right click on Computer and a drop-down should open with Properties on bottom

Left click on Properties and in upper left corner of Properties dialog box should be Advanced System settings

Left click on Advanced System settings and Environmental Variables should be near bottom

Navigate to PATH and make sure the path to the Oracle Client is here (You should have two Oracle Client paths as one is for 32 bit client and one is for 64 bit client).

If 32 bit client is before 64 bit client, move 64 bit client in front of 32 bit cleint and see if you can then connect to Oracle Database in Pro). Modifying the Environmental Variables most likely requires a reboot of computer to take affect.

Re: cannot connect to database in ArcGIS Pro

JerryLodge — Tue, 12 Dec 2017 20:20:25 GMT

So I only see the 32-bit client. But I have installed the 64 several weeks ago.. Hmm.. There is PATH and PATHEXT but not two PATHs. I will install 64 bit once more and see if it shows.

Re: cannot connect to database in ArcGIS Pro

MichaelVolz — Tue, 12 Dec 2017 20:51:11 GMT

I would just make a copy of the path to the 32bit client and modify the copy so it points to the 64bit client location. I would put the 64bit client first, but it might not matter as you currently don't even have a path the 64bit client anyhow and that it why it is not working. I think this would be easier that performing a re-install which might not add this path variable the 2nd time installed since it was not done the first time.

Are you using the Instant Oracle Client?

Re: cannot connect to database in ArcGIS Pro

JerryLodge — Wed, 13 Dec 2017 13:30:40 GMT

Thanks so much Michael!

I just figured it out this morning. I checked to see if the 64 bit was installed correctly and it was.

The trick was I created a .bat file that set the path to the 64 bit-client each time arcPro was opened. And now I just open ArcPro with that batch file and I am able to connect to the databases & our server. Thanks so much!!

Re: cannot connect to database in ArcGIS Pro

DanNguyen — Tue, 09 Jan 2018 15:20:00 GMT

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!

Re: cannot connect to database in ArcGIS Pro

JerryLodge — Tue, 09 Jan 2018 16:02:34 GMT

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"

Re: cannot connect to database in ArcGIS Pro

DanNguyen — Tue, 09 Jan 2018 17:14:15 GMT

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.

Re: cannot connect to database in ArcGIS Pro

Asrujit_SenGupta — Tue, 09 Jan 2018 17:20:16 GMT

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

Re: cannot connect to database in ArcGIS Pro

HusseinReslan — Fri, 20 Dec 2019 12:09:34 GMT

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