hi,i am very new to database connections.i am creating direct database connection with oracle 11gr2 with arcmap 10.3.but it fails to connect database and show below error.

[VaidhyPanday]

[AsrujitSengupta]

The connection string is incorrect.....you spelt your database name as 'MAYLAPPY' instead of MYLAPPY !

[VaidhyPanday]

sorry ,

i changed and checked but still getting same error

[AsrujitSengupta]

Can you just login from SQLPlus and post a screenshot of that. Don't post your passwords!

[VaidhyPanday]

[AsrujitSengupta]

I was talking about SQLPLUS in cmd, but anyways, ArcGIS Desktop being a 32-bit application needs a 32-bit Oracle Client. You mentioned that you have both the 64-bit and 32-bit Oracle Client installed....so this should not be an issue.

Just try these strings and check if it makes any diff:

1. I.P_Address_of_your_lappy/MyLappy
2. Server_name/MyLappy

[VaidhyPanday]

i tried all the combinations... servername/servicename

[AdrianWelsh]

I am not sure if this was addressed or not but have you installed the Oracle 11g client?

Oracle Database 11g Release 2 for Microsoft Windows (x64)

[VaidhyPanday]

yes.

i have installed 11gr2 release oracle client

[JamesGough1 · Accepted solution]

ArcMap is a 32-bit application and you need to install the 32-bit version of Oracle client drivers like Oracle Instant client.

Then you need to add both the 64-bit and 32-bit oracle clients in your system path.  64-bit path first and followed by the 32-bit Oracle bin in the path.

You need to re-start ArcMap before attempting to connect so it can pick up the updated path variable.

I can work with you on this in a meeting.

You can contact me at jgough@esri.com.

Hope this helps.

Thank you,

  Jim Gough.

[VaidhyPanday]

Thnaks sir,

now i am able to connect database.