How to stop everything, already discussed here.
4. /u01/app/188.8.131.52/grid/crs/install/rootcrs.pl -prepatch (as root) – this failed
OR /u01/app/184.108.40.206/grid/crs/install/rootcrs.sh -unlock – this worked
5. opatch apply -oh /u01/app/220.127.116.11/grid -local /u03/setup/26247490/26247490 (as grid)
6. opatch apply -oh /u02/app/oracle/product/18.104.22.168/db_1 -local /u03/setup/26247490/26247490 (as oracle), Got warning.
7. /u01/app/22.214.171.124/grid/rdbms/install/rootadd_rdbms.sh (as root)
8. /u01/a… Read more
Oracle Patching Test Post
Apparently we had reached a great height in the atmosphere, for the sky was a dead black, and the stars had ceased to twinkle. By the same illusion which lifts the horizon of the sea to the level of the spectator on a hillside, the sable cloud beneath was dished out, and the car seemed to float in the middle of an immense dark sphere, whose upper half was strewn with silver. Looking down into the dark gulf below, I could see a ruddy light streaming through a rift in the clouds.… Read more
2 ways, when you logged in to sqlplus:
After logging into the database, can query data dictionary:
… Read more
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
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