8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multitenant : PDB Archive Files for Unplug and Plugin in Oracle Database 12c Release 2 (12.2)


nir said...

As of 12.2.0.1 the ".pdb" method doesn't work(DBCA does works).
My belief is that the engine treat "... unplug into 'pdb.xml'" exact as ".... unplug into 'pdb.pdb'"
Unplug to archive with DBCA and plug in command line also doesn't work.

Tim... said...

Hi.

It works fine for me. I would not expect the two methods to be interchangeable. Stick with just DBCA or Just command line.

Cheers

Tim...

nir said...

I tried to mix it up to check all options, I'm a command line guy.
Anyway I get ora-65018 on the create command, and when I specified file_name_convert I get ora-65005 on /u01/oradata/orcl122/system01.dbf

Tim... said...

Hi.

It sounds like you have a syntax issue. Does it work when you use OMF?

Cheers

Tim...

nir said...

No OMF.

I understood the issue. When the .pdb file local at the root db directory it won't work (I guess because some identical
filenames already exists). You'll need to put the .pdb in separate directory, like the directory of the new PDB.

Anonymous said...

Unfortunately this test does not work for me, either, as this fails: alter pluggable database unplug into '//.pdb';

ERROR at line 1:
ORA-65125: valid XML file name is required

Tim... said...

Hi.

This is a 12.2 feature, so you will to be on 12.2 or later for this to work.

This doesn't appear to be similar to other issues listed above, which are problems with paths. Yours looks like you are not running the correct version.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.