Multiple Standby Databases Dataguard Oracle

We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases.  The most important part is to consider the dataguard parameters, the rest is a normal dataguard creation. The important parameters are as below : db_file_name_convert log_archive_config log_archive_dest_1 log_archive_dest_2 log_archive_dest_3 LOG_ARCHIVE_DEST_STATE_1 LOG_ARCHIVE_DEST_STATE_2 LOG_ARCHIVE_DEST_STATE_3 log_file_name_convert remote_login_passwordfile STANDBY_FILE_MANAGEMENT fal_client fal_server … Continue reading Multiple Standby Databases Dataguard Oracle

OPatch for 11gR2(11.2.0.3) RAC Database+Grid on Sparc 64-Bit Solaris10

1. Install Latest OPatch clients from support.oracle.com - As Grid User -- unzip p6880880_112000_SOLARIS64.zip -d $ORACLE_HOME ##Replace All - As Oracle User -- unzip p6880880_112000_SOLARIS64.zip -d $ORACLE_HOME ##Replace All   2. Set PATH variable for OPatch for both Grid and Oracle user profiles --oracle-- vi .profile PATH=/oracle/app/oracle/product/11.2.0/dbhome_1/bin:/oracle/app/oracle/product/11.2.0/dbhome_1/OPatch:$PATH   --grid-- vi .profile PATH=/grid/app/11.2.0/grid/bin:/grid/app/11.2.0/grid/OPatch/:$PATH   3. Validate … Continue reading OPatch for 11gR2(11.2.0.3) RAC Database+Grid on Sparc 64-Bit Solaris10

Create Virtual Interface Solaris 10

Ocassionally you need to create a quick one node RAC setup for testing and one of the requirements is a private virtual interface. Virtual interfaces allow a single ethernet interface to listen on additional IP addresses. You can quickly do it in Solaris 10 so that the grid infrastructure setup can see the private virtual … Continue reading Create Virtual Interface Solaris 10

Setting up user profiles for Grid and Oracle user : Oracle RAC 11gR2 on Solaris 10

Below is the Solaris user profiles for "grid" and "oracle" user. If you have followed Oracles official documentation for installation ORacle Rac 11gR2. It is best practice to install Oracle clusterware under grid user and oracle database with Oracle user. It takes a little time to get used to this setup specially for RAC users … Continue reading Setting up user profiles for Grid and Oracle user : Oracle RAC 11gR2 on Solaris 10

Installing 11gR2 Real Application Clusters on Oracle Enterprise Linux 4 x86-64 (64 bit)

Installing Oracle Grid Infrastrcture This document provides a step by step guide to, installing Oracle 11gR2 Real Application clusters on Oracle Enterprise Linux 4, x86-64 (64 Bit). Keep in mind, this is a test installation and hence does not follow some of the best practices for installing oracle real application clusters (eg: use a separate … Continue reading Installing 11gR2 Real Application Clusters on Oracle Enterprise Linux 4 x86-64 (64 bit)