Use Direct Connect to connect to an Oracle Server from a UNIX workstation client with Database Access 2.1c

Summary

Database Access 2.1c on a UNIX client workstation provides Direct Connect functionality to access an Oracle instance only. The Database Access 2.1c direct connect drivers for Oracle are only supported on Oracle instances running release 8.1.2 or higher. Oracle 8.0.x releases are not supported.

Database access applications function the same whether using an ArcSDE 8.1.2 or lower version, service, or database instance via Direct Connect.

Procedure

1. Once the Oracle Net 8 software is installed on your system, obtain the following information:
   
   server name
   ORACLE_SID
   user name
   user password
   
   Example:
   
   server name: "luck"
   ORACLE_SID = "luk817"
   user name = "avtest"
   user password = "go"
2. Start ArcView.
3. Load the Database Access extension.
   A. Select File > Extensions
   B. Check the check box next to 'Database Access.'
4. Open a view.
5. Select View > Add Database Theme.
6. Select the 'Create a new connection using SDE' option.
7. Enter the connection information with the following syntax:
   
   A. the Instance name should be replaced with the "sde:database_name" syntax
   
   B. the Password name should be replaced with the "password:@ORACLE_SID" syntax
   
   Example:
   
   Server:Instance: "luck:sde:oracle"
   User: "avtest"
   Password: "go@luk817"
8. Proceed to work as you normally would with an SDE service connection.
   
   

   Note:
   To test that your Oracle setup is correct you can use SQL connect feature of ArcView, or the Avenue connection  syntax:
   SDEConnection.Make ("luck:sde:oracle","","username","password@luk817")

   
   
   

   Note:
   Details for Net Service install are in the ArcSDE Configuration and Tuning Guide for Oracle, located in the $AVHOME\AvDocs directory after you complete your ArcView install.