6 Replies Latest reply on Aug 17, 2015 9:14 AM by Pravin Takpire

    Cloning EBS R12.1.3

    Beauty_and_dBest

      Hi All

       

      ebs r12.1.3

      rhel 6

       

       

      I am now doing cloning in the target server.

       

       

      When I run the clone I got this questions.

       

      Log file located at /u02/oracrp1/CRP1/11.1.0/appsutil/clone/bin/CloneContext_0816115149.log

       

      Provide the values required for creation of the new Database Context file.


      Target System Hostname (virtual or normal) [ebsr12] :

       

      Target Instance is RAC (y/n) [n] :

       

      Target System Database SID : CRP1

       

      Target System Base Directory : /u02/oracrp1/CRP1

       

      Target System utl_file_dir Directory List : /usr/tmp

       

      Number of DATA_TOP's on the Target System [4] :

       

      Target System DATA_TOP Directory 1 :


      I forgot the four(4) data_top source folder   What usually are the locations of this data_top?  I only knew 2 (/u02/oracrp1/CRP1/crp1data,  and $home/dbs)

      How do I get the others? Is it okay that I will leave others blank? Why does it sense four(4) locations?


      I tried to select the source file names and they have only one location folder?


      SQL>select file_name from dba_data_files;


      FILE_NAME

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

      /u04/oracle/CRPUAT/db/apps_st/data/system11.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system08.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system09.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system07.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system06.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system10.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system12.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system05.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system04.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system03.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system02.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/system01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/ctxd01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/owad01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_queue02.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/odm.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/olap.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/sysaux01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/apps_ts_tools01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_data04.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_ind06.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_ref03.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_int02.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/sysaux02.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/portal01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/undo01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_data01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_ind01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_ref01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_int01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_summ01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_nolog01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_archive01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_queue01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_media01.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_data02.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_data03.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_ind02.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_ind03.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_ind04.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_txn_ind05.dbf

      /u04/oracle/CRPUAT/db/apps_st/data/a_ref02.dbf

       

      42 rows selected.

       

      Please help...

       

      Thanks a lot,

      jc

        • 1. Re: Cloning EBS R12.1.3
          Beauty_and_dBest

          Hi ALL,

           

          I see from other docs/blogs they answer like the following:

           

          Number of DATA_TOP's on the Target System [4] : 1

          Target System DATA_TOP Directory 1 : +DATAERP

           

          What does +DATAERP mean?

           

          I tried also to enter the default folder, but I ecounter this error:

           

            \     50% completed       RC-50004: Fatal: Error occurred in ApplyDatabase:

          RC-50014: Fatal: Execution of AutoConfig was failed

           

          ERROR while running Apply...

          Sun Aug 16 20:40:39 2015

           

          ERROR: Failed to execute /u02/oracrp1/CRP1/11.1.0/appsutil/clone/bin/adclone.pl

          ======================

           

          [AutoConfig Error Report]

          The following report lists errors AutoConfig encountered during each

          phase of its execution.  Errors are grouped by directory and phase.

          The report format is:

                <filename>  <phase>  <return code where appropriate>

           

            [INSTANTIATE PHASE]

            AutoConfig could not successfully instantiate the following files:

              Directory: /u02/oracrp1/CRP1/11.1.0/appsutil/install/CRP1_ebsr12

                adcrdb.sh               INSTE8

           

          AutoConfig is exiting with status 1

           

          RC-50014: Fatal: Execution of AutoConfig was failed

          Raised by oracle.apps.ad.clone.ApplyDatabase

           

           

          Please help...

           

          Thanks a lot.

          • 2. Re: Cloning EBS R12.1.3
            2645656

            Hi Jc,

             

            Did you review the below Note.

             

            Oracle E-Business Suite 11i and R12 - Rc-50004: Fatal: Error Occurred In Applydatabase:Control File Creation Failed (Doc ID 1350709.1)

             

            Regards,

            Harsha

            1 person found this helpful
            • 3. Re: Cloning EBS R12.1.3
              Pravin Takpire

              In your case data_top is only one. Data Top is basically mountpoints used for datafiles in target.

              +DATA_ERP is ASM file location for your target if you are using ASM file sytems. This is related to ASM file system nomenclature please read details about same.

              regards

              Pravin

              1 person found this helpful
              • 4. Re: Cloning EBS R12.1.3
                Pravin Takpire

                From your clone log post the portion which is related to adcrdb.sh with just given information we cant say with confidence what went wrong. But from basic look it is evident that you have issue with datafile location on cloned instance. Give the path of DATA_TOP where you have restored datafies and also make sure that it is having correct file permission.

                regards

                Pravin

                1 person found this helpful
                • 5. Re: Cloning EBS R12.1.3
                  Beauty_and_dBest

                  Thanks all,

                   

                  I am suspecting I have more than 1 data_top. What other query can i use to diplay location of tempfiles, logfiles, rollback segments,etc.?

                  • 6. Re: Cloning EBS R12.1.3
                    Pravin Takpire

                    for tempfiles -- dba_temp_files

                    for undo and data files -- dba_data_files

                    for redo logs -- v$logfile

                    If you are facing issue while using adcfgclone, you can manually recreate the database using create controlfile command and then just run adcfgclone on appstier.

                    for DB home to configure you can use adcfgclone with option dbTechstack

                     

                    regards

                    Pravin

                    1 person found this helpful