this type of principal cannot be impersonated, or youdo not have permission

Symptoms: GGSCI> delete trandata dbo.* 2020-12-08 11:53:54 WARNING OGG-00782 Error in changing transaction logging for table: dbo.tab. 2020-12-08 11:53:54 ERROR OGG-05345 Failed to disable change data capture for table ‘dbo.tab in the database ‘tstdb’. SQL error: 15517: [Microsoft][ SQL Server Native Client 11.0][SQL Server]Cannot execute as the database principal because the principal “cdc” does not […]

ALLOWOUTPUTDIR – Fix OGG-25127 XXXX not in any allowed output directories.

Symptoms: Pump report: 2020-11-20 19:05:58 ERROR OGG-25127 Received an error reply requesting a graceful shutdown. (Reply received is ‘GSOutput file /u01/app/ogg/dirdat/target/TT000000 is not in any allowed output directories.’.). Cause: With this parameter, we can authorize GoldenGate to use a different location than its home to store trail files. If you need different directories for your […]

OGGMA: Create distribution path via adminclient commands

ADD DISTPATH PUMP01 SOURCE trail://127.0.0.1:5100/services/v2/sources?trail=/source/SS TARGET wss://<targetIP>:6100/services/v2/targets?trail=/target/TT ALTER DISTPATH PUMP01 OPTIONS AUTORESTART RETRIES 10 delay 2 ALTER DISTPATH PUMP01 TARGET SIZEMB 200 ALTER DISTPATH PUMP01 TARGET SEQLEN 9 ALTER DISTPATH PUMP01 OPTIONS EOFDELAY 100

Setting , Resetting/Unsetting Database Parameters

https://coskan.wordpress.com/2007/03/07/setting-or-resetting-unsetting-parameters/  https://community.oracle.com/tech/developers/discussion/4027755/need-to-change-hidden-parameter-to-its-default-value https://community.oracle.com/mosc/discussion/3774329/11-2-0-3-many-hidden-parameters-in-init-ora You can query the documented parameters with the query below select name,value,isdefault,isses_modifiable,issys_modifiable, isinstance_modifiable,isdeprecated, from v$parameter You can query the list of undocumented parameters with the script mentioned before “how to view list of hidden parameters” Also you can query v$parameter2 as the same way you query the v$parameter view to view the session specific parameter values. […]

Enabling supplemental log data

Enabling supplemental log data The following steps check whether supplemental log data is enabled and, if not, enable it. Enter the following command: select supplemental_log_data_min, supplemental_log_data_pk from v$database; If the command returns YES or IMPLICIT, supplemental log data is already enabled. For example, SUPPLEME SUP ——– — YES NO indicates that supplemental log data is […]

North Africa Timezone changes around Ramadan

North Africa Timezone changes around Ramadan Symptom: North Africa clock changes around Ramadan. e.g., Morocco, that is included in DSTv34 which is not included in the current Oracle Database version ( 12.2 and 12.1 ) Oracle Database Cloud Schema Service – Version N/A and later: Updated DST Transitions and New Time Zones in Oracle RDBMS […]

Exception Code: OGG-01232 (DISTPATH01) cased by Network Issue:

Exception Code: OGG-01232 (DISTPATH01) cased by Network Issue: Symptom: 2018-09-17T22:50:06.996+0000 ERROR| SSL readBuffer error: 113. (DISTPATH01) 2018-09-17T22:50:06.996+0000 ERROR| Secure Comm Error : SSL IO error (28862). (DISTPATH01) 2018-09-17T22:50:06.996+0000 ERROR| Secure Comm Error : SSL IO error (28862). (DISTPATH01) 2018-09-17T22:50:07.233+0000 ERROR| Exception Code: OGG-01232 (DISTPATH01) 2018-09-17T22:50:07.233+0000 ERROR| Exception Message: Receive TCP params error: TCP/IP error 10351 […]

OGG-10351 Certificate validation error: Unacceptable certificate from in OGGMA 19.1

OGG-10351 Certificate validation error: Unacceptable certificate from <IP> in OGGMA 19.1 Symptom: 2020-10-07T13:50:40.095+0000 INFO | Cipher installed: 0x003d – ‘TLS_RSA_WITH_AES_256_CBC_SHA256’. (DISTPATH01) 2020-10-07T13:50:40.095+0000 INFO | Cipher installed: 0x009d – ‘TLS_RSA_WITH_AES_256_GCM_SHA384’. (DISTPATH01) 2020-10-07T13:50:40.106+0000 INFO | Using configured client REQUIRED authentication mode ‘client_server’ -> AuthenticateClient (nzosEstablishTrustInClient). (DISTPATH01) 2020-10-07T13:50:40.107+0000 INFO | Using configured server authentication mode: ‘client_server’ -> kAuthenticateServer […]