Database Administration, Grid Infrastructure, Linux, node, Oracle, Patching, Single Instance

Upgrade Grid Infrastructure 12c To 19c Oracle

4 Comments
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail

The latest oracle version is oracle 19C . In the below article we will explain the steps for upgrading grid infrastructure to 19c from oracle 12c . The upgrade will be done in rolling mode.

Current configuration – >

No of nodes – 2 node
current version – 12.1.0.2
os platform – Linux
grid owner – oracle

Check software version :
oracle@node1~$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.2.0]

oracle@node2~$ crsctl query crs softwareversion
Oracle Clusterware version on node node1 is [12.1.0.2.0]

2. Download the software and unzip on your first … Read more

Patching

Oracle Database July 2017 OJVM Security Patch 26027162

907 Comments
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail



Applying July 2017 OJVM security patch 26027162 on orcl prod clusters

SECTION A:

1. PRE-CHECKS STEPS:
Ensure ORACLE_HOME is set correctly, and that the $PATH definition has the following executables: make, ar, ld and nm.
unzip -d <PATCH_TOP_DIR> p26027162_12102_<PLATFORM_NAME>.zip
cd /u03/setup/security_patch_Jul2017_DB/26027162

2. opatch prereq CheckConflictAgainstOHWithDetail -ph ./

2a. Stop goldengate

3. For an Oracle RAC environment, shut down database services on the node to be patched.

—R… Read more

Patching

PSU Kernel ACFS Security Patch

6,834 Comments
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail



All about July 2017 PSU  Red Hat Kernel upgrade ACFS patching Security Patch.

Will apply July 2017 PSU Kernel ACFS on our 2 nodes RAC cluster on RH 7.4, at the same time our SA (System Administrator) also suggested to upgrade the Linux Kernel from 327 to 693, latest Red Hat  (linked on 12/25/2017).

Operating System: Red Hat 7.4 – how to check operating system
OS Kernel: 3.10.0-327.36.3.el7.x86_64 #1 SMP (current)
OS Kernel: 3.10.0-693.5.2.el7.x86_64 #1 SMP (after upgrade)
Database: Oracle 12.1.0.2 – 12c – how to ch… Read more

Oracle, Patching

Patch ACFS

Leave a comment
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail



How to stop everything, already discussed here.

4. /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -prepatch (as root) – this failed
OR /u01/app/12.1.0.2/grid/crs/install/rootcrs.sh -unlock – this worked

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

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

7. /u01/app/12.1.0.2/grid/rdbms/install/rootadd_rdbms.sh (as root)

8. /u01/a… Read more

Patching

Oracle Patching Test Post

15 Comments
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail

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

Oracle, Patching

Oracle 12c PSU

431 Comments
Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail


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