_____________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment