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





4 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

Aditya .......cheers every one said...

Hello Zaheer,

ibywebprf.sh script is failing after changing the password manually in ibywebprf.sql and running the adautocfg.sh.

Still showing the error:
AutoConfig could not successfully execute the following scripts:
Directory: /delphi/applmgr/nfps/nfpscomn/admin/install/NFPS_finfprod2
ibywebprf.sh INSTE8_PRF 1


AutoConfig is exiting with status 1

Please confirm do we need to set anything else?

Thanks in Advance,

Regards,
Adithya

Rehan said...

i have converted R12.1.1 Single instance database to 11g RAC .

database is up and i converted database from Single instance to RAC with RMAN.

autoconfig ran succesfully on both db nodes.




while im running autoconfig on appsnode im getting the following error :



these are the errors im getting in my adconfig logfile :



Start of method: ContextValueMgmt
ERRORCODE = 1 ERRORCODE_END
.end std out.
*******FATAL ERROR*******
PROGRAM : (/u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl)
TIME : Fri Jun 10 10:55:41 2016
FUNCTION: [ Level 1 ]
ERRORMSG: *******FATAL ERROR*******
PROGRAM : (/u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl)
TIME : Fri Jun 10 10:55:41 2016
FUNCTION: TXK::Process::run [ Level 3 ]
MESSAGES:
No create access for /TXK/java_ver.txt




STACK TRACE
TXK::Error::abort('TXK::Error','HASH(0x91cc7c0)') called at /u01/app/oracle/ebsR12/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::Process=HASH(0x95fd1c4)','No create access for /TXK/java_ver.txt','undef') called at /u01/app/oracle/ebsR12/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::Process=HASH(0x95fd1c4)','No create access for /TXK/java_ver.txt') called at /u01/app/oracle/ebsR12/apps/apps_st/appl/au/12.0.0/perl/TXK/Process.pm line 342
TXK::Process::run('TXK::Process=HASH(0x95fd1c4)','HASH(0x96b5348)') called at /u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl line 275
main::getJavaVersion() called at /u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl line 226
main::checkAPPSVersion() called at /u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl line 716
main::ContextValueMgmt() called at /u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl line 103
eval {...} called at /u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl line 84




STACK TRACE
TXK::Error::printMsg('TXK::Error','*******FATAL ERROR*******\x{a}PROGRAM : (/u01/app/oracle/ebsR12/a...') called at /u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl line 114


.end err out.




Result : FAILED
===========================================================================
===========================================================================
[ Config tool : /u01/app/oracle/ebsR12/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl ]
Command : /u01/app/oracle/ebsR12/apps/tech_st/10.1.3/perl/bin/perl -I /u01/app/oracle/ebsR12/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /u01/app/oracle/ebsR12/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /u01/app/oracle/ebsR12/apps/apps_st/appl/au/12.0.0/perl -I /u01/app/oracle/ebsR12/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /u01/app/oracle/ebsR12/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl PASSWORD contextfile=/u01/app/oracle/ebsR12/inst/apps/LABDB_appsnode/appl/admin/LABDB_appsnode.xml logdir=/u01/app/oracle/ebsR12/inst/apps/LABDB_appsnode/admin/log/06101055 outdir=/u01/app/oracle/ebsR12/inst/apps/LABDB_appsnode/admin/out/06101055
Action : execute


[CVM Error Report]
The following report lists errors encountered during CVM Phase

/u01/app/oracle/ebsR12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl 1

No of scripts failed in CVM phase: 1

AutoConfig is exiting with status 1