Wednesday, August 24, 2011

Compiling JSP files automatically and manually in R12

Hi,
In R12 Application we can compile JSP files
1)Automatically or
2)Manually
Below are some useful steps to do the compilation of JSP files:

1)Automatic JSP files compilation:

Command to complie jsp files automatically has some changes compared to 11i (See metalink notes 458338.1):

2)Manual JSP files compilation:
Preparatory Step: Set the Oracle Application environment.
# su - applmgr
$ cd /oraAPP/apps/apps_st
$TEST_node1.env

We can follow below steps to compile a single jsp file (seeded or custom) in Oracle Applications 11i/R12.

1)Copy the jsp file to $COMMON_TOP/webapps/oacore/html (this location translates to $OA_HTML):

Note:We can use 'winscp' to copy the jsp file from windows to linux in a frequent manner each time.

Placing the file under $OA_HTML enables end users to access the file using the url http://hostname.domain:port/OA_HTML/[jspfile.jsp]

2)Give ownership and permission for 'applmgr'(Application file system owner) to compile jsp file.

#chown applmgr:dba /oraAPP/apps/apps_st/comn/webapps/oacore/html/test1.jsp
#chmod -R 755 /oraAPP/apps/apps_st/comn/webapps/oacore/html/test1.jsp

3) Flush and Compile the jsp file using 'applmgr' user:
# su - applmgr
$ cd $OAH_TOP/html =>location of all jsp files

-bash-3.2$ /oraAPP/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/ojspCompile.pl --compile --flush -p 2
logfile set: /oraAPP/inst/apps/VIS_kor300949v20ebs/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
loading deplist...8052
enumerating jsps...8054
updating dependency...2
parsing jsp...2
writing deplist...8053
initializing compilation:
eliminating children...5985 (-2069)
translating and compiling:
translating jsps...5985/5985 in 6m51s
compiling jsps...5985/5985 [failed: 1] in 17m11s
Finished!

Note:
Linux/Unix:
cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 2

Windows:
cd %FND_TOP%\patch\115\bin
perl -x ojspCompile.pl –compile –flush

4)Restart the Middle Tier(applications) services:

For Stopping the Middle-Tier services in R12:

-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ ./adstpall.sh
Enter the APPS username: apps

Enter the APPS password:
The logfile for this session is located at /oraAPP/inst/apps/TESTDB_TESTNODEebs/logs/appl/admin/log/adstpall.log

For Starting the Middle-Tier Services in R12:

-bash-3.2$ ./adstrtal.sh

You are running adstrtal.sh version 120.15


Enter the APPS username: apps

Enter the APPS password:
The logfile for this session is located at /oraAPP/inst/apps/TESTDB_TESTNODEebs/logs/appl/admin/log/adstrtal.log

Once the Middle-Tier services are started successfully,We have to check the URL for JSP file.

5)Verify the URL:

The URL format will be as given below:
http://hostname.domain:port/OA_HTML/[jspfile.jsp]


Hope it helps...

Happy Apps DBA learning.


Best regards,

Rafi.



1 comment:

  1. Note:To compile JSP in Oracle 11i application

    $cd $JTF_TOP/admin/scripts/
    $perl ojspCompile.pl --compile --flush

    ReplyDelete