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