Note: Change -n ch-orcldb-s02 to -n ch-orcldb-s01 when doing node 1.
Note: This patch 20024405 is a no conflict on orcl stage as it is not installed on this cluster.
1. Applying GI PSU Jul2017 Patch 25901062 patch manually on orcl Stage cluster:
=============================== Manual Steps ==========================
— stop GG
. Stop GoldenGate if running on the server.
. as it’s a 2 nodes RAC cluster, we need to make sure (recommended) to identify from where GG is running:
ps -ef | grep mgr
. this’ll tell you, GG is runn… Read more
Red Hat 7.4 Kernel Upgrade
Oracle 12c – 2 nodes RAC Cluster Kernel Upgrade to 693 kernel
1) Upgrade kernel and supporting packages:
# yum install kernel-3.10.0-693.5.2.el7 kmod-oracleasm-2.0.8-19.el7 kmod-20-15.el7_4.4 kmod-libs-20-15.el7_4.4 kernel-headers-3.10.0-693.5.2.el7 kernel-tools-3.10.0-693.5.2.el7 kernel-tools-libs-3.10.0-693.5.2.el7 kexec-tools-2.0.14-17.2.el7_4
2) Upgrade Oracle… Read more
How to check/verify the current existing Operating System (Unix/Linux)
Open a terminal program (get to a command prompt) and type uname -a. This will give you your kernel version, but might not mention the distribution your running. To find out what distribution of linux your running (Ex. Ubuntu) try lsb_release -a or cat /etc/*release or cat /etc/issue* or cat /proc/version.
Ref: https://whatsmyos.com/… Read more
Real Application Testing – step by step
Source Oracle: 11204 (single instance)
Target Oracle: 12102 (2 nodes RAC cluster+pluggable db)
Need to decide/find the times, when would like to capture the load, it’s recommended to start small; 15 mins, 30 mins or max 1 hr
We did for couple of hours, not recommended, but not a bad idea, but should start small first and then proceed, if reports look good (6-11, 9-11, 14-16, 19-22)
Let’s assume our company peak time is 10 am – 11 am… Read more