Perform the following pre-installation checks on your system:
-
Remove JAVA_HOME and ANT_HOME system environment variables from the machine on which you are installing the HxGN EAM Advanced Reporting Server. User environment variables are acceptable, but system variables for JAVA_HOME and ANT_HOME will cause the installer to fail.
-
For an Oracle HxGN EAM Advanced Reporting Server installation, install Oracle client tools (version 9.2 or higher) and SQL Plus on the report server machine.
In a distributed installation environment, install Oracle client tools on each Report
Server machine.
Content Store Database
The content store schema must be installed on a multi-byte (Unicode) database instance.
-
To determine if the database is Unicode. One method is to type the following select statement: select * from NLS_DATABASE_PARAMETERS
-
The result set returns NLS_CHARACTERSET is UTF-8 or UTF-16, or AL32UTF8 or AL16UTF16, or not Unicode. If the result set returns an NLS_CHARACTERSET that is not Unicode, create a new database.
-
For Oracle 12c, specify AL32UTF8 or AL16UTF16 for the database character set parameters.
The Oracle Client must be 12c 32-bit Database Server for Oracle installs.
-
To determine which user account the Advanced Reporting Server will use to access the content store:
-
Ensure that the user account that accesses the content store has permissions to do the following: connect to the database; create, alter, and drop tables, triggers, views, procedures, and sequences; insert, update, and delete data in the content store tables. It is recommended that you create the content store schema in a separate tablespace.
HxGN EAM Database
-
Set up a tnsnames.ora entry for the HxGN EAM database server. This entry should be in the form <server name>_<instance name> (e.g., myserver1_inst1), where the values for server name and instance name match those specified in the HxGN EAM application server ewsconfig.xml file.
-
For a SQL Server Advanced Reporting Server installation, install SQL Server client tools (or Connectivity Only) on the report server machine. TCP/IP connectivity is required for SQL Server.
In a distributed installation environment, install SQL Server client tools on each
Report Server machine.
-
Create an empty database in Oracle or SQL Server to use as the HxGN EAM Advanced Reporting Server content store, and create a user for this database that has rights to create, delete, and access objects.
-
For SQL Server, the content store database must be created using a case-insensitive collation type. For example, Latin1_General_CI_AS. It is recommended that you create a login in SQL Server, set the database as the default for the user, and grant that user dbo rights to the database. Then, use this user’s connection information to connect to the content store.