RAC- TO NON RAC CLONING STEPS

                     SOURCE                            TARGET

TYPE                  RAC                             NON-RAC

Owner                 oracle/oinstall                  oradev/dbdev            ( B UID/GID of owner is different)
Version                11.2.0.2.0                         11.2.0.2.0          
Database              racdb(racdb1.racdb2)             DEVDB
ORACLE_HOME       /syed/dbhome_1                    /u01/app/prodcut/11.2.0/db_1      ( C Oracle Home path is different)
Node                  alpha,beta                         gamma
ASM                     Yes                             No              (D DB Location is different)



Steps
=========
1)  Ensure that the target server meets oracle software requirements.
   a. OS Must be certified
   b. Kernal Parameters must be set
   c. Mandatory OS packages should have been installed
   d . OS limits should have been set

2)  Create the GROUP/USER (dbadev/oraadev)
3)   copy the software (ORACLE_HOME) from the source and (either alpha or beta) to the target server (gama) and change the ownership if required  ( dont use cp/scp)
4)  Extract the software on target host (gama) in the desired path (/u01/app/prodcut/11.2.0/db_1) Do this on gamma
                        A  mkdir -p /u01/app/prodcut/11.2.0/db_1
                        B  chown -R oradev:dbadev /u01/app/prodcut/11.2.0/db_1
                        C  cd /u01/app/prodcut/11.2.0/db_1
ssh root@192.168.1.43 "(cd/syed/dbhome_1: tar -cf - 11.2.0|gzip) "|gunzip |tar -xf -
set  the environment variables (ORACLE_BASE,ORACLE_HOME,ORACLE_SID, PATH, LD_LIBRARY_PATH etc) on the target host
==================================================================================================================
PROBLEM :(B.UID/GID of the owner is different)
a Try to login to sqlplus ' /as sysdba '
b why ?==> Groupnames between source (oinstall) and TARGET (dbadev) are not matching.

FIX IT :
       a  take a backup of $ORACLE_HOME/rdbms/lib//config.o file. This is where the GroupName (oinstall) is hard-coded
       its a binary file,
       b correct the text version : $ORACLE_HOME/rdbms/lib/config.c (AIX/Linux) or $ORACLE_HOME/rdbms/lib/config.s (Solaris)
       depending on the OS
       c replacee the source_group (oinstall) with target group name (dbadev) and save the file

=============================================================================================================
PROBLEM : feature enablement between the source and target is different


a try to set a dummy pfile (initDEVDB.ora) and startup nomount the dummy instance (DEVDB)
b it cant start even in the nomount because software is RAC enabled and there was grid Installed where as its not on target

$ORACLE_HOME/bin/oracle



ADD                                                                    REMOVE
rac_on                                                                  rac-off
rat-on                                                                  rat-off
part-in                                                                 part_off
olap_on                                                                 olap-off
dm_on                                                                   dm-off


cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_off

after adding or removing a specific feature
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle or you can also say "relink all"
try to startup instnace in nomount state




address the third problem oracle binaries are in same location