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

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

Cause:

kIsH@Xhydra<>create pluggable database PDBTSNT from PDBZX1@clone_link keystore identified by password standbys=none;
create pluggable database PDBTSNT from PDBZX1@clone_link keystore identified by password standbys=none
*
ERROR at line 1:
ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-01031: insufficient privileges

Action:

Grant “create pluggable database” in the source for the user connected over dblink

--Source 
kIsH@Xhydra<>grant create pluggable database to kish;

Grant succeeded.

--Target
kIsH@Xhydra<>create pluggable database PDBTSNT from PDBZX1@clone_link keystore identified by password standbys=none;

Pluggable database created.

Leave a Reply

Discover more from XscalibaL

Subscribe now to keep reading and get access to the full archive.

Continue reading