OEM Agent is down


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

cd  <directory>

ls -lrt     – this’ll tell you the owner

$ find / -name emctl -print 2>/dev/null

/u01/app/agent/core/               &#… Read more



How to stop everything, already discussed here.

4. /u01/app/ -prepatch (as root) – this failed
OR /u01/app/ -unlock – this worked

5. opatch apply -oh /u01/app/ -local /u03/setup/26247490/26247490 (as grid)

6. opatch apply -oh /u02/app/oracle/product/ -local /u03/setup/26247490/26247490 (as oracle), Got warning.

7. /u01/app/ (as root)

8. /u01/app/ -patch … 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



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


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

Scroll Up