How To: Use Direct Connect to connect to an Oracle Server from a UNIX workstation client with Database Access 2.1c
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.
To use direct connect, you must have the Oracle Net8 Client installed on your UNIX workstation. Direct connect is managed through the Oracle Net8 client.
The Net Service Name must be configured in order to connect to the server.
- Once the Oracle Net 8 software is installed on your system, obtain the following information:
server name: "luck"
ORACLE_SID = "luk817"
user name = "avtest"
user password = "go"
- Start ArcView.
- Load the Database Access extension.
A. Select File > Extensions
B. Check the check box next to 'Database Access.'
- Open a view.
- Select View > Add Database Theme.
- Select the 'Create a new connection using SDE' option.
- 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
- Proceed to work as you normally would with an SDE service connection.
To test that your Oracle setup is correct you can use SQL connect feature of ArcView, or the Avenue connection syntax:
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.