Synchronize Databases autobcpORAdp.pl script failing with ORA-39122 and ORA-39149 errors
Article ID: 217823
Updated On:
Products
CA Workload Automation AE - Scheduler (AutoSys)
Issue/Introduction
The autobcp from Second database to the First database using Oracle data pump (autobcpdp) we get the following errors
ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings
ORA-39149: cannot link privileged user to non-privileged user
Environment
Release : 12
Component : CA Workload Automation AE (AutoSys)
Resolution
The autobcpORAdp.pl script uses the Data Pump feature of Oracle to import data.
The schema owner aedbadmin user needs the following permissions
grant IMP_FULL_DATABASE to aedbadmin
grant EXP_FULL_DATABASE to aedbadmin
Additional Information
For more information please refer to the Oracle documentation.
https://docs.oracle.com/database/121/SUTIL/GUID-619809A6-1966-42D6-9ACC-A3E0ADC36523.htm#SUTIL927
Feedback
Yes
No
Powered by
