Pluggable Database using Database Link Fail ORA-17627
I performed below steps on server ad05 and it has another node ad06 but I am doing all below steps on ad05:
alter session set container=lspdb6;
create user test identified by test;
GRANT ALL PRIVILEGES to test;
GRANT ALL PRIVILEGES to test;
grant DBA to test;
grant CREATE PLUGGABLE DATABASE to test;
conn test/test@lspdb6;
create table oracle123 (name varchar2(10));
insert into oracle123 (name) values ('123');
commit;
CONN / AS SYSDBA
ALTER PLUGGABLE DATABASE lspdb6 CLOSE immediate instances=all;
ALTER PLUGGABLE DATABASE lspdb6 OPEN READ ONLY;
EXIT;
sqlplus / as sys dba
DROP DATABASE LINK clone_link;
CREATE DATABASE LINK clone_link CONNECT TO test IDENTIFIED BY test USING 'LSPDB6';