Consolidation multiple Oracle Database using TDE and Oracle Wallet

Rahul-Sharma

Hi experts,

Our setup is as below:

DB1: 11.2.0.1

DB2: 11.2.0.2

DB3: 12.1.0.2

DB4: 12.1.0.2

We have implemented DB2 and DB4 with TDE and using Oracle Wallet.

The new requirement is to consolidate all the 4 databases into a single instances with Different Schemas (DB1, DB2, DB3, DB4) respectively.

We are trying to evaluate impdp/expdp utility for the same.

My questions is how can achieve this. What would be the best approach.

How can we consolidate two databases using two different wallets.

Jason_(A_Non)

I'm assuming this new implementation of Oracle is with 12c or later. If so, why not use the preferred method of a CDB/PDB setup? That way each DB is independent of each other, and so you can have a wallet for DB2 with one set of encryption keys and another independent wallet for DB4 with its own set of encryption keys.

In other words, if they are independent now, why do you want/need to merge them into a single instance?