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
PRIMARY-SYS@testdb>@/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/plustrce.sql
PRIMARY-SYS@testdb>
PRIMARY-SYS@testdb>drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role ‘PLUSTRACE’ does not exist
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
PRIMARY-SYS@testdb>@/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/plustrce.sql
PRIMARY-SYS@testdb>
PRIMARY-SYS@testdb>drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role ‘PLUSTRACE’ does not exist
PRIMARY-SYS@testdb>create role plustrace;
Role created.
PRIMARY-SYS@testdb>
PRIMARY-SYS@testdb>grant select on v_$sesstat to plustrace;
Grant succeeded.
PRIMARY-SYS@testdb>grant select on v_$statname to plustrace;
Grant succeeded.
PRIMARY-SYS@testdb>grant select on v_$mystat to plustrace;
Grant succeeded.
PRIMARY-SYS@testdb>grant plustrace to dba with admin option;
Grant succeeded.
PRIMARY-SYS@testdb>
PRIMARY-SYS@testdb>set echo off
PRIMARY-SYS@testdb>
Similar Posts:
- mysql 1449 The user specified as a definer does not exist
- SQL statements generated by SQL compare
- ORA-00980 synonym translation is no longer valid
- mongodb not authorized on admin to execute command [version 3.2.18]
- [Solved] MySQL ERROR 1062 (23000): Duplicate entry ‘0’ for key ‘PRIMARY’
- [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist
- mysql: [Err] 1075 – Incorrect table definition; there can be only one auto column and it must be d…
- Error occurred when using java to connect mongodb: command failed with error 18 (authentication failed): “authentication failed.”
- [How to Solve] psql: FATAL: role “postgres” does not exist
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’