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 […]

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

ORA-38706: Cannot turn on FLASHBACK DATABASE logging. Symptom: SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38707: Media recovery is not enabled. SQL> show parameter recovery NAME TYPE VALUE ———————————— ———– —————————— db_recovery_file_dest string +FLASH db_recovery_file_dest_size big integer 16G recovery_parallelism integer 0 […]

ORA-38774 while disable archive

ORA-38774 while disable archive Symptom: SQL> Alter database noarchivelog; Alter database noarchivelog * ERROR at line 1: ORA-38774: cannot disable media recovery – flashback database is enabled SQL> Select name from v$restore_point; no rows selected SQL> select name,flashback_on from v$database; NAME FLASHBACK_ON ——— —————— cdb01 YES Solution: SQL> alter database flashback off; SQL> select name,flashback_on […]

ORA-12514 caused by Archive log destination full in Oracle 19C:

ORA-12514 caused by Archive log destination full in Oracle 19C: Symptom: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [oracle@oraclevm01 dump]$ tnsping pdb01 Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclevm01)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = […]

ORA-12034: materialized view log on “TEST”.”tab01″ younger than last refresh

Symptoms: SQL> SELECT job, what mview_name, TO_CHAR (last_date, ‘mm/dd/yyyy hh24:mi:ss’) last_execution, TO_CHAR (next_date, ‘mm/dd/yyyy hh24:mi:ss’) next_execution, INTERVAL FROM dba_jobs WHERE what LIKE ‘dbms_refresh.refresh%’ ; JOB MVIEW_NAME LAST_EXECUTION NEXT_EXECUTION INTERVAL 207 dbms_refresh.refresh(‘”TEST”.”TST_REFRESH_GROUP”‘); 01/01/4000 00:00:00 trunc(add_months(sysdate,12)) ORA-12048: error encountered while refreshing materialized view “TEST”.”Test_MV” ORA-06512: at line 35 ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 3012 ORA-12034: materialized view log […]

Top errors in Oracle GoldenGate12c:

https://oraclexperto.blogspot.com/2018/08/top-7-errors-in-oracle-goldengate12c.html https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/setup.htm#GIORA367 https://www.vitalsofttech.com/enable_goldengate_replication-is-not-set-to-true/ OGG (https://oggvm01:9001 DEPLOY as SRCOGGCDB@CDB/CDB$ROOT) 7> register extract ext01 DATABASE CONTAINER (PDB01) 2020-10-07T15:54:23Z ERROR OGG-02058 The Oracle source database is not configured properly to support integrated capture. The following configuration error must be fixed: No minimum supplemental logging is enabled. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled […]

Different sizes of ASM disks in ASM diskgroup

Reference:  https://community.oracle.com/tech/apps-infra/discussion/4198843/different-sizes-of-asm-disks-in-asm-diskgroup https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94124 https://oracle-base.com/articles/10g/automatic-storage-management-10g With Oracle 11.2.0.4, asmca allows me to create a diskgroup with differently sized disks, whereas asmca 12.2.0.1 does not:       With 12.2.0.1, it is also not possible to add a disk with a different size to an already existing disk group.   What works though is to replace an […]

Distribution Path failed with ENCKEY and Filter rule

Distribution Path failed with ENCKEY and Filter rule Symptom: OGG MA12.3 2016-09-29T13:00:36.413+0000 ERROR| Exception Code: OGG-02271 (DISTPATH01) 2016-09-29T13:00:36.413+0000 ERROR| Exception Message: Decryption key is missing and record can not be filtered out. (DISTPATH01) 2016-09-29T13:00:36.413+0000 ERROR| Exception, killing the path DISTPATH01 (DISTPATH01) 2016-09-29T13:00:36.454+0000 WARN | Path killed. (DISTPATH01) Cause: Filter rule is using in distpath with […]