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/

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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google