Database Utilities (MOSC)

MOSC Banner

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center