Oracle Installation and Configuration :: SAS® 9.4 In-Database Products: Administrator's Guide, Eighth Edition

Installing and Configuring Oracle

To install and configure Oracle, follow these steps:

If you are upgrading from a previous version, follow the instructions in Upgrading from a Previous Version before installing the in-database deployment package.
Install the in-database deployment package.

For more information, see Installing the In-Database Deployment Package for Oracle.
Create the required users and objects in the Oracle server.

For more information, see Creating Users and Objects for the SAS Embedded Process.
If you plan to use SAS Model Manager with the SAS Scoring Accelerator for in-database scoring, perform the additional configuration tasks provided in Configuring SAS Model Manager.

Note: If you are installing the SAS High-Performance Analytics environment, there are additional steps to be performed after you install the SAS Embedded Process. For more information, see SAS High-Performance Analytics Infrastructure: Installation and Configuration Guide.

Upgrading from a Previous Version

You can upgrade from a previous version of the SAS Embedded Process. Before installing the In-Database Deployment Package for Oracle, have the database administrator (DBA) notify the user community that there will be an upgrade of the SAS Embedded Process. The DBA should then alter the availability of the database by restricting access, or by bringing the database down. Then, follow the steps outlined in Installing the In-Database Deployment Package for Oracle.

Installing the In-Database Deployment Package for Oracle

Unzipping the In-Database Deployment Package for Oracle

The in-database deployment package binary files for Oracle are contained in a self-extracting archive file named sepcoreorcl-12.00000-1.sh. This file is contained in a ZIP file that is put in your SAS Software Depot directory.

To unzip the in-database deployment package for Oracle, follow these steps:

Create a new temporary directory on your client machine such as /sasep. The new directory is referred to as EPZipDir throughout this section.
Navigate to the YourSASDepot/standalone_installs directory. This directory was created when you created your SAS Software Depot.
Locate the en_sasexe.zip file. The en_sasexe.zip file is located in the YourSASDepot/standalone_installs/SAS_Core_Embedded_Process_Package_for_Oracle/12_0/Oracle_on_Linux/ directory.

The sepcoreorcl-12.00000-1.sh file is included in this ZIP file.
Copy the en_sasexe.zip file to your EPZipDir temporary directory on the client machine.
```
cp en_sasexe.zip /EPZipDir
```
Navigate to your EPZipDir temporary directory and unzip en_sasexe.zip.

After the file is unzipped, a sasexe directory is created in the same location as the en_sasexe.zip file. The sepcoreorcl-12.00000-1.sh is in the /EPZipDir/sasexe directory.

Move the SAS Embedded Process Package to the Oracle Server

To move and copy the Oracle in-database deployment package, follow these steps:

Using a method of your choice (for example, PSFTP, SFTP, SCP, or FTP), move the sepcoreorcl-12.00000-1.sh file to a directory of your choice. It is recommended that you create a SAS directory under your home directory. An example is /u01/pochome/SAS. This directory is referred to as path_to_sh_file.
Copy the sepcoreorcl-12.00000-1.sh file onto each of the RAC nodes using a method of your choice (for example, DCLI, SFTP, SCP, or FTP).
Note: This might not be necessary. For RAC environments with a shared Oracle Home, you can also use one of these methods:
- Copy the extracted directories from a single node.
- Copy the self-extracting archive file to a directory common to all the nodes.
  
  Note: As a best practice, you should always deploy from an empty directory.
- If the file system is not a database file system (DBFS), extract the file in one location for the whole appliance.

Unpack the SAS Embedded Process Files

V9.4M4 16w48 Defects S1279019, and S1285593 Updated new sepcore package method which replaces tkindbsrv KMM 10/21/16

For each node, log on as the owner user for the Oracle software using a secured shell, such as SSH. Follow these steps:

Change to the directory where the sepcoreorcl-12.00000-1.sh file is located.
Change permissions on the file to enable you to execute the script.
```
chmod 755 -r sepcoreorcl-12.00000-1.sh
```
Use this command to unpack the self-extracting archive file.
```
./sepcoreorcl-12.00000-1.sh
```
After this script is run and the files are unpacked, a SAS tree is built in the current directory. The content of the target directories should be similar to the following, depending on the path to your self-extracting archive file. Part of the directory path is shaded to emphasize the different target directories that are used.
```
/path_to_sh_file/SASEPHome/admin
/path_to_sh_file/SASEPHome/bin
/path_to_sh_file/SASEPHome/logs
/path_to_sh_file/SASEPHome/misc
/path_to_sh_file/SASEPHome/sasexe
/path_to_sh_file/SASEPHome/utilities
```
On non-shared Oracle home systems, update the contents of the $ORACLE_HOME/hs/admin/extproc.ora file on each node. On shared Oracle home systems, you can update the file in one location that is accessible by all nodes.

Note: Ask your DBA if the ORACLE_HOME environment variable is not set.
1. Make a backup of the current extproc.ora file.
2. Add the following settings to the file making sure to override any previous settings.
  
  SET EXTPROC_DLLS=ANY SET EPPATH=/path_to_sh_file/SASEPHome/ SET TKPATH=/path_to_sh_file/SASEPHome/sasexe
On non-shared Oracle home systems, update the contents of the $ORACLE_HOME/network/admin/sqlnet.ora file on each node.
1. Make a backup of the current sqlnet.ora file. If the file does not exist, create one.
2. Add the following setting to the file.
  
  DIAG_ADR_ENABLED=OFF

Creating Users and Objects for the SAS Embedded Process

V9.4M4 16w48 Defects S1279019, and S1285593. Updated path. KMM 10/21/16

After the In-Database Deployment Package for Oracle is installed, the DBA must create the users and grant user privileges. The DBA needs to perform these tasks before the SAS administrator can create the objects for the Oracle server. The users and objects are required for the SAS Embedded Process to work.

Note: SQLPLUS or an equivalent SQL tool can be used to submit the SQL statements in this topic.

Create a SASADMIN user.

To create the user accounts for Oracle, the DBA must perform the following steps:
1. Change the directory to /path_to_sh_file/SASEPHome/admin.
2. Connect as SYS, using the following command:
  
  sqlplus sys/<password> as sysdba
3. Create and grant user privileges for the SASADMIN user.
  
  Here is an example of how to create a SASADMIN user.
  CREATE USER SASADMIN IDENTIFIED BY <password> DEFAULT TABLESPACE <tablespace-name> TEMPORARY TABLESPACE <tablespace-name>; GRANT UNLIMITED TABLESPACE TO SASADMIN;
4. Submit the following SQL script to grant the required privileges to the SASADMIN user.
  SQL>@sasadmin_grant_privs.sql
5. Log off from the SQLPLUS session using “Quit” or close your SQL tool.
Create the necessary database objects.

To create the objects and the SASEPunzipFUNC table function that are needed to run the scoring model, the SAS administrator (SASADMIN) must perform the following steps:
1. Change the current directory to /path_to_sh_file/SASEPHome/admin (if you are not already there).
2. Connect as SASADMIN, using the following command:
  
  sqlplus sasadmin/<password>
3. Submit the following SQL statement:
  
  @create_sasepfunc.sql;
  
  Note: You can ignore the following errors:
  ORA-00942: table or view does not exist ORA-01432: public synonym to be dropped does not exist