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 · ‎02-20-2016

JamesGough1 · ‎02-21-2016

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.

Thank You,
Jim Gough | Technical Lead Enterprise - Educational Services
Esri

View solution in original post

DanPatterson_Retired · ‎02-20-2016

Vaidhy, what was underneath the top dialog?

wonjack · ‎02-20-2016

it is username and password for connecting database.

for avoiding any access and grant ,I am using SYS user.

VinceAngelo · ‎02-20-2016

You should not EVER use the SYS user to connect from ArcGIS clients. It is a very dangerous practice, and Oracle tries to prevent it by making SYS-privilege users add the WITH SYSDBA modifier in the connection (which ArcGIS doesn't provide).

If you follow best practice by creating one or more tablespaces to contain your data, and one or more users to own the data (with appropriate default tablespaces), and one or more roles to manage access to your tables, and additional users to access the data (through the roles), then you won't get tangled in knots trying to use administrative accounts for non-administrative purposes.

- V

VaidhyPanday · ‎02-21-2016

can we use system user credentials.

because it logged as normal user..

VinceAngelo · ‎02-21-2016

Connecting as any administrative user (SYS/SYSDBA/root/sa/postgres/...) for other than adminstrative use is an antipattern. Doing so puts your entire database instance at risk from one wrong click. "Worst practice" doesn't capture the risk adequately. Please do not do this!

Instead, use that administrative user to create the needed tablespaces, users, and roles, then put the password on an index card in a locked filing cabinet and forget it.

- V

VaidhyPanday · ‎02-20-2016

it is username and password for connecting database.

for avoiding any access and grant ,I am using SYS user.

DanPatterson_Retired · ‎02-20-2016

oh makes sense. Now the links that are similar to yours to the right of your post, which wouldn't have appeared when you posted, have a few suggestions. One link suggests that there is a patch that is needed

Issue in Oracle ArcGIS connection have a look and if that doesn't work, try the other links, or search this site using ... Oracle connection ... as a keyword search

AsrujitSengupta · ‎02-20-2016

Are you able to connect using SQLPLUS?
Do you have the Oracle Full or Instant Client installed?
What is the bit-level of the Oracle Client installed?
What is the Oracle_SID (Database name), which you are trying to connect?
Do you have Oracle and ArcGIS installed on the same machine? If No, what is the database server name?

VaidhyPanday · ‎02-20-2016

hi asrujit,

1)i am able to login using SQLPLUS .

2) i have installed oracle 11gr2 after that i installed Instant 32 bit client ..dont know exactly what Oracle Full stands for ?

3)i have installed 64 bit oracle client.

4)oracle SID MyLappy

5)i have installed oracle and ArcGis on same machine.