Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Create a Sample User Directory for Oracle or SQL Server › Create a Sample User Directory for Oracle

Create a Sample User Directory for Oracle

If you are using an Oracle database as a user directory, run the smsampleusers_oracle.sql script to create a schema for it.

To create a sample Oracle user directory

1. Make sure the Oracle database instance that will contain the SiteMinder sample user data is accessible from the Policy Server machine. Test the communication using tnsping or sqlplus.
2. Create the sample user directory schema in the Oracle database:
   1. Log in to Oracle with sqlplus (or some other Oracle utility) as the user who administers the Policy Server database information.
   2. Import the script to create the sample users schema:

      $NETE_PS_ROOT/db/sql/smsampleusers_oracle.sql

      If you are using sqlplus, run the schema using an @ sign.

      Example: @$NETE_PS_ROOT/db/sql/smsampleusers_oracle.sql

Note: Environment variables may not function in Oracle's SQL utility. If you encounter problems when using the utility, specify an explicit path for $NETE_PS_ROOT rather than one with an environment variable.