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 126.96.36.199
(Doc ID 2445925.1)
Last updated on FEBRUARY 27, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
When migrating from one oracle instance to another in P6 EPPM 184.108.40.206 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 220.127.116.11 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 18.104.22.168 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