How to Clone PDB with TDEby Ed ChenJanuary 5, 2022April 30, 2023Before entering our topic, I assumed that you have already know how to clone a PDB to another CDB. In this post, I will show… Read More »How to Clone PDB with TDE
How to Resolve ORA-46627: keystore password mismatchby Ed ChenDecember 21, 2021May 18, 2022ORA-46627 Tried to clone a pluggable database (PDB) with TDE from another PDB, but it failed with ORA-46627. SQL> create pluggable database ORCLPDB2 from ORCLPDB… Read More »How to Resolve ORA-46627: keystore password mismatch
How to Resolve ORA-46697: Keystore password requiredby Ed ChenDecember 20, 2021May 18, 2022ORA-46697 Create Pluggable Database Cloning Local PDB Tried to clone a Pluggable Database (PDB) in the same Container Database (CDB), but it failed with ORA-46697.… Read More »How to Resolve ORA-46697: Keystore password required
How to Resolve ORA-65016: FILE_NAME_CONVERTby Ed ChenSeptember 3, 2021November 12, 2021ORA-65016 and ORA-65180 Tried to clone a remote PDB with the same name and path and got ORA-65016 like this. SQL> create pluggable database ORCLPDB… Read More »How to Resolve ORA-65016: FILE_NAME_CONVERT
How to Resolve ORA-17629: Cannot connect to the remote database serverby Ed ChenSeptember 1, 2021May 8, 2023ORA-17629 ORA-17629 means that it cannot connect to the remote database because of some underlying errors occurred, most likely, there're some error returned. In the… Read More »How to Resolve ORA-17629: Cannot connect to the remote database server
How to Create Pluggable Database (PDB)by Ed ChenMay 29, 2021July 19, 2023There're several ways that can create a PDB. Create a PDB by using SQL*Plus Create a PDB by using DBCA The last 2 ways are… Read More »How to Create Pluggable Database (PDB)
How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle serverby Ed ChenNovember 16, 2020November 11, 20234 CommentsORA-17628 In some situations, you might see errors like the following when cloning a remote pluggable database (PDB): SQL> create pluggable database finance_pdb from finanpdb@link_to_test1… Read More »How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server
How to Resolve ORA-00059: maximum number of DB_FILES exceededby Ed ChenNovember 2, 2019May 15, 2023ORA-00059 Found ORA-00059 when adding a new datafile to an existing tablespace, creating a new tablespace or a pluggable database, it told us that the… Read More »How to Resolve ORA-00059: maximum number of DB_FILES exceeded
How to Resolve ORA-19505: failed to identify fileby Ed ChenMarch 11, 2017November 5, 20212 CommentsORA-19505 There're two error patterns of ORA-19505 in this post. Cloning a PDB Duplicating a Database 1. Cloning a PDB Tried to clone a Pluggable… Read More »How to Resolve ORA-19505: failed to identify file
How to Resolve ORA-65005: missing or invalid file name pattern for fileby Ed ChenOctober 19, 2015March 31, 2021ORA-65005 ORA-65005 means that the pattern of file name conversion you specified in CREATE PLUGGABLE DATABASE statement does not match the data files. SQL> create… Read More »How to Resolve ORA-65005: missing or invalid file name pattern for file