English

Bug: Unable to set up Direct Connect for Oracle with ArcGIS Server on Solaris or Linux

Description

When using Direct Connect on Solaris or Linux, ArcGIS Server does not connect successfully.

Warning:
ArcGIS Server 9.2 is unable to direct connect to Oracle on Solaris. This is a limitation of 32-bit library availability on Solaris. This Article is for 9.1 and 9.0.1 versions.

Cause

This is a known issue in the ArcGIS Server installation; it applies the wrong name to a file that contains the direct connect resources.

Workaround

Use the following procedure to work around this issue. Apply the normal procedure to enable direct connect between the ArcGIS Server Container and the database first.

  1. Set the following variables in the <ArcGIS Server>/bin/arcsoc.init file just before the exec $* statement:

    Code:
    SDEHOME=<ArcGIS Directory>;export SDEHOME

    ORACLE_HOME=<Oracle Client Directory Location>;export ORACLE_HOME

    LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH};export LD_LIBRARY_PATH

    For example:

    With ArcGIS installed to: /rapid1/ags91/arcgis and Oracle Client located in: rapid1/ora92/app/oracle/product/9.2.0 the settings would be:

    Code:
    SDEHOME=/rapid1/ags91/arcgis;export SDEHOME

    ORACLE_HOME=/rapid1/ora92/app/oracle/product/9.2.0;export ORACLE_HOME

    LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH};export LD_LIBRARY_PATH

    Optionally, if the tnsnames.ora file is not in the default location, it may be specified with the additional variable:

    TNS_ADMIN=/rapid1/ora92/app/oracle/product/9.2.0/network/admin;export TNS_ADMIN

    Default location below the client install shown above.
  2. Create a link named 'lib' that points to the ArcGIS Server /bin directory by running the following command in the ArcGIS Server directory:

    Code:
    ln -s ./bin lib

  3. Verify that the link was created successfully by running the following command:

    Code:
    ls -al lib

    The output should look similar to the following:

    Code:
    lrwxrwxrwx 1 root other 5 Sep 23 22:45 lib -> ./bin

  4. Restart ArcGIS Server and MainWin

    Code:
    stopserver

    mwadm stop

    mwadm start

    startserver