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.
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.
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
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.
The connection string is incorrect.....you spelt your database name as 'MAYLAPPY' instead of MYLAPPY !
sorry ,
i changed and checked but still getting same error
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)
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
can we use system user credentials.
because it logged as normal user..
yes.
i have installed 11gr2 release oracle client
Thnaks sir,
now i am able to connect database.
Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
