Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Schema Files for Relational Databases › Oracle Schema Files

Oracle Schema Files

The following Oracle schema files are provided in the policy_server_home\db\SQL directory.

• policy_server_home

  Specifies the Policy Server installation path.

• 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_token.sql

  Creates the schema for storing token data, such as Encotone TeleID data, in an Oracle database.

• sm_oracle_ss.sql

  Creates the schema for the Session Server in an Oracle database.

• smsampleusers_oracle.sql

  Creates the schema for SiteMinder sample users in an Oracle database and populates the database with sample users. For example, if you look in the script, you can see a sample user named GeorgeC with a password of siteminder.

The following Oracle schema file is provided in the policy_server_home\xps\db directory.

• Oracle.sql

  Creates the XPS schema for an Oracle policy store.