Applying – Patch 21352646: DATABASE SECURITY PATCH UPDATE 11.2.0.4.0 (CPUOCT2015)

So we have already discussed in our previous posts how to download this patch along with OPatch utility to apply this patch. In this post we are going to discuss how to apply this patch: Step 1: Go to patch directory and take out README.html file to your desktop, to do that we can useContinue reading “Applying – Patch 21352646: DATABASE SECURITY PATCH UPDATE 11.2.0.4.0 (CPUOCT2015)”

How to download latest CPU/PSU Patches

As we are aware of that Oracle releases patches every quarter ( Jan, April, July and Oct ), however many does not know how to get these patches and apply them on our Database or GRID etc. So this post is to help those guys, now go to http://www.google.com and simple search “cpu patch OctContinue reading “How to download latest CPU/PSU Patches”

How to Download and Configure Latest OPatch Utility to apply CPU/PSU Patches

This post is to describe how to get latest opatch utility to apply patches on Oracle Database or GRID Home. Why do we need latest one – Oracle Recommends to use that latest one so that there will not be any backward compatibility issue with OPatch and CPU/PSU patches (however i never got that). MakeContinue reading “How to Download and Configure Latest OPatch Utility to apply CPU/PSU Patches”

How to Backup and Restore Database which is being Configured in ASM

Here in this Post – i have installed and configured – 11gR2 GRID and Database Software (11.2.0.3) and have running TESTDB1 instance. We have 1 Database TESTDB1 which is there in ASM, we will find out the status and information about – Data Files, Control Files and Redo Log Files before we start our processContinue reading “How to Backup and Restore Database which is being Configured in ASM”

Oracle Database 11.2.0.3 Installation on ASM – Part 7

In this post we will be discussing over Database Installation on ASM (which is discussed in my previous posts – follow my old posts for ASM Disk Groups and other related information). Note: Before we start installing, we must complete all our perquisites for sure. Go to the the location where oracle database software hasContinue reading “Oracle Database 11.2.0.3 Installation on ASM – Part 7”

Grid Infrastructure 11.2.0.3 Software Installation – Part 6

This is the post being followed by my previous posts for ASM and ASM Disk Groups, all perquisites has been performed already, please follow my previous post for the steps. This will contain step by step per GUI perspective: Execute the runInstaller from the Grid Software: Skip Software updates. As we are planning to getContinue reading “Grid Infrastructure 11.2.0.3 Software Installation – Part 6”

Creating Disk Groups Using Oracle ASM Libraries – Part 5

Configuring and load the ASM kernel module (as the “root” user): # /usr/sbin/oracleasm configure -i It will ask for User and Group who will be managing Oracle ASM Disk Groups. Load the oracleasm kernel module: Now in my previous Post i created the Disks for ASM Disk Groups (Getting Ready for ASM Disks in VMWare WorkstationContinue reading “Creating Disk Groups Using Oracle ASM Libraries – Part 5”

Prerequisite before we Create Disk Groups for ASM – Part 4

Before we start creating Disk Groups we have to work upon prerequisites. Creating recommended OS groups and user for Grid Infrastructure: # groupadd -g 501 oinstall # groupadd -g 502 dba # groupadd -g 503 oper # groupadd -g 504 asmadmin # groupadd -g 506 asmdba # groupadd -g 505 asmoper # useradd -m -uContinue reading “Prerequisite before we Create Disk Groups for ASM – Part 4”

Configuring Oracle ASM Library Software to create Disk Groups – Part 3

Now as a next step, we have to configure Oracle ASM library software which will be used to Create ASM Disks Groups. Now mount the Oracle Enterprise Linux 6.7 in your Virtual Machine. By default its is not mounted as below: To mount it go to VM and Click on Settings: Now go to CD/DVDContinue reading “Configuring Oracle ASM Library Software to create Disk Groups – Part 3”

Getting Ready for ASM Disks in VMWare Workstation – Part 2

Now we have created 3 Disks in our VMWare Workstation. We will be partitioning those disks for ASM. Now check in /dev, you will find out 3 new devices /dev/sdc, /dev/sdd, /dev/sde. There are other two disks available /dev/sda (/dev/sda1,/dev/sda2) and /dev/sdb (/dev/sdb1) which is being used for OS. Now partition all 3 devices oneContinue reading “Getting Ready for ASM Disks in VMWare Workstation – Part 2”