SAS/ACCESS Interface to Oracle 7.3.2 for Solaris 2
===================================================

A) With Oracle version 7.2.3 and 7.3.2 on Solaris2 Sun workstations, the
   onsite link of SAS/ACCESS to Oracle may fail. The user may also notice
   the error when SAS/ACCESS to Oracle attempts to load and the user
   may receive the error message 'unable to load code appendage'.  Some of
   the Oracle libraries shipped with 7.2.3 and 7.3.2 are a mixture of
   pic and non-pic objects, and SAS can not build an access module with
   this mixture.  To repair the Oracle libraries, the Oracle dba can
   request a fix with the following patch numbers for Oracle bug #304498.

       Oracle 7.2.3 - Oracle patch #362450
       Oracle 7.3.2 - Oracle patch #369322

   The correct procedure for SUN/SOLARIS customers calling Oracle are:

     1) Have them call Oracle support and open a new TAR under
        their own CSI numbers.
     2) Reference the bug #304498 and appropriate patch number
        for their Oracle Release.

   Once the Oracle patch is applied, then perform the Post-Installation
   onsite link again using the NEW link script changes.  The NEW 
   zdbiora.ins link script can be found on SAS' FTP Server (FTP.SAS.COM)
   in the directory /techsup/download/maint/access/oracle/SOL2/6.12.
   Download the link script, zdbiora.ins.7.3.2.sol2.ts020, using BINARY
   format and copy to !sasroot/install/zdbiora.ins.

   Before you perform the onsit link again, set the environment variables
   requried below to avoid problems during the testing phase.

B) FREE CHAIN OVERLAP and GENERIC CRITICAL errors will be generated when
   terminating a SAS session that was using SAS/ACCESS Interface to Oracle
   and the sasorav7 image that was linked with the Oracle 7.3.2 librairies.

   This is an Oracle bug referenced by bug #397528 where Oracle frees memory 
   twice.

   Per Oracle, to circumvent this problem, you will need to set the following 
   environment variables (be sure the ORACLE_HOME environment variable is set
   before you set the following environment variable -OR- fully qualify the
   $ORACLE_HOME). 

      export LD_LIBRARY_PATH=/usr/ucblib:$ORACLE_HOME/lib
      export EPC_DISABLED=TRUE

####################### INSTRUCTIONS ############################
 
 1) apply the Oracle patch referenced above that pertains to your 
    Oracle release.
 
 2) save the original install script, !sasroot/install/zdbiora.ins:

    ie.  mv !sasroot/install/zdbiora.ins !sasroot/install/zdbiora.org

 3) download the new install script and new oracle libraries,
    /techsup/download/maint/access/oracle/SOL2/6.12/zdbiora.ins.7.3.2.sol2.ts020
    from FTP.SAS.COM:


    ie. FTP> binary
        FTP> get zdbiora.ins.7.3.2.sol2.ts020 !sasroot/install/zdbiora.ins

 4) Apply the appropriate Oracle patch for your release.

       Oracle 7.2.3 - Oracle patch #362450
       Oracle 7.3.2 - Oracle patch #369322

 5) cd !sasroot

 6) set the following environment variables (be sure the ORACLE_HOME environment 
    variable is set prior to setting the following ones -OR- fully qualify the
    $ORACLE_HOME). 

     i.e.  > export LD_LIBRARY_PATH=/usr/ucblib:$ORACLE_HOME/lib
           > export EPC_DISABLED=TRUE


 7) invoke SASMANAGER and relink SAS/ACCESS to Oracle

   ie.     ./sasmanager

 8) cd !sasroot/sasexe/dbi or !sasroot/solaris2/sasexe/dbi (if dual installed).
 
 9) make sure the sasorav7 image generated from the link has read and execute 
    permissions.

   ie. chmod 755 sasorav7