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 |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014