Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Tuesday, January 30, 2007

Oracle RAC Interview Questions & some useful Information

1)What is Oracle Clusterware?
i) Oracle clusterware is portable cluster software that allows clustering of single servers so that they cooperate as a single system.
ii) Oracle Clusterware also provides the required infrastructure for Oracle Real Application clusters (RAC).
Oracle clusterware enables the protection of any Oracle application or any other kind of application within a cluster.
iii) Oracle clusterware provides the level of high availability that is commonly known to be achievable for nearly all kind of applications and databases managed in cluster environments, like Oracle single Instance databases, oracle application servers, oracle enterprise manager components, third party databases or any other kind of application.
2. How to check if the database is RAC enabled?
3. Will the CRS services hang if CRS Home is full?
4. How will you convert single instance to RAC?
5. How will you tune interinstance communication?
http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/monitor.htm#CFAGAAGD
6. Explain how will you add nodes to the existing cluster?
http://download.oracle.com/docs/cd/B19306_01/rac.102/b28759/addnodes2.htm#CHDFBGFJ

i) Configure the operating system and hardware for the new node.
ii) Add the node to the cluster
You can do this by running $ORACLE_CRSHOME/oui/bin/ addNode.sh
iii) Add the rac software to the new node $ORACLE_HOME/oui/bin/addNode.sh
iv) Reconfigure listeners for the new node
Run -> $netca
v) Add new Instance,
run -> $dbca

------------------------------------------------------------------------

7. How will you shutdown everything in a Cluster in a single command?

root@prmord1p # /etc/init.d/init.crs stop
Shutting down Oracle Cluster Ready Services (CRS):
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
root@prmord1p # ps -ef grep crs
root 29640 27940 0 15:14:16 pts/4 0:00 grep crs
root 12595 1 0 Jun 20 ? 0:00 /usr/sbin/vxnotify -g oracrsdg
root 29227 1 0 15:13:41 ? 0:00 /bin/sh /etc/init.d/init.crsd run
*************** And to start ***********************
root@prmord1p # clear
root@prmord1p # /etc/init.d/init.crs start
Startup will be queued to init within 30 seconds.

------------------------------------------------------------------------------------------------
8. Explain what is VIP?
9. Describe the difference in Architecture of 9i and 10g RAC?

2 comments:

  1. Hi

    I read this post 2 times. It is very useful.

    Pls try to keep posting.

    Let me show other source that may be good for community.

    Source: Database interview questions

    Best regards
    Jonathan.

    ReplyDelete
  2. Hi

    I read this post 2 times. It is very useful.

    Pls try to keep posting.

    Let me show other source that may be good for community.

    Source: Database interview questions

    Best regards
    Jonathan.

    ReplyDelete

 
Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved