Required Files, Database Instances, Collation Requirements, and Database Locations

Previous TopicNext TopicContents

Oracle tnsnames.ora File Requirements

Ensure that the tnsnames.ora file contains references to the P6 EPPM database and the P6 Reporting Database. The tnsnames.ora file must be on the machine where you installed your P6 Reporting Database application.

Required Database Instances

The P6 Reporting Database instance for ODS or Star must already exist based on which database you're using. ODS and Star schemas can be in the same instance or separate instances.

Database Collation Requirements

The database collation must match the database collation you set for the P6 EPPM database when you created it.

Recommended Database Instance Locations

Oracle recommends that the database instance reside on different physical machines from the P6 EPPM database. This minimizes the impact that the P6 Reporting Database has on the performance of the P6 EPPM database server.



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

Last Published Friday, January 31, 2014