|Syniti Data Replication, DBMoto
|Steps for working with TDE encrypted tables in Oracle 11 and 12
Starting from Oracle version 11g, TDE encrypted tables are supported with Syniti DR/DBMoto as long as the TDE tables are open and reachable.
For Syniti DR/DBMoto Oracle replications involving TDE ecncrypted tables, the open/close operations for the TDE wallet should be performed outside Syniti DR/DBMoto using the following commands:
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY password
The password is the password used to define the Oracle wallet.
ALTER SYSTEM SET ENCRYPTION WALLET CLOSE
Bear in mind that the open and close wallet operations are active throughout the database environment. If one session opens the wallet, another separate session will see it opened and vice-versa. Therefore, if using the wallet with Syniti DR/DBMoto, be sure to open and close it on an as needed basis.
- Set up replications.
- Open the wallet:
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "password"
- Run the Replication Agent/Data Replicator.
If the wallet is not open, you will get an error during the initial refresh saying that the wallet is not open.
- Subsequent mirroring operations work whether the wallet is open or closed. However, if the wallet is closed, replicated field values are encrypted.