GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 28,365

Problem Description 

GoldenGate GGSCI Register or Unregister Extract failed with following error. 

2016-09-21 09:40:57 ERROR OGG-08221 Cannot register or unregister EXTRACT EXT_STS because of the following SQL error: OCI Error 28,365 

Solution Description 

Check your database TDE wallet is open or not. Open the TDE wallet using following command and try to register the extract.

SQL>  select wrl_type wallet,status,wrl_parameter wallet_location from v$encryption_wallet;

WALLET               STATUS         WALLET_LOCATION
-------------------- -------------- -------------------------------
FILE                 CLOSED         /etc/oracle/wallet/RAC/

advertisements

 

You can use any of these commands and try to register the extract.

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "xxxxxx";

ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN identified by "Xyzabc";                

keystore altered.

GGSCI (Node 1 as PCS_OWNER@KPMUAT1) 15> ADD EXTRACT EXT_STS, integrated TRANLOG, BEGIN NOW
register extract EXT_STS database
ADD EXTTRAIL ./dirdat/gt, EXTRACT EXT_STS MEGABYTES 500

EXTRACT (Integrated) added.