Start multiple OGGMA Service Manager and Deployment

Start multiple OGGMA Service Manager and Deployment start first ServiceManager and Deployment [oracle@linux01 19.1.0.0.4]$ export OGG_ETC_HOME=/u01/app/product/oggma/19.1.0.0.4/SVRMGR_US/etc [oracle@linux01 19.1.0.0.4]$ export OGG_VAR_HOME=/u01/app/product/oggma/19.1.0.0.4/SVRMGR_US/var [oracle@linux01 19.1.0.0.4]$ SVRMGR_EU/bin/startSM.sh [oracle@linux01 19.1.0.0.4]$ ps ux USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND oracle 12130 0.0 0.0 116856 3552 pts/2 S+ 12:34 0:00 -bash oracle 12271 0.0 0.0 116960 3604 […]

oracle-gateway-ora-00904-invalid-identifier-how-fixed-it

oracle-gateway-ora-00904-invalid-identifier-how-fixed-it 1. symptoms: SQL> select count(*) from dbo.tab01@dl_dg4mssqldb where pkey = 101; Error starting at line : 15 in command – select count(*) from dbo.tab01@dl_dg4mssqldb where pkey = 101 Error at Command Line : 15 Column : 61 Error report – SQL Error: ORA-00904: “pkey”: invalid identifier 00904. 00000 – “%s: invalid identifier” *Cause: *Action: […]

X11-forwarding : ? (disabled or not supported by server)

X11-forwarding : ? (disabled or not supported by server) Symptoms: +——————————————————————–+ ¦ • MobaXterm 20.3 • ¦ ¦ (SSH client, X-server and networking tools) ¦ ¦ ¦ ¦ ? SSH session to admin ¦ ¦ • SSH compression : ? ¦ ¦ • SSH-browser : ? ¦ ¦ • X11-forwarding : ? (disabled or not […]

OGG-02171 Error reading LCR from data source. Status 509, data source type TrailDataSource

Symptom: 2021-01-16 17:29:49 INFO OGG-01021 Command received from GGSCI: STATS. Source Context : SourceModule : [er.replicat.processloop] SourceID : [er/replicat/processloop.cpp] SourceMethod : [processReplicatLoop] SourceLine : [1108] ThreadBacktrace : [12] elements : [/ogg4bd/19.1.0.0.1/libgglog.so(CMessageContext::AddThreadContext())] : [/ogg4bd/19.1.0.0.1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int , …))] : [/ogg4bd/19.1.0.0.1/libgglog.so(_MSG_Int32_String(CSourceContext*, int, int, char const*, CM essageFactory::MessageDisposition))] : [/ogg4bd/19.1.0.0.1/replicat(ggs::er::ReplicatContext::processReplicatLoop())] : [/ogg4bd/19.1.0.0.1/replicat(ggs::er::ReplicatContext::run())] : [/ogg4bd/19.1.0.0.1/replicat()] : [/ogg4bd/19.1.0.0.1/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())] : [/ogg4bd/19.1.0.0.1/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::Multi […]

OGG-01061 Invalid CSN value length(0) from data source during recovery (DISTPATH01)

Symptom: 2020-01-18T14:26:41.120+0000 INFO | INFO OGG-05520 Oracle GoldenGate Distribution Server for Oracle: Input trail file encryption: AES256. (DISTPATH01) 2020-01-18T14:26:41.121+0000 ERROR| Exception Code: OGG-01061 (DISTPATH01) 2020-01-18T14:26:41.121+0000 ERROR| Exception Message: Invalid CSN value length(0) from data source during recovery (DISTPATH01) 2020-01-18T14:26:41.121+0000 ERROR| Exception, killing the path DISTPATH01 (DISTPATH01) 2020-01-18T14:26:41.474+0000 WARN | Path killed. (DISTPATH01) Solution: 1. Remove […]

OGG-08533 & OGG-02188 Oracle GoldenGate Distribution Server for Oracle:

Symptom: 2020-01-15T21:45:13.896+0000 INFO | INFO OGG-01052 Oracle GoldenGate Distribution Server for Oracle: No recovery is required for target file /trail/TT000000000, at RBA 0 (file not opened). (DISTPATH01) 2020-01-15T21:45:13.908+0000 INFO | INFO OGG-02243 Oracle GoldenGate Distribution Server for Oracle: Opened trail file /trail/target/TA000000110 at 2020-01-15 21:45:13.908222. (DISTPATH01) 2020-01-15T21:45:13.908+0000 INFO | INFO OGG-01478 Oracle GoldenGate Distribution Server […]

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