This note provides a summary of system and installation requirements for SAS/ACCESS Interface to Oracle under UNIX.

Verify That the Software Is Licensed

First, you should verify that you have licensed the software. To do that, invoke the SAS^® System and submit the following SETINIT procedure in the SAS Program Editor:

proc setinit noalias; 
run;

If you check the SAS log, you should see SAS/ACCESS Interface to Oracle listed. If it is not listed, then the software is not licensed. If the software is listed, you need to verify that it is installed.

To verify that the SAS/ACCESS Interface to Oracle product is installed, the sasora file must reside in the !SASROOT/sasexe directory. (!SASROOT is the directory where SAS is installed). Submit the following commands to verify that sasora resides in the directory:

unix_prompt> cd !SASROOT/sasexe
unix_prompt> ls -la sasora

If the sasora file does not exist, then the software is not installed.

Verify System Requirements

• Base^® SAS software
• SAS/ACCESS Interface to Oracle
• Oracle SQL*Net Client

• The minimum required Oracle 8 release is Oracle, Release 8.1.7.2.x (64-bit libraries).
• The minimum required Oracle 9 release is Oracle, Release 9i (64-bit libraries).

The Oracle release can vary depending on the the UNIX platform and the SAS software release. You need to verify that you meet the system requirements by selecting the appropriate operating system from SAS 9.1.3 Operating System-Specific Documentation and viewing the system requirements documentation for SAS/ACCESS Interface to Oracle.

Configure the Software

If you meet the system requirements and you have all the necessary software, you must now configure SAS/ACCESS Interface to Oracle according to the instructions in the Configuration Guide for SAS^® 9.1.3 Foundation for UNIX Environments.

Be sure that you have all of the appropriate environment variables set corrrectly.

Note: It is recommended that the environment variables should be set in the sasenv_local file that is located in the !SASROOT/bin directory. For releases earlier than SAS 9.1.3 Service Pack 4, the recommendation is to set environment variables in the sasenv file.

You also need to verify that your Oracle environment is configured correctly outside of SAS. To do that, test a connection using the Oracle SQL*PLUS utility on the SAS server, as follows:

unix_prompt> sqlplus user-name/password@database-name
sql> select count(*) from table-name
sql> exit

In this example, user-name, password, database-name, and table-name are valid Oracle values.

If you CANNOT connect to the Oracle database using SQL*PLUS, contact your Oracle database administrator for assistance.

Once you are able to connect to the Oracle database using SQL*PLUS and you have configured SAS correctly, you are now ready to access Oracle from within SAS. You can use the following LIBNAME statement engine with SAS/ACCESS Interface to Oracle to test your connection:

libname libref oracle user=user-name password=password database=database-name;
   /*  Use the same connection values that you used with SQL*PLUS.*/
 
proc sql;
   select count(*) from libref.table_name;
quit;
 
data work.new;
   set libref.table-name;
run;

Operating System and Release Information