Setting up the databases for TrueSight Server Automation - Data Warehouse

Before installing , you must set up the required databases, as described in the following topics:

To use  in non-English locales, see To configure TrueSight Server Automation databases for a non-English locale.

To use  with Oracle Exadata, do the following:

1. Log in to the system where the Oracle Database is installed.
2. Configure the following system-level parameters:
   
   1. Set the value for the PARALLEL_DEGREE_POLICY parameter to AUTO or ADAPTIVE by running the following command:
      ALTER SYSTEM SET PARALLEL_DEGREE_POLICY = ADAPTIVE
   2. Set the value for the GLOBAL_NAMES parameter to FALSE by running the following command:
      ALTER SYSTEM SET GLOBAL_NAMES = FALSE

For a multi-site deployment of , where a secondary  site uses a different character set, the following setup is supported:

• Application Server 1 database uses CHAR.
• Application Server 2 database uses NCHAR.
•  server 1 database uses NCHAR.

 server 1 cannot use CHAR because you cannot run ETL from an NCHAR database to a CHAR database.