Tuesday, July 25, 2017

Oracle Patches Types

In Oracle, there are different types of patching available; there are several types of patches released by Oracle that could be applied to the software you are running. There are on-off patches to fix bugs, regularly released patches, and security patches. In the following I will explain about different types of patches that are available to be installed on your RDBMS software.

Saturday, July 15, 2017

Installing Oracle 12c Release 2 RAC on Linux 6 and Linux 7

This article explains how to install a 2 nodes Oracle 12c Release 2 Real Application Cluster (RAC) on Oracle Linux 6 and 7. I did this installation on Oracle Virtual Box by creating 2 virtual machines with shared storage. OS platform I used is Oracle Enterprise Linux 7, and Oracle GI and RDBMS version is 12.2. Same installation guide should work for Linux 6 also as there are only a couple of differences in the steps that I will explain during this installation. There will be no difference in installation steps if there are more than 2 nodes in the RAC setup.
Official document for 12c RAC installation can be found by clicking at the following link.
http://docs.oracle.com/database/122/RILIN/toc.htm

Friday, July 7, 2017

Running cluvfy (Cluster Verification Utility) during 12c R2 RAC installation


Following is the output of cluster verification utility that I executed during 12c R2 RAC installation. You can see 2 examples in the following. Example 1 demonstrated if you don’t have passwordless SSH connectivity configured for “grid” and “oracle” users, so you will need to execute this from each node one by one. Following output is from one node only.

Monday, July 3, 2017

Creating Oracle Database using DBCA in 12c R2

Database Configuration Assistant (dbca) is an Oracle provided tool to create a new database. In this document I would explain how to create a new 12cR1 database using dbca. For database creation steps for Oracle 12cR1, follow this document. Steps and screens are almost same for other Oracle database versions and different OS platforms.