When trying to add PDB as a dSource: Cannot sync pluggable database because multitenant container database "DBNAME" sync failed.

  • 0
  • 1
  • Problem
  • Updated 11 months ago
  • In Progress
I hope someone can help..
I am Unable to add a PDB as a dSource in the GUI.
the below is the output from the error message.

DBNAME is not the actual name, I have replaced that.. 

Run SnapSync for database "DBNAME".
Cannot sync pluggable database because multitenant container database "DBNAME" sync failed.
Correct the container database sync error and try to sync the pluggable database again.



Run SnapSync for database "DBNAME".


Block has invalid file index: 0.
Validate backup files with backup utility.

I have enabled BCC, the db is 12.2.
the engine is 4.3.3, but the old free trial (so limited to 30GB and 1vCPU etc).

Is there something blatantly obvious I need to check to get this working please?

Kind Regards,
Gary
Photo of Gary Morley

Gary Morley

  • 122 Points 100 badge 2x thumb
  • bemused..

Posted 11 months ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Can you generate some activity on that DB and then try again? Everytime I have seen that in the past, it was because someone had just enabled BCT, but no activity logs had been done afterwards (resulting in a block index of 0).
Photo of Felipe Hernandez

Felipe Hernandez

  • 464 Points 250 badge 2x thumb
What type of activity needs to be created? I'm having the same issue and since I don't have any experience in this, I would like to know what you are referring to.
Thanks in advance.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
anything that will create transaction logs, like inserting/updating records
Photo of Felipe Hernandez

Felipe Hernandez

  • 464 Points 250 badge 2x thumb
Ok, I've already added two lines in two different tables and I'm having the same error, here is what it is saying:

I think that the issue is with the root container and not with the pluggable D.B.

Thanks for the help.
(Edited)
Photo of Gary Morley

Gary Morley

  • 122 Points 100 badge 2x thumb
I will try to add something in the root container also. Fingers crossed!! :)
Photo of Gary Morley

Gary Morley

  • 122 Points 100 badge 2x thumb
I added a table in the CDB,  entered some rows of data, committed, switched log file.. tried again and the same is evident.

Same occurs when I do the same in the PDB.

Can you advise any further? 
Please excuse the massive screenshot.. not sure why its so large..


(Edited)
Photo of Gary Morley

Gary Morley

  • 122 Points 100 badge 2x thumb
Frustratingly I created a backup of the DB first, and then tried to add the dSource, and the same issue occurred also.
I will go and try with Oracle 12.1 as opposed to 12.2 and see if that makes any difference.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Hi Gary,

As per support documentation the 12cR2 isn't in the matrix yet

https://docs.delphix.com/docs/delphix-administration/oracle-environments-and-data-sources/oracle-sup...

You have to stay at max with 12.1 for testing PDB virtualization.

Regards,

Mouhssine
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
I just logged into our support desk (been away from my desk) and was able to validate that this happens with Oracle 12.2 and will be addressed when Oracle 12.2 is supported by Delphix (in the near future).
Photo of Gary Morley

Gary Morley

  • 122 Points 100 badge 2x thumb
Thank you kindly.
reverting test DB back to 12.1.
Best Regards,
Gary
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Hi Gary,

If you have any chance to get the latest version of the engine (5.1.7), you will be able to test 12.2 relase as it's supporte on this relase.

Regards,

Mouhssine
Photo of Gary Morley

Gary Morley

  • 122 Points 100 badge 2x thumb
I have no idea how to get the latest version as a test in a virtualbox environment.
I travel a lot whilst looking at functions / api's of different solutions for replication and provisioning. I can not have a cloud based test lab for this very reason. 
Is there a VBOX version of engine v5 available which I can legally use for testing purposes?