Oracle E-Business Suite R12 Cloning - Part I

In the following document we will clone our PROD single node instance installed on tmfbtest2.tameerbank.com server at location /d01/oracle/TEST to the other server tmfbtest1.company.com at location  /d01/oracle/TEST

                                                  

Pre-Clone

/opt/oraprod/db/tech_st/11.1.0/appsutil/scripts/PROD_r12prod

perl adpreclone.pl dbTier

/opt/oraprod/inst/apps/PROD_r12prod/admin/scripts

                                                      Source system                                Target system

    SID                                              PROD                                             PROD

    Port pool                                     80                                                    53

    Database user                             oraprod                                          oraprod

    Application user                        applprod                                         applprod

1. Start source system database tier

              Login as oracle database user

Start database listener

 

                 Start database

 

2. Start source system application tier

  

         Login as oracle application user

 

       Start application

3.  Prepare source system database tier

  

        Connect to database user and run given script

       Provide apps user password

      It will take some time to complete the stage

       Log file should be checked 

4. Prepare source system – application tier

      

          Run given script

        It will take some time to complete the stage

         After completing this stage generated log must be checked

        

         At the end of log file status must be “completed successfully”

5. Stop source system – application tier

6. Stop source system - database tier

           Stop  database listener

          Stop  the database

7. Copy the source system to target system

          Login as root user 

         Copy db folder from source to destination machine at appropriate path

        Copy apps folder from source to target machine at appropriate path

      

      Copy inst folder from source to target machine at appropriate path

 8.    After completing the copy of these folders go to target machine

     

         Add database and application user having group dba

9. Give permission on Target System

     

         Change ownership of db folder from root to oraprod

         Change ownership of apps folder from root to applprod

       

         Change ownership of inst folder from root to applprod

10. Configure the Target System – database tier

            Login as oracle database user and run adcfgclone.pl from given path

          

            Provide the apps user password

        Give target system host name

        

        Provide no for RAC

      

        Provide SID

    

        Provide path of base directory

       

   

    

        Provide path of data folder, default in this case

       

        Provide path of RDMS ORACLE_HOME directory default in this case

         

        Do not preserve the display

        

        Give target system display

       

        For port value provide no if you want to use different port value from source                

        system  

Provide port pool value i.e 53

It will take some time to complete

10. Configure the Target System – application tier

          

            Login as oracle application user and run adcfgclone.pl from given path

           

            provide apps user password

        Provide host name i.e tmfbtest1.tameerbank.com in this case

      

        Provide database SID i.e. PROD

       

        Provide name of database server node i.e. tmfbtest1.tameerbank.com

      

        Provide path of database directory

      

        Provide path of ORACLE_HOME directory, default in this case

         Provide path of APPL_TOP, default in this case

      

         Provide path of COMMON_TOP directory, default in this case

      

         Provide path of instance home directory

        

         Press   Enter for default values

       Do not preserve the display, for this case

    

       Provide system display

   

      Provide no to select different port pool value from source system

      Give port pool value i.e. 53

      Select 1 for UTL_FILE _DIR

       

If status of all services is 0 it means cloning process has successfully done

       

 Set environment file for database and application users in following way

         Provide high lighted information and save the changes

          Similarly create environment file for application user

        Provide the high lighted information and save the changes

    

              Login as oracle database user 

              Use ls command to see all scripts available for this user

         Login as oracle application user 

         Use ls command to see all scripts available for this user

            Now database and application is running

            Go to internet browser and give following address to access application

            Here default port for application is 8000 and 53 is added to this value

             http://tmfbtest1.tameerbank.com:8053

Troubleshooting

Log Directories:

/opt/oraprod/db/tech_st/11.1.0/admin/PROD_r12prod/diag/rdbms/prod/PROD/trace

/opt/oraprod/inst/apps/PROD_r12prod/logs/appl/conc/log

/opt/oraprod/inst/apps/PROD_r12prod/logs/appl/conc/out

/opt/oraprod/inst/apps/PROD_r12prod/logs/ora/10.1.2/reports/cache

/opt/oraprod/inst/apps/PROD_r12prod/logs/ora/10.1.3/Apache/

/opt/oraprod/inst/apps/PROD_r12prod/appltmp

Delete core file from /opt/oraprod/inst/apps/PROD_r12prod/ora/10.1.2/forms

/oradisk/oraprod/db/tech_st/11.1.0/admin/PRODTEST_stylodb/diag/rdbms/prodtest/PRODTEST/trace/oradisk/oraprod /oradisk/oraprod/inst/apps/PRODTEST_stylodb/logs/appl/conc/log

/oradisk/oraprod/inst/apps/PRODTEST_stylodb/logs/appl/conc/out

/oradisk/oraprod/inst/apps/PRODTEST_stylodb/logs/ora/10.1.2/reports/cache

/oradisk/oraprod/inst/apps/PRODTEST_stylodb/logs/ora/10.1.3/Apache/

/oradisk/oraprod/inst/apps/PRODTEST_stylodb/appltmp

Deleting Large number of  *.log Files

find . -name "*.log" -print | xargs rm

find /Backups/ -type f -mtime +20 -exec rm {} \;

find . -name "*.req" -print | xargs rm

                                                                                                       

Removing old Logs (keep only three days old)

/opt/oraprod/db/tech_st/11.1.0/admin/PROD_r12prod/diag/rdbms/prod/PROD/trace

find  /opt/oraprod/inst/apps/PROD_r12prod/logs/appl/conc/log/ -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/PROD_r12prod/logs/appl/conc/out/ -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/PROD_r12prod/logs/ora/10.1.3/opmn/ -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/PROD_r12prod/logs/ora/10.1.2/reports/cache/ -type f -mtime +0 -exec rm {} \;

find /opt/oraprod/inst/apps/PROD_r12prod/logs/ora/10.1.2/forms -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/PROD_r12prod/logs/ora/10.1.3/Apache/ -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/PROD_r12prod/logs/ora/10.1.3/opmn -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/db/tech_st/11.1.0/admin/PROD_r12prod/diag/rdbms/prod/PROD/trace -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/TEST_stylodb/logs/appl/conc/log/ -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/TEST_stylodb/logs/appl/conc/out/ -type f -mtime +0 -exec rm {} \;

find  /opt/oraprod/inst/apps/TEST_stylodb/logs/ora/10.1.2/reports/cache/ -type f -mtime +0 -exec rm {} \;

find  find  /opt/oraprod/inst/apps/TEST_stylodb/logs/ora/10.1.3/Apache/ -type f -mtime +0 -exec rm {} \;

http://saadshujaatoramentary.wordpress.com/category/oracle-ebs-r12/