Oracle Apps DBA

My Photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Monday, 11 June 2012

Error while running adcfgclone.pl/adautoconfig.sh afcpctx.sh INSTE8_PRF 137 ibywebprf.sh INSTE8_PRF 1

Hi All,

I've encountered this Error on Oracle E-Business suite R12.13 application on  Sun Solaris 10 64-bit sparc platform.

The below error message encountered while configuring clone on target environment (adcfgclone.pl):


[PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts: 
    Directory: /data/R12base/inst/apps/PREPROD_devdb/admin/install
      afcpctx.sh              INSTE8_PRF         137
      ibywebprf.sh            INSTE8_PRF         1 


AutoConfig is exiting with status 2



This error message is from adcfgclone logfile.  So you're also not able to proceed further ......

adcfgclone.pl is failing on two scripts "afcpctx.sh & ibywebprf.sh".   After long troubleshooting find out the culprits.

 ==> afcpctx.sh this script is failing because of missing library file

- If we run this script manually its calling fnd binary "FNDCPUCF"  from $FND_TOP/bin and find out that this binary has some missing libaries

bash-3.00$ cd $FND_TOP/bin
bash-3.00$ ldd -d FNDCPUCF         libnnz10.so =>   /data/R12base/apps/tech_st/10.1.2/lib32/libnnz10.so         libkstat.so.1 =>         /lib/libkstat.so.1         libnsl.so.1 =>   /lib/libnsl.so.1         libsocket.so.1 =>        /lib/libsocket.so.1         libgen.so.1 =>   /lib/libgen.so.1         libdl.so.1 =>    /lib/libdl.so.1         libsched.so.1 =>         /usr/lib/libsched.so.1         libaio.so.1 =>   /lib/libaio.so.1         librt.so.1 =>    /lib/librt.so.1         libm.so.1 =>     /lib/libm.so.1         libclntsh.so.10.1 =>     /data/R12base/apps/tech_st/10.1.2/lib/libclntsh.so.10.1  - wrong ELF class: ELFCLASS64         libpthread.so.1 =>       /lib/libpthread.so.1         libc.so.1 =>     /lib/libc.so.1         libmp.so.2 =>    /lib/libmp.so.2         libmd.so.1 =>    /lib/libmd.so.1         libscf.so.1 =>   /lib/libscf.so.1         libdoor.so.1 =>  /lib/libdoor.so.1         libuutil.so.1 =>         /lib/libuutil.so.1         libm.so.2 =>     /lib/libm.so.2         /platform/SUNW,Sun-Fire-V440/lib/libc_psr.so.1         /platform/SUNW,Sun-Fire-V440/lib/libmd_psr.so.1 bash-3.00$

- To solve this follow the steps


bash-3.00$ echo $ORACLE_HOME /appl/R12base/apps/tech_st/10.1.2
bash-3.00$ ln -s $ORACLE_HOME/lib/ldflags $ORACLE_HOME/lib32/ldflags
bash-3.00$ ls -ltr $ORACLE_HOME/lib32/ldflags lrwxrwxrwx   1 appclone dbaclone      45 Jun 10 13:16 /appl/R12base/apps/tech_st/10.1.2/lib32/ldflags -> /appl/R12base/apps/tech_st/10.1.2/lib/ldflags
bash-3.00$ genclntsh
bash-3.00$ relink all




- After performing all above steps again check :


bash-3.00$ cd $FND_TOP
bash-3.00$ ls
3rdparty    bin         forms       html        java        log         media       out         perl        resource    sql         xml
admin       fndenv.env  help        include     lib         mds         mesg        patch       reports     secure      usrxit
bash-3.00$ cd bin
bash-3.00$ ls
bash-3.00$ ldd -d FNDCPUCF
        libnnz10.so =>   /appl/R12base/apps/tech_st/10.1.2/lib32/libnnz10.so
        libkstat.so.1 =>         /lib/libkstat.so.1
        libnsl.so.1 =>   /lib/libnsl.so.1
        libsocket.so.1 =>        /lib/libsocket.so.1
        libgen.so.1 =>   /lib/libgen.so.1
        libdl.so.1 =>    /lib/libdl.so.1
        libsched.so.1 =>         /usr/lib/libsched.so.1
        libaio.so.1 =>   /lib/libaio.so.1
        librt.so.1 =>    /lib/librt.so.1
        libm.so.1 =>     /lib/libm.so.1
        libclntsh.so.10.1 =>     /appl/R12base/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1
        libpthread.so.1 =>       /lib/libpthread.so.1
        libc.so.1 =>     /lib/libc.so.1
        libmp.so.2 =>    /lib/libmp.so.2
        libmd.so.1 =>    /lib/libmd.so.1
        libscf.so.1 =>   /lib/libscf.so.1
        libm.so.2 =>     /lib/libm.so.2
        libdoor.so.1 =>  /lib/libdoor.so.1
        libuutil.so.1 =>         /lib/libuutil.so.1
        /platform/SUNW,Sun-Fire-V440/lib/libc_psr.so.1
        /platform/SUNW,Sun-Fire-V440/lib/libmd_psr.so.1

 -- ibywebprf.sh script is failing because its not able to connect to database:

- perform the below steps


bash-3.00$ cd $IBY_TOP/admin/template
bash-3.00$ ls
ibywebprf.cmd  ibywebprf.sh   ibywebprf.sql
bash-3.00$


- Edit ibywebprf.sql 




-  Provide direct connect string as 



--connect &user/&passwd@&db
connect APPS/APPS@preprod
-- after connect so no passwords captured
spool %s_config_home%/admin/log/ibywebprf.txt




--  After editing  both the scripts run autconfig/adcfgclone it should complete successfully without any issues

- Running autoconfig:




bash-3.00$ adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /appl/R12base/inst/apps/PREPROD_devappl/admin/log/06101319/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /appl/R12base/inst/apps/PREPROD_devappl
        Classpath                   : /appl/R12base/apps/apps_st/comn/java/lib/appsborg2.zip:/appl/R12base/apps/apps_st/comn/java/classes

        Using Context file          : /appl/R12base/inst/apps/PREPROD_devappl/appl/admin/PREPROD_devappl.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

- Running adcfgclone.pl:

bash-3.00$ perl adcfgclone.pl appsTier /appl/R12base/inst/apps/PREPROD_devappl/appl/admin/PREPROD_devappl.xml

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

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :


Running Rapid Clone with command:
perl /appl/R12base/apps/apps_st/comn/clone/bin/adclone.pl java=/appl/R12base/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/appl/R12base/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/appl/R12base/inst/apps/PREPROD_devappl/appl/admin/PREPROD_devappl.xml showProgress contextValidated=false
Running:
perl /appl/R12base/apps/apps_st/comn/clone/bin/adclone.pl java=/appl/R12base/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/appl/R12base/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/appl/R12base/inst/apps/PREPROD_devappl/appl/admin/PREPROD_devappl.xml showProgress contextValidated=false
APPS Password :

Beginning application tier Apply - Sun Jun 10 13:25:04 2012

/appl/R12base/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/oui -classpath /appl/R12base/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/appl/R12base/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/appl/R12base/apps/apps_st/comn/clone/jlib/java:/appl/R12base/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/appl/R12base/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/appl/R12base/apps/apps_st/comn/clone/jlib/oui/share.jar:/appl/R12base/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/appl/R12base/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /appl/R12base/inst/apps/PREPROD_devappl/appl/admin/PREPROD_devappl.xml -stage /appl/R12base/apps/apps_st/comn/clone    -showProgress
APPS Password : Log file located at /appl/R12base/inst/apps/PREPROD_devappl/admin/log/ApplyAppsTier_06101325.log
  |      0% completed
Log file located at /appl/R12base/inst/apps/PREPROD_devappl/admin/log/ApplyAppsTier_06101325.log
  /     73% completed

Completed Apply...
Sun Jun 10 13:32:05 2012


Do you want to startup the Application Services for PREPROD? (y/n) [y] :

Starting application Services for PREPROD:
Running:

Hope this helped you. Thanks for reading & happy troubleshooting.

regards,
Syed Zaheer





2 comments:

Hardik Shah said...

Hi Syed,

Thanks indeed for sharing the info. I have similar issue with 12.1.3 cloning from single to multinode. The adcfgclone fails on first apps tier with following error.
AutoConfig could not successfully execute the following scripts:
Directory: /u01/app/oracle/visr12/inst/apps/visr12_appsnode_new/admin/install
afcpctx.sh INSTE8_PRF 1

I have already tried virtually everything. Any suggestions ?

Regards
Hardik
http://handsonoracle.blogspot.com

Syed Zaheer said...

Hi Hardik,

Thanks for reading mt article. Please can you post the output of script by running it manually:

"/u01/app/oracle/visr12/inst/apps/visr12_appsnode_new/admin/install
afcpctx.sh"

thanks,
Syed Zaheer