I just wanted to share few metalink notes on Diagnosing RAC Issues across various platforms. Oracle Support has recently few interesting metalink notes on how to troubleshoot the various layers in a RAC Install i.e Storage, Network, OS, Database, Listener, CRS and ASM Components.
The document also lists various whitepapers/metalink articles on troubleshooting IPMP, RAC Node […]

Popularity: 7% [?]

read more from this topic.....

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 state of individual oracle clusterware daemon:
[root@rac1 […]

Popularity: 7% [?]

read more from this topic.....

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 nodes in the cluster […]

Popularity: 6% [?]

read more from this topic.....

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

step-2

step-3

step-4

step-5

step-6

step-7

step-8

step-9

step-10

step-11

step-12

step-13

step-14

step-15

step-16

step-17

step-18

step-19

step-20

This completes single instance to two Node RAC […]

Popularity: 5% [?]

read more from this topic.....

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 take the backup of  single instance […]

Popularity: 7% [?]

read more from this topic.....

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 accessing […]

Popularity: 5% [?]

read more from this topic.....

The backup of OCR content(Oracle Cluster Registry, to know more about OCR click here) is performed using two methods:

Automatic OCR backup
Manually OCR backup
.

1. Automatic OCR Backup
OCR is automatically backed up physically

Every four hours
At the end of every day
At the end of every week

To check current location of automatic backup of OCR:
[root@rac1 crs]# ocrconfig –showbackup
rac1     2009/06/07 14:58:31     […]

Popularity: 6% [?]

read more from this topic.....