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    

change net.ipv4.tcp_keepalive

% : sysctl -p net.ipv6.conf.all.disable_ipv6 = 1 net.ipv4.tcp_syncookies = 1 net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.conf.all.accept_redirects = 0 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 15204352 kernel.shmmax = 62277025792 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 vm.nr_hugepages = […]

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

Fix: (oracle) are not allowed to use this program (crontab)

Symptoms: [oracle@oracle01 nmon]$ crontab -l You (oracle) are not allowed to use this program (crontab) See crontab(1) for more information Cause: it turns out that Mandriva doesn’t create default rules for crontab’s use by users. Instead, on a new install crontab is restricted to the root account. There are two files that control usage of […]