Impdp Migration Error: ORA-01919: role ‘PLUSTRACE’ does not exist

impdp Migration error reporting: ORA-01919: role ‘PLUSTRACE’ does not exist
Error Message:
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role ‘PLUSTRACE’ does not exist
Failing sql is:
GRANT “PLUSTRACE” TO “TEST1”
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role ‘PLUSTRACE’ does not exist
Failing sql is:
GRANT “PLUSTRACE” TO “TEST2”
Execute the script manually, find plustrce.sql on the server, and get it done with a single command
[email protected]>@/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/plustrce.sql
[email protected]>
[email protected]>drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role ‘PLUSTRACE’ does not exist

[email protected]>create role plustrace;
Role created.
[email protected]>
[email protected]>grant select on v_$sesstat to plustrace;
Grant succeeded.
[email protected]>grant select on v_$statname to plustrace;
Grant succeeded.
[email protected]>grant select on v_$mystat to plustrace;
Grant succeeded.
[email protected]>grant plustrace to dba with admin option;
Grant succeeded.
[email protected]>
[email protected]>set echo off
[email protected]>

Similar Posts: