Ameer Khan

Installing Oracle 19.1.0.0.4 GoldenGate on Linux 7 Step 1:- unzip the software[oracle@oel7 u01]$ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip[oracle@oel7 u01]$ ls -ltrtotal 543540-rw-r–r– 1 oracle oinstall      1413 May 29  2019 OGG-19.1.0.0-README.txtdrwxr-xr-x 3 oracle oinstall        19 Oct 18  2019 fbo_ggs_Linux_x64_shiphome-rw-r–r– 1 oracle oinstall    332523 Oct 21  2019 OGG_WinUnix_Rel_Notes_19.1.0.0.4.pdf-rw-r–r– 1 oracle oinstall 556240981 May 11… Continue Reading

How to apply RUR Patch in Dataguard Environment in 19c Applying RUR(Release Update Revision) Patch in a dataguard (Physical Standby) environment. Here is a brief explanation on how to apply RUR (Release Update Revision) in a dataguard environment Here I will be  applying RUR 19.5.1.0 on the Primary and standby databases. Primary database Server :… Continue Reading

How To Clone A Pluggable Database from a Existing PDB Step 1. Put PDB in read only mode , which would be cloned. SQL> show pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ———- —————————— ———- ———-          2 PDB$SEED     … Continue Reading

Problem statement :- standby database goes out of sync as the archive logs are missing from primary site. Environment: Primary: Primary database node     : primary.soumya.com Database name              : orclcdb Primary DB UNIQUE NAME     : orclcdb Primary database instances : orclcdb DB Version: 19.0.0  Standby: Standby database node … Continue Reading

In primary DATABASE:- Primary DB:- orclcdb Standby DB:- orclstd oracle@primary flashback]$ dgmgrl sys/admin123#@orclcdb DGMGRL for Linux: Release 19.0.0.0.0 – Production on Mon Apr 13 19:05:31 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Welcome to DGMGRL, type “help” for information. Connected to “orclcdb” Connected as SYSDBA. DGMGRL> CREATE CONFIGURATION… Continue Reading

OS Version:-Oracle Linux 7 Oracle version:- Oracle Database 19c Enterprise Edition Release 19.3.0 64bit System Configuration primary server:- edit the following files cat /etc/hosts [oracle@primary ~]$ cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.0.110   primary.soumya.com      primary 192.168.0.120   standby.soumya.com      standby Standby Server:- edit the… Continue Reading

Oracle Database 19c Installation On Oracle Linux 7  Oracle Database 19c (19.3) Software (64-bit)  Add hosts entry in hosts file [root@oel7 ~]# cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.118.128 oel7.soumya.com oel7 Install the “oracle-database-preinstall-19c” package to perform all the prerequisite setup # yum install -y oracle-database-preinstall-19c The following packages are required… Continue Reading

Login to 1st exadata cell  node:- [root@itscceladm01 ~]# cellcliCellCLI: Release 18.1.9.0.0 – Production on Fri Jan 31 17:17:50 IST 2020 Copyright (c) 2007, 2016, Oracle and/or its affiliates. All rights reserved. CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome         DATAC1_CD_00_itscceladm01       ONLINE  Yes         DATAC1_CD_01_itscceladm01       ONLINE  Yes       … Continue Reading

Stop oms . Do not include ‘-all‘ as the Admin Server needs to be up during this operation. cd /u01/app/oracle/product/MiddlewareR5/oms/bin/ [oracle@em bin]$ ./emctl stop oms Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. Stopping WebTier… WebTier Successfully Stopped Stopping Oracle Management Server… Oracle Management Server Successfully Stopped Oracle Management Server… Continue Reading

Oracle OSWatcher Black Box (OSWbb) collects and archives operating system and network metrics that you can use todiagnose performance issues. OSWbb operates as a set of background processes on the server and gathers data on aregular basis, invoking such Unix utilities as vmstat, netstat, iostat, and top. 1. Download oswatcher from oracle support. OSWatcher (Doc… Continue Reading