Copied file /OPRDQC/shared/apps/apps_st/appl/au/12.0.0/resource/CUSTOM.pll from resource/CUSTOM.pll /OPRDQC/shared/apps/tech_st/10.1.2/bin/frmcmp_batch module=/OPRDQC/shared/apps/apps_st/appl/au/12.0.0/resource/CUSTOM.pll userid=apps/*********** Module_Type=library compile_all=y Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)
Mike/Murali - Patch 14279929 is not obsolete for 12.1 EBS its obsolete only for 12.0, I applied below to F12DEV3 and updated CR with instructions.
Acknowledging your last update on the Service Request.
Perform the following step and let me know what error you are getting.
Upload the screenshot of the error, if any.
Go to $AU_TOP/forms/US.
Execute the following command:
frmcmp_batch.sh userid=apps/apps module= $AU_TOP/forms/US/APXPAWKB.fmb output_file=$AP_TOP/forms/US/APXPAWKB.fmx
module_type=form batch=no compile_all=special
1. Take a backup of your current CUSTOM.pll/plx
2. Copy the CUSTOM.pll.DBA to CUSTOM.pll and CUSTOM.plx.DBA to CUSTOM.plx
3. After that, try to compile the CSFFEDBF.fmb again and let me know if you still get the exact same errors or not.
Now form compilation throwing below error while generating the form .
[OSPT1]-->frmcmp_batch.sh module=CSFFEDBF.fmb userid=apps/***** output_file=CSFFEDBF.fmx module_type=form compile_all=special
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)
Hi David/Simon,
Instead of applying patch, we changed the TNS_ADMIN and ORACLE_HOME entries in frmcmp_batch.sh as below:
ORACLE_HOME=${ORACLE_HOME:-/OSPT1/shared/apps/tech_st/10.1.2}
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
Tried re-compiling CSFFEDBF.fmb on OSPT1 and it completed with errors. Attached is the log file.
So as per Oracle SR update, performed below steps and CSFFEDBF.fmb was compiled successfully on OSPT1. Log file is attached.
Normally, the non-customized CUSTOM.pll/plx will be the one with a file size of 20480. In your case, that will be:
CUSTOM.pll.DBA
CUSTOM.plx.DBA
So, what you can do is:
1. Take a backup of your current CUSTOM.pll/plx
2. Copy the CUSTOM.pll.DBA to CUSTOM.pll and CUSTOM.plx.DBA to CUSTOM.plx
3. After that, try to compile the CSFFEDBF.fmb again and let me know if you still get the exact same errors or not.
I placed a new CUSTOM.pll.DMV and placed it into $AU_TOP/resource on OSPT1. Would you please retest using this PLL?
David Vogelsang | Acelity
Manager Application Development
a: 5751 Northwest Parkway, San Antonio TX 78249
o: 210-255-6461
e: david.vogelsang@acelity.com
w: acelity.com
We have to use frmcmp (Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But for 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.
===================================
java -Xmx2048m -jar panaya-ptl-extractor.jar w1ndm1ll /stage/patches/panaya/OPRD/25949781
7933 adpatch driver=u22297430.drv logfile=u22297430.log options=hotpatch workers=12
7934 cat /OSPT1/shared/apps/apps_st/appl/admin/OSPT1_BALANCE/log/u22297430.log | grep -i error
7935 cat /OSPT1/shared/apps/apps_st/appl/admin/OSPT1_BALANCE/log/u22297430.log | grep -i fail
7936 ospt1
Post-patch:
cd $FND_TOP/patch/115/bin/
perl ojspCompile.pl --compile --flush -p 6
flush forces recompilation of all parent JSPs
p paralell
8517 WFLOAD apps/w1ndm1ll@OSPT1 0 Y DOWNLOAD ARCMREQ.wft ARCMREQ
2090 cd cd $FND_TOP/resource
2091 cd $FND_TOP/resource
2092 ls -lrt ixlib.cfg
2093 cp -p ixlib.cfg ixlib.cfg_123_bkp
2094 vi ixlib.cfg
2095 ls -lrt pasta.cfg
2096 view pasta.cfg
2097 view ixlib.cfg
2098 cp -p ixlib.cfg ixlib.cfg_1221r
2099 cp -p pasta.cfg pasta.cfg_1221r
2100 vi ixlib.cfg
2101 ls -lrt /OPRDQC/shared/apps/apps_st/appl/fnd/12.0.0/resource/ALBANWTJ.ttf
2102 vi pasta.cfg
2103 ls -lrt /OPRDQC/shared/apps/apps_st/appl/fnd/12.0.0/resource/ADUOK.ttf
2104 sqlplus
1855 adpatch driver=u23338547.drv logfile=u23338547.log options=hotpatch workers=12
1856 cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i error
1857 cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i fail
1858 cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i warning
================================
perl ojspCompile.pl --compile --flush -p 6
8316 clear
8317 cd $INST_TOP/admin/scripts
8318 ls -ltr
8319 ./adapcctl.sh status
java -jar panaya-extractor.jar w1ndm1ll F -customJavaTop=$JAVA_TOP
=======================
Implementation Instructions: $ cd <12.1_INSTALL_DIR>/apps/tech_s
t/10.1.2/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp /stage/patches/12415211/files/
lib/stubs/libgcc_s-2.3.2-stub.
so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
$ORACLE_HOME/appsutil/clone/ad
lnktools.sh
The instructions for the 10.1.3 Oracle Home are:
$ cd <12.1_INSTALL_DIR>/apps/tech_s
t/10.1.3/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp /stage/patches /12415211/files/lib/stubs/libg
cc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
$IAS_ORACLE_HOME/appsutil/clon
e/adlnkweboh.sh
Hi
FNDSM can be sensitive when it comes to listener disconnects or time outs.
FNDSM_AMXQ05EXT01A_OPRDQC died and has no listener connection for the service.
Simplest troubleshooting to insure it is reset:
Insure the Service Manager is setup for nodeA
Bring the managers down.
Kill the FNDLIBR processes at the OS level (do a kill -9 to insure the database connection is also reset at startup)
Run the Recovery Wizard from Document 134007.1
Bring the managers up again.
If there is still an issue, then \relink the FND executables.
cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y "fnd FNDLIBR"
$ adrelink.sh force=y link_debug=y "fnd FNDCRM"
$ adrelink.sh force=y link_debug=y "fnd FNDSM"
If there is still an issue then,
Check for core.* files under $APPLCSF/$APPLLOG.
Can set ulimit -c unlimited to get core dump when the issue happens again.
Upload the core file for review.
Also upload screenshots of the Concurrent% profile setting or the instance and the listener.ora file for review to insure the entries for nodeA are valid:
Check the $ORACLE_HOME/network/admin/listener.ora
For example:
1. Make sure that both the FNDFS SID_DESC and FNDSM SID_DESC entry are present in the Listener.ora
( SID_DESC = ( SID_NAME = FNDFS )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDFS )
( envs='EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/apps/oracle/prodora/8.0.6/lib:/usr/ucblib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/apps/oracle/prodora/8.0.6/lib' )
)
( SID_DESC = ( SID_NAME = FNDSM_<dbname> )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDSM )
( envs='MYAPPSORA=/apps/oracle/prodappl/APPSORA.env,PATH=/usr/bin,FNDSM_SCRIPT=/apps/oracle/prodappl/fnd/11.5.0/bin/gsmstart.sh'))
2. If the FNDFS SID_DESC entry "envs" setting includes LD_LIBRARY_PATH, LIBPATH and/or SHLIB_PATH, shorten the envs setting to include only 1 LIBRARY reference,
or exclude all the LIB settings.
SID_LIST_APPS_PROD =
(SID_LIST =
( SID_DESC = ( SID_NAME = FNDFS )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDFS )
( envs='EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII' )
)
( SID_DESC = ( SID_NAME = FNDSM_<dbname> )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDSM )
( envs='MYAPPSORA=/apps/oracle/prodappl/APPSORA.env,PATH=/usr/bin,FNDSM_SCRIPT=/apps/oracle/prodappl/fnd/11.5.0/bin/gsmstart.sh')
)
)
If there is still an issue then patch should be applied,
Patch 17814970: INCORRECT ERROR HANDLING FOR TERMINATED REQUESTS incorrect error handling during the ICM functions of terminating requests, cleaning up dead managers, and shutting down because the requests are dying when the connection is not made.
1) Please download and review the readme for Patch 17814970: Incorrect Error Handling for Terminated Requests.
2) Please apply Patch 17814970 in a Test environment initially before application to any Production instance.
3) Please retest the issue.
4) If the issue is resolved, please migrate the solution as appropriate to other environments.
Note: I understand that you are going live and now is not an advantageous time for patching; however, the requests are dying.
Thank You
Denise
Mike/Murali - Patch 14279929 is not obsolete for 12.1 EBS its obsolete only for 12.0, I applied below to F12DEV3 and updated CR with instructions.
Acknowledging your last update on the Service Request.
Perform the following step and let me know what error you are getting.
Upload the screenshot of the error, if any.
Go to $AU_TOP/forms/US.
Execute the following command:
frmcmp_batch.sh userid=apps/apps module= $AU_TOP/forms/US/APXPAWKB.fmb output_file=$AP_TOP/forms/US/APXPAWKB.fmx
module_type=form batch=no compile_all=special
1. Take a backup of your current CUSTOM.pll/plx
2. Copy the CUSTOM.pll.DBA to CUSTOM.pll and CUSTOM.plx.DBA to CUSTOM.plx
3. After that, try to compile the CSFFEDBF.fmb again and let me know if you still get the exact same errors or not.
Now form compilation throwing below error while generating the form .
[OSPT1]-->frmcmp_batch.sh module=CSFFEDBF.fmb userid=apps/***** output_file=CSFFEDBF.fmx module_type=form compile_all=special
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)
Hi David/Simon,
Instead of applying patch, we changed the TNS_ADMIN and ORACLE_HOME entries in frmcmp_batch.sh as below:
ORACLE_HOME=${ORACLE_HOME:-/OSPT1/shared/apps/tech_st/10.1.2}
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
Tried re-compiling CSFFEDBF.fmb on OSPT1 and it completed with errors. Attached is the log file.
So as per Oracle SR update, performed below steps and CSFFEDBF.fmb was compiled successfully on OSPT1. Log file is attached.
Normally, the non-customized CUSTOM.pll/plx will be the one with a file size of 20480. In your case, that will be:
CUSTOM.pll.DBA
CUSTOM.plx.DBA
So, what you can do is:
1. Take a backup of your current CUSTOM.pll/plx
2. Copy the CUSTOM.pll.DBA to CUSTOM.pll and CUSTOM.plx.DBA to CUSTOM.plx
3. After that, try to compile the CSFFEDBF.fmb again and let me know if you still get the exact same errors or not.
I placed a new CUSTOM.pll.DMV and placed it into $AU_TOP/resource on OSPT1. Would you please retest using this PLL?
David Vogelsang | Acelity
Manager Application Development
a: 5751 Northwest Parkway, San Antonio TX 78249
o: 210-255-6461
e: david.vogelsang@acelity.com
w: acelity.com
We have to use frmcmp (Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But for 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.
===================================
java -Xmx2048m -jar panaya-ptl-extractor.jar w1ndm1ll /stage/patches/panaya/OPRD/25949781
7933 adpatch driver=u22297430.drv logfile=u22297430.log options=hotpatch workers=12
7934 cat /OSPT1/shared/apps/apps_st/appl/admin/OSPT1_BALANCE/log/u22297430.log | grep -i error
7935 cat /OSPT1/shared/apps/apps_st/appl/admin/OSPT1_BALANCE/log/u22297430.log | grep -i fail
7936 ospt1
Post-patch:
cd $FND_TOP/patch/115/bin/
perl ojspCompile.pl --compile --flush -p 6
flush forces recompilation of all parent JSPs
p paralell
8517 WFLOAD apps/w1ndm1ll@OSPT1 0 Y DOWNLOAD ARCMREQ.wft ARCMREQ
2090 cd cd $FND_TOP/resource
2091 cd $FND_TOP/resource
2092 ls -lrt ixlib.cfg
2093 cp -p ixlib.cfg ixlib.cfg_123_bkp
2094 vi ixlib.cfg
2095 ls -lrt pasta.cfg
2096 view pasta.cfg
2097 view ixlib.cfg
2098 cp -p ixlib.cfg ixlib.cfg_1221r
2099 cp -p pasta.cfg pasta.cfg_1221r
2100 vi ixlib.cfg
2101 ls -lrt /OPRDQC/shared/apps/apps_st/appl/fnd/12.0.0/resource/ALBANWTJ.ttf
2102 vi pasta.cfg
2103 ls -lrt /OPRDQC/shared/apps/apps_st/appl/fnd/12.0.0/resource/ADUOK.ttf
2104 sqlplus
1855 adpatch driver=u23338547.drv logfile=u23338547.log options=hotpatch workers=12
1856 cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i error
1857 cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i fail
1858 cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i warning
================================
perl ojspCompile.pl --compile --flush -p 6
8316 clear
8317 cd $INST_TOP/admin/scripts
8318 ls -ltr
8319 ./adapcctl.sh status
java -jar panaya-extractor.jar w1ndm1ll F -customJavaTop=$JAVA_TOP
=======================
ADRELINK
ü To
relink executables only in $AD_TOP/bin we should use adrelink.sh script
ü To
relink executables in product tops(PROD_TOP/bin) use relink application program
of adadmin
ü To
relink executables in 10.1.2 oracle home use $ORACLE_HOME/appsutil/clone/adlnktools.sh
ü To
relink executables in 10.1.3 oracle home use
$IAS_ORACLE_HOME/appsutil/clone/adlnkweboh.sh
t/10.1.2/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp /stage/patches/12415211/files/
lib/stubs/libgcc_s-2.3.2-stub.
so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
$ORACLE_HOME/appsutil/clone/ad
lnktools.sh
The instructions for the 10.1.3 Oracle Home are:
$ cd <12.1_INSTALL_DIR>/apps/tech_s
t/10.1.3/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp /stage/patches /12415211/files/lib/stubs/libg
cc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
$IAS_ORACLE_HOME/appsutil/clon
e/adlnkweboh.sh
Hi
FNDSM can be sensitive when it comes to listener disconnects or time outs.
FNDSM_AMXQ05EXT01A_OPRDQC died and has no listener connection for the service.
Simplest troubleshooting to insure it is reset:
Insure the Service Manager is setup for nodeA
Bring the managers down.
Kill the FNDLIBR processes at the OS level (do a kill -9 to insure the database connection is also reset at startup)
Run the Recovery Wizard from Document 134007.1
Bring the managers up again.
If there is still an issue, then \relink the FND executables.
cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y "fnd FNDLIBR"
$ adrelink.sh force=y link_debug=y "fnd FNDCRM"
$ adrelink.sh force=y link_debug=y "fnd FNDSM"
If there is still an issue then,
Check for core.* files under $APPLCSF/$APPLLOG.
Can set ulimit -c unlimited to get core dump when the issue happens again.
Upload the core file for review.
Also upload screenshots of the Concurrent% profile setting or the instance and the listener.ora file for review to insure the entries for nodeA are valid:
Check the $ORACLE_HOME/network/admin/listener.ora
For example:
1. Make sure that both the FNDFS SID_DESC and FNDSM SID_DESC entry are present in the Listener.ora
( SID_DESC = ( SID_NAME = FNDFS )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDFS )
( envs='EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/apps/oracle/prodora/8.0.6/lib:/usr/ucblib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/apps/oracle/prodora/8.0.6/lib' )
)
( SID_DESC = ( SID_NAME = FNDSM_<dbname> )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDSM )
( envs='MYAPPSORA=/apps/oracle/prodappl/APPSORA.env,PATH=/usr/bin,FNDSM_SCRIPT=/apps/oracle/prodappl/fnd/11.5.0/bin/gsmstart.sh'))
2. If the FNDFS SID_DESC entry "envs" setting includes LD_LIBRARY_PATH, LIBPATH and/or SHLIB_PATH, shorten the envs setting to include only 1 LIBRARY reference,
or exclude all the LIB settings.
SID_LIST_APPS_PROD =
(SID_LIST =
( SID_DESC = ( SID_NAME = FNDFS )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDFS )
( envs='EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII' )
)
( SID_DESC = ( SID_NAME = FNDSM_<dbname> )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDSM )
( envs='MYAPPSORA=/apps/oracle/prodappl/APPSORA.env,PATH=/usr/bin,FNDSM_SCRIPT=/apps/oracle/prodappl/fnd/11.5.0/bin/gsmstart.sh')
)
)
If there is still an issue then patch should be applied,
Patch 17814970: INCORRECT ERROR HANDLING FOR TERMINATED REQUESTS incorrect error handling during the ICM functions of terminating requests, cleaning up dead managers, and shutting down because the requests are dying when the connection is not made.
1) Please download and review the readme for Patch 17814970: Incorrect Error Handling for Terminated Requests.
2) Please apply Patch 17814970 in a Test environment initially before application to any Production instance.
3) Please retest the issue.
4) If the issue is resolved, please migrate the solution as appropriate to other environments.
Note: I understand that you are going live and now is not an advantageous time for patching; however, the requests are dying.
Thank You
Denise
No comments:
Post a Comment