Pre-installation for the Star Database

Previous TopicNext TopicContents

Ensure you:

Check

Item

 

Reviewed the P6 Analytics and P6 Reporting Database Planning and Sizing Guide for sizing and spacing guidelines.

 

Have a tablespace called STAR_DAT1.

 

Have a tablespace called STAR_HST1.

 

Set the tablespace with Auto Extend On.

 

Set the tablespace extent management to Local.

 

Set the characterset to UTF8 or WE8MSWIN1252. P6 Analytics also supports the AL32UTF8 characterset.

 

Set the characterset to the same characterset used in the P6 EPPM database.

 

Set the Star tablespace to at least the same size as the P6 EPPM database.

 

Run the queries to validate database settings. See the database scripts listed in Appendix A2 at the end of this document.

 

Set datafiles to autoextensible.

 

Set maxbytes to the OS's maximum, which is typically 32 GB with minimum 2 files. Use 3 to 5 files for larger systems.

 

Run the queries to validate the UNDO Tablespace settings. See the database scripts listed in Appendix A2 at the end of this document.

 

Run the queries to validate the SGA settings on the database. See the database scripts listed in Appendix A2 at the end of this document.

Note: Larger systems require 8 GB.

 

 

Run the queries to validate the Archive Log Mode on the database. See the database scripts listed in Appendix A2 at the end of this document.

Note: This should be in NON archive log mode.

 

 

Execute the following SQL to verify the tablespace:

select s.tablespace_name, f.file_name, f.maxbytes, f.autoextensible from dba_data_files f inner join dba_tablespaces s on s.tablespace_name = f.tablespace_name where s.tablespace_name like '%STAR%';

 

 

Have both block buffer and individual process memory available.

 

Setup the database instance using Dedicated Server (not Shared Server).

 

Set the minimal value set for the MEMORY_TARGET variable:

For an Oracle 11g database, the recommended minimum MEMORY_TARGET is 2 GB.

For an Oracle 10g, set SGA_TARGET to the same minimum value.

For all other versions, let the database server manage its own memory.

 

 

Can connect JDBC and OCI on the Star server.

Note: You can test the connection with a sample Java application.

 

Decided whether there will be multiple data sources. The sizing requirements will apply for each individual data source included.

 

Verified that you are using one of the following database versions.

See the Tested Configurations document for more information on supported databases.

Related Topics

Checklist for P6 Analytics and the Star Database

Pre-installation for an Oracle Platform

Pre-installation for a Microsoft SQL Server Platform

Pre-installation for Configuring the ETL Server

Installation: Installer And Configuration

Installation: Running The Processes

Post-installation: After The Processes Complete

Database Scripts For Validations



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014