Setting up a direct connection to Oracle |
|
Release 9.3
Last modified December 3, 2010 |
![]() ![]() ![]()
|
Note:
This topic was updated for 9.3.1.
To make a direct connection from a client machine to the Oracle database requires the Oracle client be installed on the client machine, the tnsnames.ora file be altered on the client, and an ODBC connection created.
Oracle Net is required on each client machine you want to directly access your Oracle DBMS.
sqlplus <user name>/<password>@<Oracle Net service name>
Tips |
The sde:oracle** tells the ArcSDE client API which driver you are looking for, not to which database you are connecting. In other words, an Oracle 11g driver will connect to a 10g database and vice versa. The drivers differ in the version of Oracle with which they were built. If you have Oracle9i client software on the local machine, use: sde:oracle9i For connections from a local machine with the Oracle 10g client, use the syntax: sde:oracle10g If you have Oracle9i, Oracle 10g, or Oracle 11g client software on the local machine and try to connect with the server string: sde:oracle you will get the following error message: Failed to Connect to Specified Server. Underlying DBMS Error [ Unknown Error. No extended error] mypassword@<Oracle Net Service name> |