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

Use OPatch to check Oracle GoldenGate version

Use OPatch to check Oracle GoldenGate version Recently on I was strolling the OTN message boards and came across a question about identifying the version of Oracle GoldenGate using OPatch. This was the second time I came across this question; with that I decided to take a look and see if Oracle GoldenGate information could […]

OGG-05258 Could not retrieve the current Change Data Capture settings for database testdb

Symptom: 2018-09-11 02:00:06 INFO OGG-05264 Opening DSN connection: testdb, Server: mssqlvm01, Database: testdb. 2018-09-11 02:00:06 WARNING OGG-05265 The SQL Agent on server mssqlvm01 is not running. SQL Server CDC requires that the SQL Agent be running to capture change records. Source Context : SourceModule : [ggmssqlcdcvam.mssqlcdctable] SourceID : [ggmssqlcdcvam/MSSqlCDCTable.cpp] SourceMethod : [mssqlcdcvam::MSSqlCDCJobSettings::ReportCDCCaptureJob] SourceLine : [668] […]

Test server connectivity via python open socket

1. Open socket via python in target vm [root@oraclevm02 ~]# python -m SimpleHTTPServer 7809 Serving HTTP on 0.0.0.0 port 7809 … 192.29.20.11 – – [11/Sep/2010 11:29:15] code 400, message Bad request syntax (‘\x03’) 192.29.20.11 – – [11/Sep/2010 11:29:15] “” 400 – 2. Telnet target:port [root@oraclevm01 ~]telnet oraclevm01 7809

Oracle GoldenGate(12.3, 19) Trail FORMAT RELEASE

1         Can a 12.3 GoldenGate replicat process consume trail files from GG 12.1? https://community.oracle.com/message/15055722#15055722 https://community.oracle.com/message/14426682#14426682   When source is ogg v12.3.x and target is ogg v12.1.x , you need to have the trail files written in the 12.1 format so that the ogg v12.1. replicat could consume the ogg v12.3.x trail file.So you need to […]

kfod.bin: No such file or directory

Symptom: oracle@oraclevm01: /home/oracle % : asmcmd /u01/app/oracle/product/12.1.0/db_1/bin/kfod: line 22: /home/oracle/%ORACLE_HOME%/bin/kfod.bin: No such file or directory Use of uninitialized value $clus_mode in scalar chomp at /u01/app/oracle/product/12.1.0/db_1/lib/asmcmdbase.pm line 5002. Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.1.0/db_1/lib/asmcmdbase.pm line 5030. Use of uninitialized value $clus_mode in string eq at /u01/app/oracle/product/12.1.0/db_1/lib/asmcmdbase.pm line 5079. Use of uninitialized value […]

error: RPC failed; curl 56 OpenSSL SSL_read: SSL_ERROR_SYSCALL, errno 10054

Symptom $ git push -u origin master Counting objects: 2082, done. Delta compression using up to 4 threads. Compressing objects: 100% (2055/2055), done. error: unable to rewind rpc post data – try increasing http.postBuffer error: RPC failed; curl 56 OpenSSL SSL_read: SSL_ERROR_SYSCALL, errno 10054 nexpectedlyremote end hung up uWriting objects:  79% (1645/2082), 5.45 MiB | […]

Issue: /etc/ssh/ssh_config: Bad configuration option: permitrootlogin

Issue: /etc/ssh/ssh_config: Bad configuration option: permitrootlogin Symptom: [devuser@linuxvm01 docker]$ ssh devuser@linuxvm02 /etc/ssh/ssh_config: line 26: Bad configuration option: permitrootlogin /etc/ssh/ssh_config: terminating, 1 bad configuration options Cause: To resolve this issue you have to commented out line 55 in /etc/ssh/ssh_config #PermitRootLogin yes PermitRootLogin is actually an option which is valid in the /etc/ssh/sshd_config file; not the ssh_config […]