Oracle RAC How-To Series – Tutorial 1 How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox (Part 1). Download the note (for members only…) Download the note …. Please follow and like us:
Upgrade Oracle 12.1.0.2 Grid Infrastructure to 18c Download the 18c Grid Infrastructure software (18.3) https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html Prerequisites Apply the patch 21255373 to the 12.1.0.2 Grid Infrastructure software home Edit the /etc/security/limits.conf file and add the lines: oracle soft stack 10240 grid soft stack 10240 Notes Need to have at least 10 GB of […]
I recently performed an upgrade of an Oracle 12c Release 1 (12.1.0.2) Grid Infrastructure environment hosted on a RAC Virtual Box environment on my laptop to the latest release 12c Release 2 12.2.0.1.0 version. Here are some points to be noted related to the upgrade process: The Grid Infrastructure 12c Release 2 (12.2) software is […]
Let us take a look at the process of configuring Goldengate 12c to work in an Oracle 12c Grid Infrastructure RAC or Exadata environment using DBFS on Linux x86-64. Simply put the Oracle Database File System (DBFS) is a standard file system interface on top of files and directories that are stored in database tables […]
This note details the process of applying the Grid Infrastructure 12.1.0.2 PSU Jan 2015 patch on a two node Linux x86-64 RAC cluster. The patch required is 19954978 and this in turn will apply the 19769480 patch to the database home as well. The patch is rolling applicable and so involves minimal downtime. Before applying […]
I have recently tested the upgrade to RAC Grid Infrastructure 12.1.0.2 on my test RAC Oracle Virtualbox Linux 6.5 x86-64 environment. The upgrade went very smoothly but we have to take a few things into account – some things have changed in 12.1.0.2 as compared to Grid Infrastructure 12.1.0.1. The most notable change regards the […]
Scenario: 1) We want to restore the production database which is running on two-node RAC environment in a test non-RAC environment 2) We want to restore the backup residing on ASM disk groups in a non-ASM file system. Note: The production database orcl has two instances named orcl1 and orcl2. The database will be restored […]
Here are some notes I have prepared when I did an upgrade of a 11GR2 Two-Node RAC Grid Infrastructure from 11.2.0.2 to 11.2.0.3 on a Linux 64 bit test environment. The 11.2.0.3 is an out of place upgrade. So we need to install the 11.2.0.3 software in seperate location from the existing 11.2.0.x […]
This note outlines the procedure to clone or refresh an Oracle Real Application Clusters database using the RMAN Duplicate Database feature. In case of a RAC to RAC clone, with RMAN Duplicate we first create a target or duplicate single instance database and then convert the single instance database to a RAC database. While the […]
This note illustrates how we can set up an Orace 11g Release 2 Real Application Clusters environment for test purposes using the Oracle VM templates which are currently available in under 30 minutes! The templates are available from the Oracle E-Delivery web site and are available in both OEL 32bit Linux as well as 64bit […]
In 11g Release 2, we now have to place the Voting Disk and Cluster Registry files on ASM disks and we do not have the option of placing them on OCFS or raw devices as in the case of previous versions. When you run the root.sh script as part of the 11gR2 RAC installation, it […]
In Oracle 11g, we can now do rolling upgrades of the ASM instanaces in a RAC cluster configuration. In this example shown below, one of the ASM instances is being upgraded to 11.1.0.7 while the other instance is still running on version 11.1.0.6. While the ASM software is being upgraded, client connections to the RAC […]
The following screenshots are taken from a RAC Clusterware upgrade from 11.1.0.6 to 11.1.0.7 on AIX 64 bit platform. We encountered an issue related to Bug 8925669: ROOT111.SH 0509-150 DEPENDENT MODULE LIBTTSH11.SO COULD NOT BE LOADED. I have provided the workaround we used in this case and which did work for us. The last screen […]
Let us have a look at the installation screenshots of 11g Release 2 on a Red Hat Linux platform. Currently the 11g R2 software has only been released for the Linux platform with release dates for other platforms like Solaris and AIX set for sometime end October to mid November. There are quite a few […]
The following are some of the new ASM related features introduced in 11g R2: In Oracle 11g Release 2, ASM and the Oracle Clusterware are now installed in a common home called the Grid Infrastructure Home. The clusterware files like the Voting Disk and the Cluster Registry can no longer be installed on raw devices. […]
While creating the ASM instance using DBCA in an 11g RAC environment on 64 bit AIX 5L, we got the ORA-27504 error along with others as shown below. The problem was caused by incorrect UDP and TCP packet settings and is documented in Metalink note 300956.1 As root, the following changes need to be made […]
While relinking the Oracle 11g RAC software on 64 bit AIX platform, we got the error as shown below: Looking at the installation log we found the following lines: ld: 0706-006 Cannot find or open library file: -l ha_gs_r ld:open(): A file or directory in the path name does not exist. ld: 0706-006 Cannot find […]
This example illustrates Transparent Application Failover (TAF) in a two node AIX 11g RAC configuration. The database name is racdb and the two instances are racdb1 and racdb2. Node 1 – middba1 which hosts instance racdb1. Node2 – middba2 which hosts instance racdb2 We have defined two services racdb1 and racdb2. For service racdb1 the […]
While installing the 11g Clusterware on 64 bit AIX 5L, we encountered the CRS-0184 error while running the root.sh on the second node. The error was … Cluster Synchronization Services is active on all the nodes. Waiting for the Oracle CRSD and EVMD to start Oracle CRS stack installed and running under init(1M) Running vipca(silent) for […]
