My Oracle Support Banner

Orpm_reset_priv.sql Script Is Not Executing in the Last Steps of migrate.bat When Migrating One Oracle Instance to Another in P6 EPPM 16.2.4.0 (Doc ID 2445925.1)

Last updated on OCTOBER 22, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.4.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When migrating from one oracle instance to another in P6 EPPM 16.2.4.0 using migrate.bat, orpm_reset_priv.sql script is not executing in the last steps of migrate.bat on a target oracle instance. The migrate runs successfully, but none of the roles are created except the PM_BG_JOB_ROLE. The migration is NOT running the orpm_reset_priv script that creates these new roles.

EXPECTED BEHAVIOR

Migration from one oracle instance to another in P6 EPPM 16.2.4.0 should be done successfully.

Steps to Reproduce:

    1. Create an oracle instance with schema users
    2. Create another oracle instance without the schema users for migration
    3. Run Migrate.bat from the 16.2.4.0 media
    4. Notice in step creating Reporting Views, orpm_reset_priv.sql is not executing at end of migration on a target oracle instance.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.