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 (Doc ID 2445925.1)

Last updated on MARCH 22, 2022

Applies to:

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



When migrating from one oracle instance to another in P6 EPPM 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.


Migration from one oracle instance to another in P6 EPPM 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 media
    4. Notice in step creating Reporting Views, orpm_reset_priv.sql is not executing at end of migration on a target oracle instance.


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

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