Installation and Upgrade Guides › Policy Server Installation Guide › Installing Reports › Reporting Installation Checklists › Report Database and Audit Database

Report Database and Audit Database

• If you are not using the embedded version of MySQL, be sure that you are using a supported database to function as the report database.
• If you are not using the embedded version of MySQL, be sure that the database client and server are configured to use UTF8 character encoding.

  Note: For more information about the required settings for a Unicode configuration, see your vendor-specific documentation.

• (SQL Server) If you are using SQL Server as a report database, an audit database, or both, do the following on the Report Server host system:
  • Be sure that a SiteMinder supported SQL Server driver is installed on the Report Server host system.
  • Create a data source name (DSN) that identifies each database. The Report Server uses the DSN to communicate with each database.
• (Oracle) If you are using Oracle as a report database, an audit database, or both, do the following on the Report Server host system:
  • Be sure that a supported Oracle Net client is installed on the Report Server host system.
  • Use an Oracle Net Service Name to identify each database in the tnsnames.ora file. The Report Sever uses the service name to communicate with each database.
• (Oracle) If you are using Oracle Net client to connect to the report database or an audit database, do the following on the Report Server host system:
  • Set the ORACLE_HOME variable to Oracle_Net_client.

    Oracle_Net_client

    Specifies the Oracle Net client installation path.

    Windows Example: C:\oracle\product\10.2.0\client

    UNIX Example: export ORACLE_HOME=/opt/oracle/product/10.2.0/client1

  • (Windows) Add the ORACLE_HOME variable to the system environment variables.

    Example: %Oracle_Home%\bin

  • (UNIX) Set the LD_LIBRARY_PATH variable to $ORACLE_HOME/lib32:$ORACLE_HOME/lib.

    Example: LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$LD_LIBRARY_PATH

  • (UNIX) Set the PATH variable to $ORACLE_HOME/bin:$PATH.

    Example: export PATH=$ORACLE_HOME/bin:$PATH