4 Replies Latest reply: Sep 13, 2013 4:12 AM by Ankur ... RSS

    RC-40201: Unable to connect to Database TEST while running adcfgclone.pl appsTier

    Ankur ...

      Hi Experts,

       

      While performing cloning for one my R12 instance, I got RC-40201 error when I ran "adcfgclone.pl appsTier".

       

      [appltst@oracleupk bin]$ perl adcfgclone.pl appsTier

       

                           Copyright (c) 2002 Oracle Corporation

                              Redwood Shores, California, USA

       

                              Oracle Applications Rapid Clone

       

                                       Version 12.0.0

       

                            adcfgclone Version 120.31.12010000.1

       

      Enter the APPS password :

       

      Running:

      /data/appl_top/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /data/appl_top/apps/apps_st/comn/clone/jlib/java:/data/appl_top/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/data/appl_top/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /data/appl_top/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_24425.lst -stage /data/appl_top/apps/apps_st/comn/clone  2> /tmp/adcfgclone_24425.err; echo $? > /tmp/adcfgclone_24425.res

       

      Log file located at /data/appl_top/apps/apps_st/comn/clone/bin/CloneContext_0912145803.log

       

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

       

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

       

      Target System Database SID : TEST

       

      Target System Database Server Node [oracleupk] :

       

      Target System Base Directory : /data/appl_top

       

      Target System Tools ORACLE_HOME Directory [/data/appl_top/apps/tech_st/10.1.2] :

       

      Target System Web ORACLE_HOME Directory [/data/appl_top/apps/tech_st/10.1.3] :

       

      Target System APPL_TOP Directory [/data/appl_top/apps/apps_st/appl] :

       

      Target System COMMON_TOP Directory [/data/appl_top/apps/apps_st/comn] :

       

      Target System Instance Home Directory [/data/appl_top/inst] :

       

      Target System Root Service [enabled] :

       

      Target System Web Entry Point Services [enabled] :

       

      Target System Web Application Services [enabled] :

       

      Target System Batch Processing Services [enabled] :

       

      Target System Other Services [disabled] :

       

      Do you want to preserve the Display [oracleupk:0.0] (y/n) ? : n

       

      Target System Display [oracleupk:0.0] : oracleupk:1.0

       

      Target System Port Pool [0-99] : 80

       

      Checking the port pool 80

      done: Port Pool 80 is free

      Report file located at /data/appl_top/inst/apps/TEST_oracleupk/admin/out/portpool.lst

      Complete port information available at /data/appl_top/inst/apps/TEST_oracleupk/admin/out/portpool.lst

      RC-40201: Unable to connect to Database TEST.

       

      Creating the new APPL_TOP Context file from :

        /data/appl_top/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

       

      The new APPL_TOP context file has been created :

        /data/appl_top/inst/apps/TEST_oracleupk/appl/admin/TEST_oracleupk.xml

       

      Log file located at /data/appl_top/apps/apps_st/comn/clone/bin/CloneContext_0912145803.log

      Check Clone Context logfile /data/appl_top/apps/apps_st/comn/clone/bin/CloneContext_0912145803.log for details.

       

      Running Rapid Clone with command:

      perl /data/appl_top/apps/apps_st/comn/clone/bin/adclone.pl java=/data/appl_top/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/data/appl_top/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/data/appl_top/inst/apps/TEST_oracleupk/appl/admin/TEST_oracleupk.xml showProgress contextValidated=true

      Running:

      perl /data/appl_top/apps/apps_st/comn/clone/bin/adclone.pl java=/data/appl_top/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/data/appl_top/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/data/appl_top/inst/apps/TEST_oracleupk/appl/admin/TEST_oracleupk.xml showProgress contextValidated=true

      APPS Password :

       

      Beginning application tier Apply - Thu Sep 12 15:01:20 2013

       

      /data/appl_top/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /data/appl_top/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/data/appl_top/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/data/appl_top/apps/apps_st/comn/clone/jlib/java:/data/appl_top/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/data/appl_top/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/data/appl_top/apps/apps_st/comn/clone/jlib/oui/share.jar:/data/appl_top/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/data/appl_top/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /data/appl_top/inst/apps/TEST_oracleupk/appl/admin/TEST_oracleupk.xml -stage /data/appl_top/apps/apps_st/comn/clone    -showProgress

      APPS Password : Log file located at /data/appl_top/inst/apps/TEST_oracleupk/admin/log/ApplyAppsTier_09121501.log

        -     79% completed

       

       

      ERROR while running Apply...

      Thu Sep 12 15:07:47 2013

       

      ERROR: Failed to execute /data/appl_top/apps/apps_st/comn/clone/bin/adclone.pl

       

       

      Contents of Logfile:-

      [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>

       

        [SETUP PHASE]

        AutoConfig could not successfully execute the following scripts:

          Directory: /data/appl_top/inst/apps/TEST_oracleupk/admin/install

            adgendbc.sh             INSTE8_SETUP       1

            afcpnode.sh             INSTE8_SETUP       1

            afgcsreg.sh             INSTE8_SETUP       1

            txkWfClone.sh           INSTALL_SETUP      1

       

        [PROFILE PHASE]

        AutoConfig could not successfully execute the following scripts:

          Directory: /data/appl_top/apps/tech_st/10.1.3/perl/bin/perl -I /data/appl_top/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /data/appl_top/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /data/appl_top/apps/apps_st/appl/au/12.0.0/perl -I /data/appl_top/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /data/appl_top/inst/apps/TEST_oracleupk/admin/scripts/adexecsql.pl sqlfile=/data/appl_top/inst/apps/TEST_oracleupk/admin/install

            afwebprf.sql            INSTE8_PRF         1

            amscmprf.sql            INSTE8_PRF         1

            amswebprf.sql           INSTE8_PRF         1

            bisadmprf.sql           INSTE8_PRF         1

            bisdblrp.sql            INSTE8_PRF         1

            clnadmprf.sql           INSTE8_PRF         1

            cncmprf.sql             INSTE8_PRF         1

            cseadmprf.sql           INSTE8_PRF         1

            csfadmprf.sql           INSTE8_PRF         1

            csiadmprf.sql           INSTE8_PRF         1

            eamadmprf.sql           INSTE8_PRF         1

            fteadmprf.sql           INSTE8_PRF         1

            ibywebprf.sql           INSTE8_PRF         1

            icxwebprf.sql           INSTE8_PRF         1

            oksfrmprf.sql           INSTE8_PRF         1

            wshadmprf.sql           INSTE8_PRF         1

       

          Directory: /data/appl_top/inst/apps/TEST_oracleupk/admin/install

            adadmprf.sh             INSTE8_PRF         1

            admk80ln.sh             INSTALL_PRF        1

            afadmprf.sh             INSTE8_PRF         1

            afcpctx.sh              INSTE8_PRF         1

        afcpgsm.sh          INSTE8_PRF     1
        igccmprf.sh         INSTE8_PRF     1
        jtfictx.sh          INSTE8_PRF     1
        okladmprf.sh        INSTE8_PRF     1
        txkJavaMailerCfg.sh INSTE8_PRF     1
        txkWebServicescfg.shINSTE8_PRF     1

       

        [APPLY PHASE]

        AutoConfig could not successfully execute the following scripts:

      Directory: /data/appl_top/apps/tech_st/10.1.3/perl/bin/perl -I /data/appl_top/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /data/appl_top/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /data/appl_top/apps/apps_st/appl/au/12.0.0/perl -I /data/appl_top/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /data/appl_top/inst/apps/TEST_oracleupk/admin/install
        adadmat.pl          INSTE8_APPLY   1

       

       

      AutoConfig is exiting with status 31

       

      RC-50014: Fatal: Execution of AutoConfig was failed

      Raised by oracle.apps.ad.clone.ApplyApplTop

      ERROR: AutoConfig completed with errors. Check logfile at /data/appl_top/inst/apps/TEST_oracleupk/admin/log/ApplyAppsTier_09121501.log for details.

      ApplyApplTop Completed Successfully.

       

      # Checking the status of AutoConfig run of ApplyApplTop

      Warning : AutoConfig has completed with  errors .

       

       

       

      Please help me to fix this issue, your quick response will be highly appreciated.

       

      -Thanks

      Ankur

        • 1. Re: RC-40201: Unable to connect to Database TEST while running adcfgclone.pl appsTier
          Hussein Sawwan-Oracle
          RC-40201: Unable to connect to Database TEST

           

          Please make sure that the database and the database listener are up and running -- Connect to the database remotely to verify.

           

          I assume you used the same port pool "80" when you cloned the database.

           

          Thanks,

          Hussein

          • 2. Re: RC-40201: Unable to connect to Database TEST while running adcfgclone.pl appsTier
            Ankur ...

            Thanks for replying Hussein.

            I just checked DB and DB listener both are up and running. I'm cloning on the same server.

             

            [appltst@oracleupk bin]$ ps -ef | grep tns

            root        21     2  0 May28 ?        00:00:00 [netns]

            appltst    649 24387  0 15:38 pts/3    00:00:00 grep tns

            oracle   16526     1  0 14:11 ?        00:00:00 /u01/db_top/db/tech_st/11.1.0/bin/tnslsnr PROD -inherit

            applmgr  16789     1  0 14:12 ?        00:00:00 /u01/appl_top/apps/tech_st/10.1.2/bin/tnslsnr APPS_PROD -inherit

            oratst   21808     1  0 14:27 ?        00:00:00 /data/db_top/db/tech_st/11.1.0/bin/tnslsnr TEST -inherit

            [appltst@oracleupk bin]$ ps -ef | grep smon

            appltst    651 24387  0 15:38 pts/3    00:00:00 grep smon

            oracle   16554     1  0 14:11 ?        00:00:01 ora_smon_PROD

            oratst   22466     1  0 14:28 ?        00:00:00 ora_smon_TEST


             

            I assume you used the same port pool "80" when you cloned the database.

             

            [oratst@oracleupk bin]$ perl adcfgclone.pl dbTier

             

                                 Copyright (c) 2002 Oracle Corporation

                                    Redwood Shores, California, USA

             

                                    Oracle Applications Rapid Clone

             

                                             Version 12.0.0

             

                                  adcfgclone Version 120.31.12010000.1

             

            Enter the APPS password :

             

            Running:

            /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/java:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_17650.lst -stage /data/db_top/db/tech_st/11.1.0/appsutil/clone  2> /tmp/adcfgclone_17650.err; echo $? > /tmp/adcfgclone_17650.res

             

            Log file located at /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0912142238.log

             

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

             

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

             

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

             

            Target System Database SID : TEST

             

            Target System Base Directory : /data/db_top

             

            Target System utl_file_dir Directory List : /usr/tmp

             

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

             

            Target System DATA_TOP Directory 1 [/u01/db_top/db/apps_st/data] : /data/db_top/db/apps_st/data

             

            Target System RDBMS ORACLE_HOME Directory [/data/db_top/db/tech_st/11.1.0] :

             

            Do you want to preserve the Display [null] (y/n) ? : n

             

            Target System Display [oracleupk:0.0] : oracleupk:1.0

             

            Target System Port Pool [0-99] : 70

             

            Checking the port pool 70

            done: Port Pool 70 is free

            Report file located at /data/db_top/db/tech_st/11.1.0/appsutil/temp/portpool.lst

            Complete port information available at /data/db_top/db/tech_st/11.1.0/appsutil/temp/portpool.lst

             

            Creating the new Database Context file from :

            /data/db_top/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

             

            The new database context file has been created :

              /data/db_top/db/tech_st/11.1.0/appsutil/TEST_oracleupk.xml

             

            Log file located at /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0912142238.log

            Check Clone Context logfile /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0912142238.log for details.

             

            Running Rapid Clone with command:

            perl /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/data/db_top/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/data/db_top/db/tech_st/11.1.0/appsutil/TEST_oracleupk.xml showProgress contextValidated=true

            Running:

            perl /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/data/db_top/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/data/db_top/db/tech_st/11.1.0/appsutil/TEST_oracleupk.xml showProgress contextValidated=true

            APPS Password :

             

            Beginning database tier Apply - Thu Sep 12 14:25:03 2013

             

            /data/db_top/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/data/db_top/db/tech_st/11.1.0/oui -classpath /data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc6.jar:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/java:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/oui/ewt3.jar:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/oui/srvm.jar:/data/db_top/db/tech_st/11.1.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /data/db_top/db/tech_st/11.1.0/appsutil/TEST_oracleupk.xml -stage /data/db_top/db/tech_st/11.1.0/appsutil/clone -showProgress

            APPS Password : Log file located at /data/db_top/db/tech_st/11.1.0/appsutil/log/TEST_oracleupk/ApplyDBTier_09121425.log

              | 15% completed

             

            Completed Apply...

            Thu Sep 12 14:29:51 2013

             

            Starting database listener for TEST:

            Running:

            /data/db_top/db/tech_st/11.1.0/appsutil/scripts/TEST_oracleupk/addlnctl.sh start TEST

             

            You are running addlnctl.sh version 120.1.12010000.2

             

            Logfile: /data/db_top/db/tech_st/11.1.0/appsutil/log/TEST_oracleupk/addlnctl.txt

             

            Starting listener process TEST ...

             

             

            Listener TEST has already been started.

             

             

              addlnctl.sh: exiting with status 0

            • 3. Re: RC-40201: Unable to connect to Database TEST while running adcfgclone.pl appsTier
              Hussein Sawwan-Oracle

              Checking the port pool 70

              done: Port Pool 70 is free

               

              You have used port 70 for the database tier node, so you will need to use the same port pool (70 instead of 80) when running "perl adcfgclone.pl appsTier".

               

              Thanks,

              Hussein

              • 4. Re: RC-40201: Unable to connect to Database TEST while running adcfgclone.pl appsTier
                Ankur ...

                Thanks Hussein.

                 

                Issue is fixed, I don't why I was using Port 80 while running "perl adcfgclone.pl appsTier". I will be more accurate and vigilant from next time. Thanks again

                 

                -Thanks

                Ankur