This discussion is archived
4 Replies Latest reply: Sep 13, 2013 2:12 AM by Ankur ... RSS

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

Ankur ... Explorer
Currently Being Moderated

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 Employee ACE
    Currently Being Moderated
    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 ... Explorer
    Currently Being Moderated

    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 Employee ACE
    Currently Being Moderated

    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 ... Explorer
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points