Contents
How to connect to Oracle from ArcGIS for desktop?
To connect to a database or geodatabase in Oracle from ArcGIS for Desktop, install an Oracle client on the ArcGIS for Desktop computer, set the PATH environment variable to the location of the Oracle client, and create a connection file in the Catalog tree. Install the Oracle client
How do I connect to a database from ArcMap?
To connect to a database or geodatabase in Oracle from ArcMap, install a 32-bit Oracle client on the ArcMap computer, set the PATH environment variable to the location of the Oracle client, and create a connection file in the Catalog tree.
Where is the database connection node in ArcGIS?
You can connect to a database or geodatabase in Oracle by adding a database connection under the Database Connections node in the Catalog tree in ArcGIS for Desktop. If you have connection files that were created prior to ArcGIS 10.1, they will still work.
Why is there an ora-01031 error in ArcGIS?
Error: ORA-01031: insufficient privileges. ArcGIS software calls the subprogram when creating a connection to the Oracle database to obtain the database parameter ‘open_cursors’ value. The value is required to ensure the ArcGIS session working with the Oracle instance does not exceed the maximum number of cursors available within the session.
Can you use ArcGIS on the same computer?
If both ArcGIS for Desktop and ArcGIS for Server are installed on the same Windows computer, set the PATH variable to read the 64-bit client before the 32-bit client.
Is there Easy Connect syntax for Oracle Server?
If you have the full Oracle client installed but want to use Easy Connect syntax to connect, be sure the sqlnet.ora file on the client is configured to allow the use of Easy Connect and the Oracle server is configured to allow Easy Connect syntax.
Do you need to change the default configuration for ArcGIS?
ArcGIS does not require that you change your Oracle instance from its default configuration to run. However, for larger systems, you may want to make some changes to the Oracle instance configuration.
What kind of database do I need for ArcGIS?
See Database clients for more information. ArcGIS clients connecting to Oracle must use an Oracle 11.2.0.4 or newer client.