5 Replies Latest reply on Dec 5, 2016 12:18 PM by Srini Chavali-Oracle

    adpreclone issue on db tier.

    3330484

      Hello,

       

      We have Oracle EBS 12.1.3 along with DB 11.1.0.7 which is running on Windows 2008 R2 (SP1) on VM Machine.

       

      Doc ID 406982.1

       

       

      Just for safer side, I am performing all step first on Non-production and once it is success then same steps I am moving on PROD.

       

       

      Section 1: Prerequisite Tasks : Completed on UAT.

       

       

      Section 2: Cloning Tasks - Below issue

       

       

      Prepare the source system database tier for cloning

      $ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]

      $ perl adpreclone.pl dbTier

       

       

      D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\scripts\EBSUAT_EBSDBUAT2>perl adpreclone.pl

      Bareword found where operator expected at adpreclone.pl line 406, near ". 'D"

      (Might be a runaway multi-line '' string starting on line 402)

      (Missing operator before D?)

      Backslash found where operator expected at adpreclone.pl line 406, near "oracle\"

      Backslash found where operator expected at adpreclone.pl line 406, near "PROD\"

      Backslash found where operator expected at adpreclone.pl line 406, near "db\"

      Backslash found where operator expected at adpreclone.pl line 406, near "tech_st\"

      Backslash found where operator expected at adpreclone.pl line 406, near "11.1.0_64\"

      (Missing operator before \?)

      Backslash found where operator expected at adpreclone.pl line 406, near "jre\"

      Backslash found where operator expected at adpreclone.pl line 406, near "1.5.0\"

      (Missing operator before \?)

      syntax error at adpreclone.pl line 406, near ". 'D"

      Bad name after java' at adpreclone.pl line 406.

       

       

      D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\scripts\EBSUAT_EBSDBUAT2>

       

       

       

       

      D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\scripts\EBSUAT_EBSDBUAT2>echo %PERL5LIB%

      D:\oracle\PROD\db\tech_st\11.1.0_64\perl\5.8.3\lib\MSWin32-X64-multi-thread;D:\oracle\PROD\db\tech_st\11.1.0_64\perl\5.8.3\lib;D:\oracle\PROD\db\tech_st\11.1.0_64\perl\site\5.8.3\lib\MSWin32-X64-multi

      -thread;D:\oracle\PROD\db\tech_st\11.1.0_64\perl\site\5.8.3\lib;D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\perl

       

       

      D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\scripts\EBSUAT_EBSDBUAT2>echo %PATH%

      D:\oracle\PROD\db\tech_st\11.1.0_64\perl\5.8.3\bin\MSWin32-x64-multi-thread\;D:\oracle\PROD\db\tech_st\11.1.0_64\bin;C:\Program Files\Legato\nsr\bin;C:\Program Files (x86)\Legato\nsr\bin;D:\oracle\PRO

       

      D\db\tech_st\11.1.0\bin;D:\util\cygwin\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;;D:\util\msvc\VC\bin

       

       

       

       

      I am attaching, adpreclone.pl for DEV / UAT

       

       

      DEV - We do not have any problem to run adpreclone.pl

      UAT - We are having now problem with adpreclone.pl, previously it was working fine.

       

       

      Regards,

        • 1. Re: adpreclone issue on db tier.
          Shaik

          Hi

           

          Compare the adpreclone script with working instance script

           

          Just refer this document, similar issue

          RAC on Linux From OVM Template Deployment: Bareword found where operator expected at oclumon.pl line 52, near "/u01/app" (Doc ID 1646211.1)

           

           

          Regards

          Shaik

          • 2. Re: adpreclone issue on db tier.
            3330484

            I checked difference already and according to my understanding we do not have jar directory under appsutil directory.

             

            I have checked difference with utililty - https://www.diffchecker.com/diff

            Already adpreclone.pl is attached in my post to review.

             

            DEV - $CTX_FILE    = 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\EBSUAT_ebsdbdev.xml';

            UAT - $CTX_FILE    = 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\EBSUAT_EBSDBUAT2.xml';

             

             

            -

            DEV - if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "${binExt}") {

            $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre');

             

             

            UAT - if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\/bin/java' . "${binExt}") {

            $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\');

            -

             

             

            DEV - . 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "\n"

            UAT - . 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\/bin/java' . "\n"

             

             

            DEV - $DB_ENVFILE = 'D:\oracle\PROD\db\tech_st\11.1.0_64\EBSUAT_ebsdbdev.cmd';

            UAT - $DB_ENVFILE = 'D:\oracle\PROD\db\tech_st\11.1.0_64\EBSUAT_EBSDBUAT2.cmd';

             

             

            DEV - $CTX_FILE   = 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\EBSUAT_ebsdbdev.xml';

            UAT - $CTX_FILE   = 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\EBSUAT_EBSDBUAT2.xml';

             

             

            -

            DEV - if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "${binExt}") {

            $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre');

             

             

            UAT - if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\/bin/java' . "${binExt}") {

            $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\');

            -

             

             

            DEV - . 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "\n"

            UAT - . 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\/bin/java' . "\n"

            • 3. Re: adpreclone issue on db tier.
              Srini Chavali-Oracle

              Re-create the appsutil directory in the RDBMS_HOME - follow the steps in MOS Doc 377495.1

              • 4. Re: adpreclone issue on db tier.
                3330484

                Hello,

                 

                Thank you for update.

                 

                According to your advice Doc ID 377495.1, Do I have to "Generate the Database Context File" step as well ?

                 

                If You look @ Doc ID 406982.1, I have already performed all steps as below, Except "Generate Database Context File"

                 

                Section 1: Prerequisite Tasks

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

                6.Run AutoConfig on the application tiers
                Follow the steps under section " Run AutoConfig on the Application Tiers " in My Oracle Support Knowledge Document 387859.1 to run AutoConfig on all application tier nodes.

                7.Synchronize appsutil on the database tier nodes
                Follow the steps under section "Copy AutoConfig to the RDBMS ORACLE_HOME" in My Oracle Support Knowledge Document 387859.1 to copy AutoConfig and Rapid Clone files to each database node via the admkappsutil.pl utility.

                8.Run AutoConfig on the database tier
                Follow the steps under section "Run AutoConfig on the Database Tier" in My Oracle Support Knowledge Document 387859.1 to run AutoConfig on the database tier nodes.

                9.Maintain Snapshot Information
                Log in to each application tier node as the APPLMGR user, and run "Maintain Snapshot Information" in AD Administration. To update the snapshot, please select the following options "Update Current View Snapshot" and "Update Complete APPL_TOP".


                But still I am unable to get jre folder under appsutil folder, Then as a work around I did below step, as issue is resolve temporary

                 

                1) We do not have jre folder so I copied jre folder from DEV (appsutil) directory to UAT (appsutil) directory.
                2) I checked adpreclone.pl file in DEV, and made below changes.

                ********************************************************************
                oracle@oradeva <-->{/software/EXPD/Trilok}:$diff adpreclone4_Dec.pl adpreclone.pl
                401,402c401,402
                < if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\/bin/java' . "${binExt}") {
                < $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\');
                ---
                > if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "${binExt}") {
                > $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre');
                406c406
                < . 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\bin\java' . "\n"
                ---
                > . 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "\n"
                453,454c453,454
                < if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\/bin/java' . "${binExt}") {
                < $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\');
                ---
                > if (-e 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "${binExt}") {
                > $JAVA_HOME = getOSfilepath('D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre');
                458c458
                < . 'D:\oracle\PROD\db\tech_st\11.1.0_64\jre\1.5.0\/bin/java' . "\n"
                ---
                > . 'D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\jre/bin/java' . "\n"
                oracle@oradeva <-->{/software/EXPD/Trilok}:$

                ********************************************************************

                 

                and now I am able to run adpreclone on dbtier.

                 

                D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\scripts\EBSUAT_EBSDBUAT2>perl adpreclone.pl dbTier

                Copyright (c) 2002 Oracle Corporation
                Redwood Shores, California, USA

                Oracle Applications Rapid Clone

                Version 12.0.0

                adpreclone Version 120.20.12010000.5

                Enter the APPS User Password: Terminating on signal SIGINT(2)

                D:\oracle\PROD\db\tech_st\11.1.0_64\appsutil\scripts\EBSUAT_EBSDBUAT2>

                 

                But it is just a work around, How we can resolve it permanently, because same issue exist on PROD as well.
                Please advice.

                 

                Regards,

                • 5. Re: adpreclone issue on db tier.
                  Srini Chavali-Oracle

                  You need to run all of the required steps in the MOS Docs. You will need to fix the issue on the source system first - see MOS Doc 1084209.1