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

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