All posts by Brijesh
How to change Public VIP Address in 11gR2 RAC
Public VIP Address: An interface that can be used for communication with components external to Oracle RAC instances, such as Oracle Net and Virtual Internet Protocol (VIP) addresses. We can change VIP with any outage. We will change it node by node. Step 1: Check which service is running on current which VIP , we […]
Read MoreHow to change Cluster Interconnect Adapter IP Address in 11gR2 RAC
Cluster interconnect: It’s a private interface used for the cluster-ware to provide inter-instance or Cache Fusion communication. This is also called as private IP address. We can change it at any stage, it require full outage. Step 1: Determine private IP address [oracle@test1 ~]$ oifcfg getif eth0 192.168.1.0 global public eth1 10.0.0.0 global cluster_interconnect Step […]
Read MoreVoting disk and OCR management in 11gR2 RAC
OCR: It created at the time of Grid Installation. It’s store information to manage Oracle cluster-ware and it’s component such as RAC database, listener, VIP,Scan IP & Services. Minimum 1 and maximum 5 copy of OCR is possible. Voting Disk: It manage information about node membership. Each voting disk must be accessible by all nodes […]
Read MoreASM block corruption ORA-01115
At the time recovery in standby database if you see error (Version 11.2.0.2) ORA-01115: IO error reading block from file 201 (block # 11080) ORA-01110: data file 263: ‘+DATADG/datafile/indx_8m.655.665578’ ORA-15055: unable to connect to ASM instance ORA-00020: maximum number of processes (100) exceeded ORA-01115: corruption in asm based datafile of 11g database on a standby […]
Read MoreRHEL 6 certified with oracle
After a long time awaits now Oracle Database 11g R2 (11.2.0.2) and Oracle Fusion Middle ware 11g R1 has been certified on Red Hat Enterprise Linux 6 (RHEL6). But it will be available in market around end of June 2012 with the Red Hat Compatible Kernel. Reference:http://www.oracle.com/us/corporate/press/1563775
Read MoreAdministering Oracle Clusterware
1. CRSCTL: Cluster Control utility performs various administrative operation of oracle clusterware. It is located in $ORA_CRS_HOME/bin and must be executed by the “root” user. a. To check the current state of all oracle clusterware daemon: [root@rac1 bin]# ./crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy b.You can also check the […]
Read MoreVoting Disk Management in RAC
What is voting disk ? Voting disk is a file that manages information about node membership. It is located on the shared cluster system or a shared raw device file. Its primary purpose is to help in a situation where the private network communication fails. CSS (Cluster Synchronization Service) is the service that determines which […]
Read MoreSingle Instance to RAC conversion using DBCA :Part-II
This is Part II for Single Instance to RAC conversion. For Part-I click here Pre-requisite before conversion 1. Set up the cluster environment and validate the cluster using clvufy. 2. Copy the pre-configured database image from $OLD_ORACLE_HOME/ assistants/ dbca/ templates/ *.dbf & *.dbc to new rac environmnet $NEW_ORACLE_HOME/assistants/dbca/templates/*.dbf & *.dbc 3. Run ORACLE_HOME/bin/dbca step-1 […]
Read MoreSingle Instance to RAC conversion using DBCA :Part-I
There is three method available, you can use any of them to convert single instance to RAC instance. a. using dbca b. using EM c. using rconfig utility Here we are converting using DBCA (DataBase Configuration Assistant). Conversion of single instance database to RAC database using DBCA consists of two part. In first part, we […]
Read MoreCommon Wait Events in a Real Application Clusters
Difference in single instance and RAC instance: In a single database instance environment, there will be only one set of shared memory segments for the database. In other words, the buffer cache and shared pool are local to that particular instance; at any point in time the processes attached to that particular instance will be […]
Read More