ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-01031: insufficient privileges

Cause:

Due to insufficient privilege to create pluggable database, this error may be triggered.

kIsH@STAX<>!oerr ora 17628
17628, 00000, “Oracle error %s returned by remote Oracle server”
// *Cause: Oracle server on the remote instance has returned an error.
// *Action: Look at remote instance alert log/trace file for more information
// and take appropriate action or contact Oracle Support Services
// for further assistance

kIsH@STAX<>!oerr ora 1031
01031, 00000, “insufficient privileges”
// *Cause: An attempt was made to perform a database operation without
// the necessary privileges.
// *Action: Ask your database administrator or designated security
// administrator to grant you the necessary privileges

kIsH@STAX<>create pluggable database pdbstx from pdbstx@relpdb relocate;
create pluggable database pdbstx from pdbstx@relpdb relocate
*
ERROR at line 1:
ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-01031: insufficient privileges

Solution:

Grant all the below privileges

kIsH@STAX<>grant create pluggable database,sysoper,create session to c##proxy container=all;

Grant succeeded.

Leave a Reply