CONNECT to Oracle 9i on Windows using ArcInfo Workstation 9.0

Summary

Instructions provided describe creating a DBI connection to an Oracle 9i (9.2.0.3) server from ArcInfo Workstation 9.0 on Windows.

Procedure

1. Install the Oracle 9i client software if necessary.
2. Test that a SQLPlus connection can be made to the Oracle 9i server from a DOS command line on the client machine where ArcInfo Workstation will be run.
   
   

   Code:
   C:\>sqlplus system/oracle@ora920

   
   Do not proceed with the remainder of this article until a successful SQLPlus connection is made. Please consult Oracle and Oracle documentation in troubleshooting SQLPlus connections.
3. Open C:\arcgis\arcexe9x\database\oracle.dbs in a text editor such as Notepad.
4. Append the file as shown below:
   
   

   Code:
   ARC/INFO 9.0 - Oracle Server
   $ARCHOME/bin/dbi_oracle9i

   
   
5. Save the changes and close the text editor.
6. Quit SQLPlus and start ArcInfo in the same window that a successful SQLPlus connections was made.
   
   

   Code:
   C:\>arc

   
   
7. CONNECT to Oracle.
   
   

   Code:
   Arc: connect oracle system/oracle@ora920