Patrick-Dussault

Fast Tracks to configure a Session Store on Linux for the Policy Server.

Blog Post created by Patrick-Dussault Employee on Dec 17, 2018

Here are fast tracks to configure on Linux a Session Store ODBC :

 

# unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
# rpm -Uvh Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
# Specify the HTTP port that will be used for Oracle Application Express [8080]: 8181
# Specify a port that will be used for the database listener [1521]:
# Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:password
Confirm the password:password
# Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y

Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.

 

# source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
# sqlplus system

 

Create the SMUSER, which will be used in the Policy Server
configuration in order to connect to the database, give to this user
all needed permissions, and verify that everything has been set :

 

SQL> create user SMUSER identified by CAdemo123;
SQL > CREATE SMALLFILE TABLESPACE "SESSIONSTORE" DATAFILE '/u01/app/oracle/oradata/XE/sessionstore.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 8G LOGGING DEFAULT NOCOMPRESS ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
SQL> alter user SMUSER default tablespace SESSIONSTORE temporary tablespace temp;
SQL> GRANT CREATE SESSION TO SMUSER WITH ADMIN OPTION;
SQL> GRANT CONNECT TO SMUSER;
SQL> GRANT CONNECT, RESOURCE, DBA TO SMUSER;
SQL> GRANT UNLIMITED TABLESPACE TO SMUSER;

 

Check that the user SMUSER as been correctly configured with the
expected tablespace :

 

SQL> select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
SMUSER SESSIONSTORE

 

Check that the database has charset AL32UTF8 configured :

 

SQL> SELECT * FROM nls_database_parameters;
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_ISO_CURRENCY
AMERICA

NLS_NUMERIC_CHARACTERS
.,

NLS_CHARACTERSET
AL32UTF8

 

Then, import the Session Store data structure into the tablespace. Run

the command as root :

 

# sqlplus SMUSER/CAdemo123@XE @/opt/CA/siteminder/db/SQL/sm_oracle_ss.sql

 

Then configure the Policy Server system_odbc.ini as per this sample :

 

[My Session Data Source]
Driver=/opt/CA/siteminder/odbc/lib/NSora27.so
Description=DataDirect 7.1 Oracle Wire Protocol
HostName=duspa01-u161157.ca.com
PortNumber=1521
LoginID=SMUSER
Password=mypassword
ServiceName=XE
#SID=XE
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
DMCleanup=2

Outcomes