| Product: | Syniti Replicate (a.k.a Syniti Data Replication, DBMoto) |
| Version: | All |
| ID: | 3004 |
| Summary: | Steps for working with TDE encrypted tables in Oracle 11 and 12 |
Starting from Oracle version 11G, TDE encrypted tables are supported with Syniti Replicate as long as the TDE tables are open and reachable.
For Syniti Replicate Oracle replications involving TDE encrypted tables, the open/close operations for the TDE wallet should be performed outside Syniti Replicate 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 Replicate, be sure to open and close it on an as needed basis.
Steps:
- Set up replications.
- Open the wallet:
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "password"
- Run the Replication Agent.
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.