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

Last updated on JULY 20, 2024

Applies to:

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

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