Pre-installation for the ODS 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 ODS_DAT1.

 

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 ODS tablespace to at least 2.5 times larger than the size of 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 '%ODS%';

 

 

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 ODS server.

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

 

 

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 ODS 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