My Oracle Support Banner

PDB Refresh Failing Without Connect To Clause In Dblink Creation (Doc ID 2897739.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Create refreshable PDB from dblink works,  but refreshing PDB fails.

DB link has been created without password. You want use a database link without "connect to c##operator identified by xxxx" as stated in Oracle documentation.

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-DATABASE-LINK.html#GUID-D966642A-B19E-449D-9968-1121AF06D793

 

Extract from doc:
------------------------------
user IDENTIFIED BY password

 

Using same dblink, within same session, refresh PDB fails


   SQL> ALTER PLUGGABLE DATABASE REFRESH_PDB REFRESH;
   ALTER PLUGGABLE DATABASE REFRESH_PDB REFRESH
   *
   ERROR at line 1:
   ORA-17627: ORA-01017: invalid username/password; logon denied

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.