Configuring Global Names for the Oracle Database Instance

The STARETL process creates and uses database links that do not match the global name used in the P6 EPPM and Primavera Unifier database instances. For an Oracle database, you must set the global_names parameter in the P6 EPPM and / or Primavera Unifier database instance to FALSE.

To do this, complete the following steps:

  1. Sign in to the P6 EPPM and/or Primavera Unifier instance as a user with DBA privileges. For example, SYSTEM.
  2. Run the following statement:

    show parameter global_names;

  3. If the parameter value equals TRUE, run the following statement:

    alter system set global_names=FALSE;

    Note: Running this statement does not require the database instance to be restarted.


Last Published Thursday, December 12, 2024