English

How To: 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


Related Information