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 firstname.lastname@example.org.
Hope this helps.
Vaidhy, what was underneath the top dialog?
it is username and password for connecting database.
for avoiding any access and grant ,I am using SYS user.
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.
can we use system user credentials.
because it logged as normal user..
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.
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
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.
The connection string is incorrect.....you spelt your database name as 'MAYLAPPY' instead of MYLAPPY !
i changed and checked but still getting same error
Can you just login from SQLPlus and post a screenshot of that. Don't post your passwords!
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:
i tried all the combinations... servername/servicename
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)
i have installed 11gr2 release oracle client
now i am able to connect database.
Retrieving data ...