Installation 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 the database server host system has a fixed host name.
  • Be sure that you are using a supported database to function as the report database.
  • Be sure that a new, empty database is available.
  • Be sure that the database client and server are configured to use UTF8 character encoding. 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 SOA Security Manager 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.
    • 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.
    • Set the NLS_LANG variable to one of the following UTF–8 settings:

      – AMERICAN_AMERICA.WE8MSWIN1252

      – AMERICAN_AMERICA.AL32UTF8

    • 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

  • Do the following on the database server host system: Set the NLS_LANG variable to one of the following UTF–8 settings:
    • AMERICAN_AMERICA.WE8MSWIN1252
    • AMERICAN_AMERICA.AL32UTF8