Is This Content Helpful?
We're glad to know this article was helpful.
You can add tables from an Oracle database to ArcView. However you must correctly configure the Oracle client in order to make a connection. This document discusses how to configure the Oracle client.
· The following environment variables MUST be defined on the computer where ArcView is installed:
¤ TNS_ADMIN - The path to your tnsnames.ora file.
The Service Name entries in the tnsnames.ora file describe the location of the database, the networking protocol, and other necessary connection information. Service Names (or database aliases) are created by the database administrator.
You can forgo installing the Oracle Client on the local machine and set ORACLE_HOME to the installation directory for Oracle Server, or the installation directory of Oracle Client on another computer. While this will work in most cases, this configuration is not supported by Oracle or ESRI; use it at your own risk.
This variable set a default service. All that is required for the connection string when logging in is username/password. If the user wishes to connect to a different service, the connection string must be in the form of username/password@. If TWO_TASK is not set, the connection string must always include the service. In order for the configuration to be supported by Oracle or ESRI, this variable must be set to a service listed in the tnsnames.ora file.