Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › How to Configure the Policy Server for Crystal Reports › Create the Oracle Database Schema For Stored Procedures

Create the Oracle Database Schema For Stored Procedures

If you are using Oracle to store reporting information, run the
SmReportStoredProcedures_Oracle.sql script to create a schema for stored procedures in the logging database. You need to create the stored procedures, which the report files need to extract results from the database. This script is included in the <siteminder_installation>\reports directory.

siteminder_installation

Specifies the installed location of SiteMinder.

To create the Oracle database for stored procedures

1. Make sure the Oracle logging database instance that will contain the stored procedures schema is accessible from the Policy Server machine. Test the communication using tnsping or sqlplus.
2. Create the stored procedures schema in the Oracle logging database:
   1. Log in to Oracle with sqlplus (or some other Oracle utility) as the same Oracle user that you used to run the sm_oracle_logs.sql script.
   2. Import the script to create a schema for stored procedures:

      $NETE_PS_ROOT/reports/SmReportStoredProcedures_Oracle.sql

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

      Example: @$NETE_PS_ROOT/reports/ SmReportStoredProcedures_Oracle.sql

3. Configure the Oracle ODBC logs data source.

More Information:

Configure an Oracle ODBC Logs Data Source