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 More

How 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 More

Voting 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 More

ASM 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 More

RHEL 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 More

Administering 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 More

Voting 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 More

Single 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 More

Single 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 More

Common 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
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[i]
[i]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]