Creating single instance standby from 2 node RAC in AIX 6.1

Step1: Create the requires pfiles for both primary & standby

Sample primary Init file
===============================
T24TRAIN1.__db_cache_size=1342177280
T24TRAIN2.__db_cache_size=1358954496
T24TRAIN1.__java_pool_size=16777216
T24TRAIN2.__java_pool_size=16777216
T24TRAIN1.__large_pool_size=16777216
T24TRAIN2.__large_pool_size=16777216
T24TRAIN1.__pga_aggregate_target=1677721600
T24TRAIN2.__pga_aggregate_target=1677721600
T24TRAIN1.__sga_target=2516582400
T24TRAIN2.__sga_target=2516582400
T24TRAIN1.__shared_io_pool_size=0
T24TRAIN2.__shared_io_pool_size=0
T24TRAIN1.__shared_pool_size=1107296256
T24TRAIN2.__shared_pool_size=1090519040
T24TRAIN1.__streams_pool_size=0
T24TRAIN2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/T24TRAIN/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/t24train/controlfile/current.273.778262941','+DATA/t24train/controlfile/current.272.778262941'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_recovery_file_dest_size=319815680000
*.db_recovery_file_dest='+ARCHIVE'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=T24TRAINXDB)'
T24TRAIN1.instance_number=1
T24TRAIN2.instance_number=2
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=4194304000
*.open_cursors=300
*.processes=5000
*.remote_listener='t24db_scan.cbe.local:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=5505
T24TRAIN2.thread=2
T24TRAIN1.thread=1
T24TRAIN2.undo_tablespace='UNDOTBS2'
T24TRAIN1.undo_tablespace='UNDOTBS1'
#parameters spcific to Standby database
*.db_name='T24TRAIN'
*.DB_UNIQUE_NAME='T24TRAIN'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(T24TRAIN,T24TRAINSBY)'
*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=T24TRAIN'
*.LOG_ARCHIVE_DEST_2='SERVICE=T24TRAINSBY ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=T24TRAINSBY'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
*.LOG_ARCHIVE_MAX_PROCESSES=8
*.FAL_SERVER=T24TRAINSBY
*.DB_FILE_NAME_CONVERT='+DATA/T24TRAINSBY/,'+DATA/T24TRAIN/'
*.LOG_FILE_NAME_CONVERT='+DATA/T24TRAINSBY/','+DATA/T24TRAIN/'
*.STANDBY_FILE_MANAGEMENT=AUTO

Sample standby INIT file
===================
audit_file_dest='/u01/app/oracle/admin/T24TRAINSBY/adump'
audit_trail='db'
compatible='11.2.0.0.0'
control_files='+DATA/T24TRAINSBY/CONTROLFILE/control01.ctl','+DATA/T24TRAINSBY/CONTROLFILE/control02.ctl'
db_block_size=8192
db_create_file_dest='+DATA'
db_domain=''
db_recovery_file_dest_size=319815680000
db_recovery_file_dest='+ARCHIVE'
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=T24TRAINXDB)'
log_archive_format='%t_%s_%r.dbf'
memory_target=4194304000
open_cursors=300
processes=5000
remote_login_passwordfile='exclusive'
sessions=5505
#parameters spcific to Standby database
db_name='T24TRAIN'
DB_UNIQUE_NAME='T24TRAINSBY'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(T24TRAIN,T24TRAINSBY)'
LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=T24TRAINSBY'
LOG_ARCHIVE_DEST_2='SERVICE=T24TRAIN ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=T24TRAIN'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=8
FAL_SERVER=T24TRAIN
DB_FILE_NAME_CONVERT='+DATA/T24TRAIN','+DATA/T24TRAINSBY/'
LOG_FILE_NAME_CONVERT='+DATA/T24TRAIN','+DATA/T24TRAINSBY/'
STANDBY_FILE_MANAGEMENT=AUTO

Step2: Start primary with the modified pfile if it is ASM stored pfile

SQL> shutdown immediate
SQL>exit
SQL>export ORACLE_SID=<primary_db_instance_name>
SQL>sqlplus / as sysdba
SQL>startup nomount pfile='/tmp/<modified_pfile>.ora'
SQL>create spfile='<ASM_PATH>' from pfile='/tmp/<modified_pfile>.ora'
SQL> exit

<convert pfile to spfile on ASM storage>
go to $ORACLE_HOME/dbs/  find the corresponding init.ora file for primary DB, crosscheck the contents with correct ASM path for spfile or modify it.

Step3:
Create necessary standby redo log files. e.g. in our env we have 2 threads each with 2 groups , so we added 2 standby redo log threads each with 3 groups

First create necessary ASM directories to hold the standby logs
e.g. +DATA/T24TRAIN/STANDBYLOG

then make standby file management manual on both nodes

alter system set standby_file_management=manual scope=both sid='*';

alter database add standby logfile thread 1 group 15 '+DATA/T24TRAIN/STANDBYLOG/standby_group_15.log' size 500M;
alter database add standby logfile thread 1 group 16 '+DATA/T24TRAIN/STANDBYLOG/standby_group_16.log' size 500M;
alter database add standby logfile thread 1 group 17 '+DATA/T24TRAIN/STANDBYLOG/standby_group_17.log' size 500M;
alter database add standby logfile thread 2 group 18 '+DATA/T24TRAIN/STANDBYLOG/standby_group_18.log' size 500M;
alter database add standby logfile thread 2 group 19 '+DATA/T24TRAIN/STANDBYLOG/standby_group_19.log' size 500M;
alter database add standby logfile thread 2 group 20 '+DATA/T24TRAIN/STANDBYLOG/standby_group_20.log' size 500M;

again make standby file management auto

alter system set standby_file_management=auto scope=both sid='*';

Step4: make appropriate tnsnames.ora entries on both RAC primary nodes & standby server


Step5: Make sure fal_server parameter can be connected from either side , this is important as it is used for redolog transfer

e.g. in primary FAL_SERVER=t24trainsby
so from primary server
prompt> sqlplus sys/password@t24trainsby as sysdba <should be able to connect>
          
in standby FAL_SERVER=t24train
prompt> sqlplus sys/password@t24train as sysdba<should be able to connect>

important: for our particular case we had used SCAN for primary so make sure SCAN also should be able to resolve from standby site.

Step6: make backup of primary site

 create required direcory to hold backup in local file system

mkdir /u01/backup/

rman target /

run

{

     sql "alter system switch logfile";

     allocate channel ch1 type disk format '/u01/backup/Primary_bkp_for_stndby_%U';

     backup database;

     backup current controlfile for standby;

     sql "alter system archive log current";

}

scp the backup pieces to standby server
scp /u01/backup/Primary_bkp_for_stndby* mailto:oracle@%3Cstandby_server%3E:/u01/backup/

Step7: Also make password file common on both RAC nodes & standby server
e.g.
[login to primary & standby DBs & make sec_case_sensitive_logins=FALSE]
unix_prompt> cd $ORACLE_HOME/dbs
           > <delete or backup any existing passwd files>
           > orapw file=<> entries=5 ignorecase=y password=<> 

Step8:Start the standby DB in nomount state using the modified pfile & create spfile from it.

prompt> export ORACLE_SID=t24trainsby
prompt> sqlplus / as sysdba
 sql> startup nomount pfile='<PATH>'
 sql> create spfile='<ASM_PATH>' from pfile='<PATH>'
 sql> exit

Step 8: from stanby server 

$ rman target sys@T24TRAIN1 auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Mar 26 08:41:48 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
target database Password:
connected to target database: T24TRAIN (DBID=3199606683)
connected to auxiliary database: T24TRAIN (not mounted)
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;
Starting Duplicate Db at 26-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=5293 device type=DISK
contents of Memory Script:
{
   restore clone standby controlfile;
}
executing Memory Script
Starting restore at 26-MAR-12
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/Primary_bkp_for_stndby_03n6hill_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/backup/Primary_bkp_for_stndby_03n6hill_1_1 tag=TAG20120322T191253
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA/t24trainsby/controlfile/control01.ctl
output file name=+DATA/t24trainsby/controlfile/control02.ctl
Finished restore at 26-MAR-12
contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
   set newname for tempfile  1 to
 "+data";
   switch clone tempfile all;
   set newname for datafile  1 to
 "+data";
   set newname for datafile  2 to
 "+data";
   set newname for datafile  3 to
 "+data";
   set newname for datafile  4 to
 "+data";
   set newname for datafile  5 to
 "+data";
   set newname for datafile  6 to
 "+data";
   set newname for datafile  7 to
 "+data";
   restore
   clone database
   ;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +data in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 26-MAR-12
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +data
channel ORA_AUX_DISK_1: restoring datafile 00002 to +data
channel ORA_AUX_DISK_1: restoring datafile 00003 to +data
channel ORA_AUX_DISK_1: restoring datafile 00004 to +data
channel ORA_AUX_DISK_1: restoring datafile 00005 to +data
channel ORA_AUX_DISK_1: restoring datafile 00006 to +data
channel ORA_AUX_DISK_1: restoring datafile 00007 to +data
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/Primary_bkp_for_stndby_01n6hil2_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/backup/Primary_bkp_for_stndby_01n6hil2_1_1 tag=TAG20120322T191233
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:46
Finished restore at 26-MAR-12
contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=778927491 file name=+DATA/t24trainsby/datafile/system.260.778927447
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=778927491 file name=+DATA/t24trainsby/datafile/sysaux.261.778927447
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=778927491 file name=+DATA/t24trainsby/datafile/undotbs1.262.778927447
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=778927491 file name=+DATA/t24trainsby/datafile/users.264.778927447
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=778927491 file name=+DATA/t24trainsby/datafile/undotbs2.263.778927447
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=778927491 file name=+DATA/t24trainsby/datafile/t24distdata.258.778927447
datafile 7 switched to datafile copy
input datafile copy RECID=14 STAMP=778927491 file name=+DATA/t24trainsby/datafile/t24distindex.259.778927447
Finished Duplicate Db at 26-MAR-12
RMAN> exit
 

Issues in Installation of 2 node RAC on AIX 6.1

The main issues faced are only discussed here

Issues1: While running root.sh script it fails with "Error: Connection Timeout"
reason:   due to incorrect ULIMIT setting for users in AIX.

Issue2:  Accidentally override the System disks for ASM.
reason: before using a RAW disk for ASM make sure it has correct reserve_policy & ownership changed to grid:oinstall & permission correctly given

Issue3: While Database creation ASM diskgroups doesn't show up.
reason: the file permission of $GRID_HOME/bin/oracle should be 6571 so as root user change permission of the executable
root> chmod 6571 $GRID_HOME/bin/oracle

Issue4: After database creation users not able to connect by tns entry.
reason: Change the permission of $ORACLE_HOME/bin/oracle to 6571 as root user
root> chmod 6571 $ORACLE_HOME/bin/oracle

Creating a Duplicate Database in using RMAN in 10g(windows platform), Same server with different file structure

Hi,
Please find the below steps for creating a duplicate DB in 10g

• Step1(take proper backup & list backups ensure control file auto backup on)

        Take RMAN backup from primary database(please refer the attachment)

        List all the backups from RMAN

        Now see if any backups are taken in different location(my case i put all the backups in "D:\rman_backup") ,
        My case i moved controlfile autobackup from 'C:\oracle\product\10.2.0\db_1\flash_recovery_area\ORCL\AUTOBACKUP\2012_01_12\O1_MF_S_772414891_7JY8LSN2_' to 'D:\rman_backup\'

        Catalog any of the moved backuppiece in RMAN


RMAN> catalog backuppiece 'D:\rman_backup\O1_MF_S_772414891_7JY8LSN2_.BKP';

cataloged backuppiece
backup piece handle=D:\RMAN_BACKUP\O1_MF_S_772414891_7JY8LSN2_.BKP recid=57 stamp=772416237

• Prepare a proper init file for the new database , please find the below file i used(note log_file_name_convert & db_file_name_convert parameters)

        Content of initDUP.ora

*.audit_file_dest='D:\dup\adump'

*.background_dump_dest='D:\dup\bdump'

*.compatible='10.2.0.1.0'

*.control_files='D:\dup\control01.ctl','D:\dup\control02.ctl','D:\dup\control03.ctl'

*.core_dump_dest='D:\dup\cdump'

*.cursor_sharing='SIMILAR'

*.db_block_size=8192

*.db_create_file_dest='D:\dup\'

*.db_create_online_log_dest_1='D:\dup\redolog\'

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_file_name_convert='C:\oracle\product\10.2.0\oradata\orcl\','D:\dup\','C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\','D:\dup\','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORCL\DATAFILE\','D:\dup\'

*.log_file_name_convert='C:\oracle\product\10.2.0\oradata\orcl\','D:\dup\redolog\','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDOLOG\ORCL\ONLINELOG\','D:\dup\redolog\'

*.db_name='orcldup'

*.db_recovery_file_dest='D:\dup\flash_recovery_area\'

*.db_recovery_file_dest_size=6442450944

*.dg_broker_start=TRUE

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.global_names=TRUE

*.job_queue_processes=10

*.log_archive_dest_1='location=D:\dup\archive valid_for=(all_logfiles,all_roles)'

*.nls_date_format='YYYY/MM/DD HH24:MI:SS'

*.nls_time_format='YYYY/MM/DD HH24:MI:SS'

*.open_cursors=300

*.optimizer_mode='all_rows'

*.pga_aggregate_target=96468992

*.processes=150

*.query_rewrite_integrity='TRUSTED'

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=290455552

*.sql_trace=TRUE

*.standby_file_management='AUTO'

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='D:\dup\udump'

         Create a new instance in windows using

  

C:\Windows\system32>oradim -new -sid orcldup

Instance created.

     Start the instance with the pfile

now exit from sqlplus and go to RMAN for restoration, connect to both target & auxiliary as in the screenshots

Now login & check you should have your duplicate database ready..... enjoy...:)

ORACLE 11gR2 stand alone installation on CentOS(RedHat) 5.5 with VMware

This document is based on my personal experience for installing Oracle 11gR2 on CentOS 5.5(RHEL) on VM ware(VM player)

This give no guarantee for production systems.This is done in a purely development and test enviornment. 


My VM(Virtual machine)configuration has 2896 MB RAM and 14GB free space for ORACLE installation.


STEP1: Download 2 zip files for 11gR2 for RHEL from ORACLE's site.


Here i have used "winscp" to move files(11gR2 dataase zip files) from windows to Unix box and vice verssa

• Download & install winscp executables on your windows machine.
• find the physical ip for your Linux box using ifconfig.It would be something like

    [root@localhost ~]# ifconfig

    eth0 : inet addr :192.168:80:130

• Now you have your ip and connect to your linux machine...  :)

  


STEP2: Check if necessary Linux packages has installed or not

[root@localhost ~]#rpm -q binutils compat-libstdc++-33\

elfutils-libelf elfutils-libelf-devel \

elfutils-libelf-devel-static  gcc gcc-c++ glibc glibc-common glibc-devel\

 glibc-headers kernel-headers-2.6.18 ksh libaio\

 libaio-devel libgcc libgomp libstdc++ \

libstdc++-devel make sysstat unixODBC unixODBC-devel

if some packages are missing then install 

them using

yum install compat-db gcc gcc-c++ libstdc++ pdksh sysstat compat-libstdc++-33 \

elfutils-libelf-devel elfutils-libelf-devel-static unixODBC unixODBC-devel

STEP3:Create oinstall and dba groups & user "Oracle" for  as follows




[root@localhost /]# cd /usr
[root@localhost usr]# cd sbin
[root@localhost sbin]# pwd
/usr/sbin
[root@localhost sbin]# ls -ltr|grep group
-rwxr-xr-x 1 root root     24564 Oct 27  2009 lgroupmod
-rwxr-xr-x 1 root root     19168 Oct 27  2009 lgroupdel
-rwxr-xr-x 1 root root     20036 Oct 27  2009 lgroupadd
-rwxr-x--- 1 root root     30256 Mar 30  2010 groupmod
-rwxr-x--- 1 root root     30568 Mar 30  2010 groupdel
-rwxr-x--- 1 root root     39120 Mar 30  2010 groupadd
[root@localhost sbin]# /usr/sbin/groupadd oinstall
groupadd: group oinstall exists   [i had already created the group]
[root@localhost sbin]# /usr/sbin/groupadd dba
groupadd: group dba exists        [i had already created the group]

[root@localhost sbin]#/usr/sbin/useradd oracle

passwd <>

change the primary groups for the user "oracle" 

as below

[root@localhost sbin]# usermod  -g oinstall -G dba oracle
[root@localhost sbin]# cat /etc/passwd|grep oracle
oracle:x:500:501:Subhendra:/home/oracle:/bin/bash
[root@localhost sbin]# su - oracle
[oracle@localhost ~]$ id
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba) context=root:system_r:unconfined_t:SystemLow-SystemHigh

Step4: Setting up kernel parameter(take backup before modifying the sysctl.conf)

[root@localhost ~]# cd /etc
[root@localhost etc]# ls -ltr|grep sys
......
-rw-r--r--  1 root root     994 Sep 28  2009 sysctl.conf
.......
[root@localhost etc]# view sysctl.conf
[root@localhost etc]# pwd
/etc
[root@localhost etc]# cp sysctl.conf sysctl.conf.bkp

[append the below parameter values to the end of the file]

[root@localhost etc]# cat >> /etc/sysctl.conf << EOF

> # Added kernel parameters for Oracle setup
> kernel.shmmni = 4096
> kernel.sem = 250 32000 100 128
> fs.file-max = 6815744
> net.ipv4.ip_local_port_range = 9000 65500
> net.core.rmem_default=262144
> net.core.wmem_default=262144
> net.core.rmem_max=4194304
> net.core.wmem_max=1048576
> fs.aio-max-nr=1048576
> EOF

[root@localhost etc]# view /etc/sysctl.conf

<to make changes dynamically fire the below commands>
[root@localhost etc]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
[root@localhost etc]# hostname
localhost.localdomain
[root@localhost etc]# uname -a
Linux localhost.localdomain 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:35 EDT 2010 i686 i686 i386 GNU/Linux
[root@localhost etc]# cd ~
[root@localhost ~]# pwd
/root
[root@localhost ~]# echo $SHELL
/bin/bash

STEP5:  Creating necessary directory structure for oracle installation <to find the free space for installation>

[root@localhost etc]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2             3.8G  2.1G  1.6G  58% /
/dev/sda5              14G  2.4G   11G  18% /home
/dev/sda1              46M   11M   33M  25% /boot
tmpfs                 506M     0  506M   0% /dev/shm

Here i should have ideally chosen mount point /opt for installation but due to space constraints i have chosen mount point /home

mkdir -p /home/app/oracle/product/11.1.0

chown -R oracle:oinstall /opt/home

chmod -R 775 /opt/app

STEP 6:Setting up /etc/.bash_profile for default privileges for directories/files created after modification run .bash_profile for changes to take effect.

[oracle@localhost ~]$ pwd
/home/oracle
[oracle@localhost ~]$ ls -lart|grep profile
-rwxrwxr-x  1 oracle oinstall  176 Nov  8 17:43 .bash_profile
[oracle@localhost ~]$ cat .bash_profile
# .bash_profile


# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi


# User specific environment and startup programs


PATH=$PATH:$HOME/bin


export PATH
[oracle@localhost ~]$ vi .bash_profile
[oracle@localhost ~]$ cat .bash_profile
# .bash_profile


# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi


# User specific environment and startup programs


PATH=$PATH:$HOME/bin


export PATH
umask 022
[oracle@localhost ~]$ 
[oracle@localhost ~]$ . ./.bash_profile


STEP 7: Setting DISPLAY parameter <machine_ip:0.0>


[root@localhost ~]#export DISPLAY=192.168.80.130:0.0


STEP 8: Now we will unzip both the 11GR2 database files to /home




[root@localhost ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2             3.8G  2.1G  1.6G  58% /
/dev/sda5              14G  2.4G   11G  18% /home
/dev/sda1              46M   11M   33M  25% /boot
tmpfs                 506M     0  506M   0% /dev/shm

[root@localhost ~]#nohup unzip linux_11gR2_database_1of2 /home &


[root@localhost ~]#nohup unzip linux_11gR2_database_2of2 /home &


STEP 9:Now we are all set for stand alone Oracle database installation


  open a terminal as root user and follow the steps as mentioned below in screen shots

    


STEP10: Now it will open up with OUI universal installer.


       click next bottoms as you proceed 
note: In my case the screen flickers frequently may be due to insufficient memory
       But i managed to click on the bottoms after some trials
      this might take several hours. at some steps of installation it might ask some files are missing just ignore that message


Step11: At end of installation it would ask you to run 2 scripts just 
       
        open another terminal as root and copy paste the script names hit enter.
 Now you have your test database running on CentOS5.5(RedHat) with you.