Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › How to Configure a SiteMinder Data Store in an Oracle Database › Create an Oracle Database With SiteMinder Schema

Previous Topic: Create an Oracle 10g User to Manage the Policy Store’s Table Space

Next Topic: Create the Oracle Database For the Policy, Key, Logging, or Session Data Stores
Create an Oracle Database With SiteMinder Schema

SiteMinder provides schema files to create the individual schema for storing policies, keys, logs, session data, and sample users. The following schema files are provided in the siteminder_home\db\SQL directory:

sm_oracle_ps.sql

Creates the SiteMinder policy store or key store (if you are storing keys in a different database) in an Oracle database.

sm_oracle_logs.sql

Creates the schema for SiteMinder audit logs in an Oracle database.

sm_oracle_ss.sql

Creates the schema for the SiteMinder session server in an Oracle database.

smsampleusers_oracle.sql

(Optional) Creates the schema for SiteMinder sample users in an Oracle database and populates the database with sample users. For example, the script includes a user named GeorgeC with a password of siteminder.

Create the database objects by running the appropriate SQL script using SQL Plus for Oracle.

Note: For information about running SQL scripts, see your database documentation.

If you are creating a schema for an Oracle database, be sure to create an Oracle user, such as SMOWNER. Run the scripts as that user, which associates SiteMinder data files with the new user. We do not recommend that you create a schema with the SYS or SYSTEM users.

You can store SiteMinder data in a single Oracle database or run each script separately to create a separate:

More Information:

Delete SiteMinder Data in ODBC Databases