ORA-01940: cannot DROP a user that is currently logged in

Reference: http://www.dba-oracle.com/t_ora_01940_cannot_drop_user.htm ORA-01940: cannot DROP a user that is currently logged in Cause: An attempt was made to drop a user that was currently logged in. Action: Make sure the user is logged out, then re-execute the command.   The ORA-01940 can always be cured by bouncing the source and replicated instance.  First, double-check to ensure that […]

OGG 19.1 certification matrix

https://www.oracle.com/technetwork/middleware/ogg-19-1-0-0-0-cert-matrix-5491855.xls   Product Release Processor Type OS Version Oracle GoldenGate 19.1.0.0.200714+ Microsoft Windows x64 (64-bit) 2012 / 2012R2 / 2016 / 2019 Oracle GoldenGate 19.1.0.0.200414+ Microsoft Windows x64 (64-bit) 2012 / 2012R2 / 2016 / 2019 Oracle GoldenGate 19.1.0.0.200414+ Microsoft Windows x64 (64-bit) 2019    

Oracle 19C commands

ALTER PLUGGABLE DATABASE PDB01,PDB02 close immediate; ALTER PLUGGABLE DATABASE PDB01,PDB02 OPEN READ WRITE; SQL> col value format a60 SQL> select * from V$DIAG_INFO ; INST_ID NAME VALUE CON_ID ———- —————————— ———————————————————— ———- 1 Diag Enabled TRUE 0 1 ADR Base /u01/app/logs/oracle 0 1 ADR Home /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB 0 1 Diag Trace /u01/app/logs/oracle/diag/rdbms/CDB_a/CDB/trace 0 1 Diag Alert […]

Add new redo group and change size of redo

Add new redo group and change size of redo https://docs.oracle.com/database/121/OSTMG/GUID-42519F90-AB27-46A8-9E59-18393C56C375.htm#OSTMG13960 1. query SQL> Select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024,MEMBERS,STATUS from v$log; GROUP# THREAD# SEQUENCE# BYTES/1024/1024 MEMBERS STATUS ———- ———- ———- ————— ———- —————- 1 1 13937 100 2 ACTIVE 2 1 13938 100 2 ACTIVE 3 1 13939 100 2 CURRENT 4 1 13936 100 2 INACTIVE SQL> select […]

Query archive log:

Query archive log: SELECT TRUNC(COMPLETION_TIME) ARCHIVED_DATE, SUM(BLOCKS * BLOCK_SIZE) / 1024 / 1024 SIZE_IN_MB FROM V$ARCHIVED_LOG GROUP BY TRUNC(COMPLETION_TIME) ORDER BY 1; ARCHIVED_ SIZE_IN_MB ——— ———- 06-NOV-20 3423.69922 07-NOV-20 747.664063 08-DEC-20 25235.2773 alter session set nls_date_format = ‘YYYY-MM-DD HH24’; SELECT TRUNC(COMPLETION_TIME, ‘HH’) ARCHIVED_DATE_HOUR, SUM(BLOCKS * BLOCK_SIZE) / 1024 / 1024 SIZE_IN_MB FROM V$ARCHIVED_LOG GROUP BY […]

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