How To: CONNECT to Oracle 9i on Windows using ArcInfo Workstation 9.0


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


  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.

    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:

    ARC/INFO 9.0 - Oracle Server

  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.


  7. CONNECT to Oracle.

    Arc: connect oracle system/oracle@ora920

Related Information