Oracle Applications 11i FAQ's

1. Why does 11i have an 8.0.6 and an 8.1.6 ORACLE_HOME?
Release 11i requires an Oracle8i (v8.1.6) database which is installed in the 8.1.6 ORACLE_HOME. The 8.0.6 ORACLE_HOME is required to host several other components of the Release 11i technology stack (such as Developer 6i and WebDB 2.2). The applications run in server partitioned mode, where the code is compiled and linked with the 8.0.6 ORACLE_HOME.

Importing Few Users

I was asked by my friends, few times about - the ways to import more than one user in a go...
I would be creating a parfile like this...
userid=expman/expman@amdbu
file=/bkdump/Exp_Bak/exp_amdbu_0311060054.dmp
fromuser=(schema1, schema2, schema3, schema4)
touser=(schema1, schema2, schema3, schema4)
ignore=y
commit=y
buffer=10000000
log=/export/home/oracle/amdbu/imp_schemas.log
feedback=1000000

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?

Oracle RAC 10G -- Learning to know

Nov 18 – 2006 : The day I came to know that I am going to involve in a new project which is going to on Real Application Clusters, with a project of Asia-Pacific regions to be live on this and targeting a data of 4TB and more. As I am new to this and very enthusiastic to learn more. To start with, I browsed Oracle Documents for Oracle RAC 10g R1 online documentation and few others to learn more. In fact I got a corporate training which helped me a lot to go with.

I found few of the books which helped me a lot,
1. Oracle Online Documenation
2. Oracle 10g Grid & Real Application Clusters