Capture stopped: wallet not loaded (4220028)

Capture stopped: wallet not loaded

Capture stopped due to error

Event_log:

Capture stopped: Wallet is not loaded. Run sp_wallet to load the wallet

Oracle 11g wallet not loaded prior to enabling TDE

Run sp_wallet prior to enabling TDE when prompted by ora_setup to if wanting to enable replication of tables with TDE.

Note:

SharePlex uses the Transparent Data Encryption (TDE) Master Encryption Key to decrypt TDE-protected data that must be replicated.  SharePlex uses the Oracle wallet password to access the TDE Master Encryption Key. If the wallet opens successfully, Capture connects to the decryption module and processes the data. If the wallet does not open, Capture either stops due to wallet not loaded or remain in the initialization state until either the wallet is opened or the capture process is stopped.

Wallets must be reopened after an instance restart and can be closed to prevent access to encrypted columns.

The following Oracle commands open and close the wallet:

-- 10g version

ALTER SYSTEM SET ENCRYPTION WALLET OPEN AUTHENTICATED BY "myPassword";

-- 11g version ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "myPassword"; ALTER SYSTEM SET ENCRYPTION WALLET CLOSE;

To decrypt Transparent Data Encryption (TDE) from the redo log, the SharePlex Admin user must open the Oracle wallet with the wallet password. The Oracle wallet owner-user has read and write permissions for the file. To enable SharePlex to open the wallet, you can either grant read permission to the wallet file to the dba group, because the SharePlex Admin user is a member of that group or have the owner of the wallet start SharePlex.