Oracle Enterprise Manager Agent is down
2 of Single Instance database OEM agent was down.
2 OEM agents are down for 2 databases: one prod & one dev
— login to the box
need to know the owner, who installed this oem agent, mostly it’s oracle, but in RAC, it’s owned by grid.
how to find oem agent installed location/directory:
find / -name emctl -print 2>/dev/null
ls -lrt – this’ll tell you the owner
$ find / -name emctl -print 2>/dev/null
/u01/app/agent/core/126.96.36.199.0/bin/emctl … Read more
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/app/126.96.36.199/grid/crs/install/rootcrs.sh -patch … Read more
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
How to check/verify Oracle Database Version/Release
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 running from which node, it’s good to connect to that … 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 OracleASM packages as required.
Versions should be:
oraclea… 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: http://whatsmyos.com/… Read more