Post process fails applying encrypted data and fails with error in the event_log.
Notice 2015-09-11 15:37:20.978191 4685 4 s:8 Poster: Table "OWNER"."TABLE_NAME", objid=356919 is disabled (posting from SOURCE, queue QUEUE, to TARGET) [module opo]
Notice 2015-09-11 15:37:22.767284 4685 4 s:5 Poster: ORA-28365: wallet is not open. (posting from SOURCE, queue QUEUE, to TARGET) [module osp]
Error 2015-09-11 15:37:22.770009 4685 4 s:5 Poster: que/seq = 5/ 2448386139 seqno/offset = 472412/44460384 Unexpected Oracle error: ORA-28365: wallet is not open. (object name: "OWNER"."TABLE_NAME") (posting from SOURCE, queue QUEUE, to TARGET) [module opo]
Post could get ORA-28365 for various reasons.
1. Wallet not open at the Database level.
2. Wallet not open manually after starting sp_cop.
1. Check if wallet is open at the Database level.
Query v$encryption_wallet from the Database for the current status of the wallet.
select * from v$encryption_wallet;
2. Make sure wallet is open manually after starting sp_cop.
(xxxxx) [/prod_dir/bin] $ ./sp_wallet xxxxxx
If password is greater the 16 digits, use -p option.
(xxxxx) [/prod_dir/bin] $ ./sp_wallet -p xxxxxxxxxxxxxxxxx
Wallet loaded into SharePlex
To check the status,
(xxxxx)[/prod_dir/bin] $ ./sp_wallet -s
Wallet is loaded in SharePlex
