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