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

Use Oracle date function to implement alert in shell script

  1         Practice: calculate diff of DB time column in shell script 1.1        Practice: check_diff_time.sh oracle@oraclevm01: /monitoring/bin  % : more check_diff_time.sh #!/bin/bash lag=$(sqlplus -s  TESTUSER/oracle@pstg <<END set pagesize 0 feedback off verify off heading off echo off; select ROUND(TO_NUMBER(cast(target_commit as date)-cast(source_commit as date))*24*60) as lag_time from TESTUSER.HEARTBEAT exit; END ) echo $lag   https://unix.stackexchange.com/questions/85180/assigning-the-output-of-a-sql-query-to-variable https://stackoverflow.com/questions/17774405/bash-sql-query-outputs-to-variable […]

OSWatcher via MobaXterm

1. Using MobaXterm_Portable_V10.2: https://mobaxterm.mobatek.net/download-home-edition.html oraclevm01 % sudo su – root root@oraclevm01:/root % xhost + MobaXterm X11 proxy: Unsupported authorisation protocol xhost: unable to open display “localhost:10.0” root@oraclevm01:/root % exit logout oraclevm01 % xhost + access control disabled, clients can connect from any host oraclevm01 % 2. produce report oraclevm01$ cd /opt/app/oracle/admin/OSWatch/oswbb/ oraclevm01$ ls analysis call_uptime.sh […]