Docker Installation of Oracle Database 12c on Mac

I have been working with Virtual machines for quite a while, most of my testing and demo environments are on VirtualBox. The problem I’ve always faced is the storage and resources requirements to run multiple VMs.  Running VMs on a MAC works well, however we all know that MAC storage is a premium that not all of us have. I have always kept my VMs … Continue reading Docker Installation of Oracle Database 12c on Mac

GoldenGate – RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process.

1- One of the obsolete integrated extract was causing Rman not to delete expired archive logs. orcl:/u02/DBA/scripts ->./delete_arch.sh The Oracle base remains unchanged with value /u01/app/oracle Recovery Manager: Release 12.1.0.2.0 – Production on Fri Feb 9 15:25:15 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1450870477) RMAN> 2> 3> 4> 5> 6> using target database control … Continue reading GoldenGate – RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process.

Install Chrome on Oracle Linux 7 (REHL7)

Today I had it with Firefox on Linux and wanted to install Chrome, here are the steps I followed and it worked like a charm.     #sudo wget https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm # sudo yum -y install redhat-lsb libXScrnSaver # sudo yum -y localinstall google-chrome-stable_current_x86_64.rpm oratest1:/u01/deployment_ogg_test2 ->sudo wget https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm –2018-01-19 15:42:55– https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm Resolving dl.google.com (dl.google.com)… 172.217.8.174, 2607:f8b0:4009:813::200e Connecting to dl.google.com (dl.google.com)|172.217.8.174|:443… connected. HTTP request sent, awaiting response… … Continue reading Install Chrome on Oracle Linux 7 (REHL7)

GoldenGate numeric data validation with REGEXP

Here is a simple validation mapping to verify if the value in the trail file is numeric. I had to use this where the source was a varchar2 and the target was a numeric field. The requirement is if the value in the trail file is not numeric just add a “zero” in the field. MAP SOURCE.T1, TARGET TARGET.T1, & SQLEXEC (ID lookup_st, & QUERY … Continue reading GoldenGate numeric data validation with REGEXP