TechExuberance

Introduction – Seasoned DBAs are already aware about architectural changes in 11i, r12 and r12.2. Likewise, there are some significant changes when you compile jsp pages in these versions. This article will cover important aspects when performing same action in different versions. We will start with 11i until r12.2 followed by a summary on differences and similarities. JSP Cache -           It is compiled version of JSP files. -           They have extension .class. -           They are stored in folder - _pages. Compilation process of jsp file JSP file ---conversion---> .java file ---compilation---> .class file Differences when storing compiled .class files In 11i, Apache JServe was responsible to compile jsp and convert the same into .class file while in r12, we have oc4j handling jsps. Default location...

Before you start compiling jsps and following below steps, I recommend understanding some key differences between 11i, r12.1 and r12.2 when it comes to compiling jsps. Please follow below link and then proceed further - One-stop shop to Compile JSPs in 11i, r12.1 and r12.2 1. Take a backup of _pages directory that will be modified due to jsp compilation - $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/ $ cp -R _pages _pages29dec2019 $ ls -ld _pages* drwxr-xr-x 5 applmgr oinstall 249856 Dec 29 16:36 _pages drwxr-xr-x 5 applmgr oinstall 249856 Dec 29 16:56 _pages29dec2019 2. Stop apache, oacore and oafm services - adapcctl.sh stop admanagedsrvctl.sh stop oacore_server1 admanagedsrvctl.sh stop oafm_server1 3. Compile the jsps manually using the below command - $ cd $FND_TOP/patch/115/bin/ $ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p              4. Check class file last mo...

1. Take a backup of .class file that will be modified due to jsp compilation - $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages Unlike r12.1, there is a different naming convention here in r12.2 with additional '_' being prefixed like as follows – $ ls -ltr _jtffmxrg.class ls: cannot access _jtffmxrg.class: No such file or directory $ ls -ltr __jtffmxrg.class -rw-r--r-- 1 applmgr oinstall 69675 Sep 16 19:13 __jtffmxrg.class Also, all .class files are in lower-case while in earlier r12.1, they were same filenames with simply an '_' prefixed. Example – In r12.1 $ ls -ltr *OA.class* -rw-r--r-- 1 applprod proddba 8843 Dec 29 11:32 _OA.class In r12.2 $ ls -ltr *OA.class* ls: cannot access *OA.class*: No such file or directory $ ls -ltr *oa.class* -rw-r--r-- 1 applmgr oinstall 10123 Sep 16 19:13 __oa.class -rw-r--r-- 1 applmgr oinstall 12874 Sep 16 19:13 __jtfwtpoa.class 2. Check for last compilation time for .class...

1. Take a backup of _pages directory that will be modified due to jsp compilation - $ cd $COMMON_TOP/ $ cp -R _pages _pages23dec2019 $ ls -ld _pages* drwxr-xr-x 5 applprod proddba 405504 Dec 23 09:13 _pages drwxr-xr-x 5 applprod proddba 405504 Dec 29 11:28 _pages29dec20192 2. Stop application opmn services - ./adopmnctl.sh stopall 3. Compile the jsps manually using the below command - $ cd $FND_TOP/patch/115/bin/ $ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 4             4. Check class file last modification date as follows - $ cd $COMMON_TOP/_pages $ ls -ltr | tail -rw-r--r-- 1 applprod proddba   77656 Dec 29 11:33 _bisalrta.class -rw-r--r-- 1 applprod proddba   47949 Dec 29 11:33 _bicsbadd.class -rw-r--r-- 1 applprod proddba 107558 Dec 29 11:33 _asfAdminCalTypesMain.class -rw-r--r-- 1 applprod proddba   41983 Dec 29 11:33 _amsStratDtailFrm.class -rw-r--r-- 1 a...

1. Take a backup of .class file that will be modified due to jsp compilation - $ cd $COMMON_TOP/_pages $ ls -ltr _jtffmxrg.class $ cp _jtffmxrg.class _jtffmxrg.class23dec2019 2. Check for last compilation time for .class file as follows - $ cd $COMMON_TOP/_pages $ ls -ltr _jtffmxrg.class 3. Your JSP file that will be compiled is stored under location - $ cd $COMMON_TOP/webapps/oacore/html $ ls -ltr jtffmxrg.jsp Please note that above file will be used as reference to generate class(_jtffmxrg.class) file under - $COMMON_TOP/_pages 4.To compile JSP file, perl utility - ojspCompile.pl is located under - $FND_TOP/patch/115/bin/ ojspCompile.pl uses "-s" option to compile single jsp. $ cd $FND_TOP/patch/115/bin/ $ perl -x $JTF_TOP/admin/scripts/ojspCompile.pl --compile -s jtffmxrg.jsp 5. Check class file last modification date as follows - $ cd $COMMON_TOP/_pages/ $ ls -ltr _jtffmxrg.class -rw-r--r-- 1 applprod proddba 68390 ...

1. Take a backup of _pages directory that will be modified due to jsp compilation - $ cd $COMMON_TOP/ $ cp -R _pages _pages23dec2019 $ ls -ld _pages* 2. Stop application opmn services - ./adapcctl.sh stop 2.Compile the jsps manually using the below command - $ cd $JTF_TOP/admin/scripts $ perl $JTF_TOP/admin/scripts/ojspCompile.pl --compile --flush -p 4         3. Check class file last modification date as follows - $ cd $COMMON_TOP/_pages $ ls -ltr | tail 4. Start apache - ./adapcctl.sh start 5. Clear your web browser cache

1. Take a backup of .class file that will be modified due to jsp compilation - $ cd $COMMON_TOP/_pages/_oa__html/ $ ls -ltr _jtffmxrg.class $ cp _jtffmxrg.class _jtffmxrg.class23dec2019 2. Check for last compilation time for .class file as follows - $ cd $COMMON_TOP/_pages/_oa__html/ $ ls -ltr _jtffmxrg.class 2. Your JSP file that will be compiled is stored under location - $ $COMMON_TOP/html $ ls -ltr jtffmxrg.jsp Please note that above file will be used as reference to generate class(_jtffmxrg.class) file under - $COMMON_TOP/_pages/_oa__html/ 2.To compile JSP file, perl utility - ojspCompile.pl is located under - $JTF_TOP/admin/scripts ojspCompile.pl uses "-s" option to compile single jsp. $ cd $JTF_TOP/admin/scripts $ perl -x $JTF_TOP/admin/scripts/ojspCompile.pl --compile -s jtffmxrg.jsp 3. Check class file last modification date as follows - $ cd $COMMON_TOP/_pages/_oa__html/ $ ls -ltr _jtffmxrg.class -rw-r--r-- 1 ...

This blog is about my experience so far with below 2 world’s largest interactive community dedicated to Oracle technologies so far, 1. My Oracle Support Community 2. OTN community You can simply register yourself using below link – https://community.oracle.com It is hard to decide which one is my favorite out of the two. I believe it is more about purpose of these two communities and differences that makes nerds like us to choose between the two or follow both. Understanding the difference- OTN: Available for everyone MOSC: Only accessible with My Oracle Support access. OTN: Possibly larger audience, but not the place to discuss MOS notes or SRs, since you can't assume that everyone accessing an OTN community also has MOS access. Basically, both communities are managed by different teams. OTN space is open and visible to anyone. Anyone can create an OTN account. MOSC spaces are available to only those who have a valid support contract. You nee...