Upgrade Grid Infrastructure 12c To 19c Oracle

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

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

How to Configuration GRID/ASM for single instance using UDEV

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Configuration GRID/ASM for single instance using UDEV

UDEV Linux configuration:

What I’m preparing in the background is a RAC installation using two virtual machine running under VirtualBox. For this I have attached to my first virtual machine four fixed size of 1GB disks like this

 

To attach those disks in another virtual machine go to Virtual Media Manager and change their property to shareable like this

udev02

Once you start your guest OS you should see something:

[root@localhost ~]# fdisk -l
.
.
.
Disk /dev/sdb: 1073 MB, 1073741824 bytes, 2097152 sectors
Units = sectors of 1 * 512 = 5
Read more

How to Install Grid/ASM for Single Instance on Oracle cloud:

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Installation of  Grid/ASM for single instance on cloud:

First open the browser any browser and type oracle cloud.

And sign-in your Oracle cloud
And select the three-line bar beside Oracle cloud.

And Select the option of Bare metal and VM and Exa data

After selecting that the next step is select Create DB system
1. Select a compartment name which is you want to provide
Name your DB system which is you want to provide
Select an availability domain
Select a shape type which is virtual machine
Select a shape vm standard 2.2 2 Available Core Count, 1 Node Count which are basic if you want u can change

 … Read more

Installation of 18c oracle binaries and Database at same time

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

In this Article you will se how to install oracle 18c binaries as well as Database

Step 1 :
Disable firewall and selinux:
first check the status of firewalld status weather is active or not:

[root@localhost /]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-05-03 01:47:30 IST; 4h 12min ago
Docs: man:firewalld(1)
Main PID: 957 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─957 … Read more

How to Upgrade Oracle 11g & 12c

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Downloading  Oracle 11g & 12c Database software and create your 1st Oracle Database

Things to Do:

  • Make sure your laptop has minimum 8 GB of RAM (16 GB or more is recommended).
  • Downloads: 7-zip to unzip, Notepad++ for writing notes.
  • Register at OTN: https://www.oracle.com/technetwork/index.html – this is a must to download Oracle software.
  • We’ll be installing Oracle Enterprise Edition, NOT Standard Edition or any other editions :Download & Install Cygwin: https://cygwin.com/install.html (optio
Read more

Oracle Database July 2017 OJVM Security Patch 26027162

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail



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

PSU Kernel ACFS Security Patch

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail



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