Refreshable PDB and ORA-17627: ORA-12578: TNS:wallet open failed Mustafa, 2023-11-14 Hi, Here is a quick note about refreshable pdbs. I have 19c (19.20) refreshable pdb. Source PDB and refreshable PDB are on different servers and this system is working for quite some time. Today, suddenly I started to get errors on pdb refresh: Oracle PL/SQL Error report - ORA-17627: ORA-12578: TNS:wallet open failed ORA-17629: Cannot connect to the remote database server 17627. 00000 - "%s" *Cause: An error returned by OCI while sending/receiving message from remote instance *Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance 12345678 Error report -ORA-17627: ORA-12578: TNS:wallet open failedORA-17629: Cannot connect to the remote database server17627. 00000 - "%s"*Cause: An error returned by OCI while sending/receiving message from remote instance*Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance it is interesting because there is no TDE or any wallet to use. I couldn’t event think how to trace this. I tried manual refresh pdb but it raised the same error. then I tried to use dblink which I use to create refreshable pdb, via a simple query like “select * from dual@mydblink” and it worked! So, first I started to think that dblink is not a problem but at that moment, I get some notification messages from Source PDB which says there are invalid login attempts on the pdb. So, I decided to check the db link user on source pdb and db link user was in “EXPIRE(GRACE)” mode. So, I changed the password of db link and recreate it on cdb where refreshable pdb is on and it solves the issue. error wasn’t guided me much and when tried to google it, all results were about TDE. I hope this post helps you if you encounter this situation. wish you healthy, happy days. 19c
Hi Vitor, Thank you for sparing your time and write a comment, that make me really happy. glad to help. Reply