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 188.8.131.52.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.
SQLcl has many new little tricks that can help us on a daily basis, below is an example how we can execute SQLcl command from SQL developer: Here is an info <table> Here is an DDL for the same table: ddl <table name> Continue reading Run SQLcl commands from SQL Developer
in 12c Oracle has introduced and new field in the v$event_name view called DISPLAY_NAME. After review the contents on more then 1800 events, I noticed the most display name were the same as the name with exception of a 19. Here are they: Continue reading 12c DISPLAY_NAME column in v$event_name view
Download Instant Client for macOS http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst Continue reading Install sqlplus instant client on macOS
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)… 184.108.40.206, 2607:f8b0:4009:813::200e Connecting to dl.google.com (dl.google.com)|220.127.116.11|:443… connected. HTTP request sent, awaiting response… … Continue reading Install Chrome on Oracle Linux 7 (REHL7)
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