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

Wednesday, 24 November 2010

How to check Oracle Application URL in 11i and R12 on UNIX prompt

This article will describe how to find out applications access URL in E-Business suite 11i and R12

In Applications 11i:

bash-3.00$cd $APPL_TOP/admin
bash-3.00$ pwd
bash-3.00$ ls -l *.xml

-rw-r--r-- 1 appltest dbatest 84223 Oct 2 12:54 PRODTEST_testappl.xml

bash-3.00$ cat PREPROD_testappl.xml | grep http | grep login
login_page oa_var="s_login_page"

Here URL is

In Applications R12:

bash-3.00$ cd $INST_TOP
bash-3.00$ ls
admin appltmp conf_ERPTEST.txt ora pids rgf temp
appl certs logs out portal soa
bash-3.00$ cd appl
bash-3.00$ ls
admin fnd
bash-3.00$ cd admin
bash-3.00$ ls -l
total 228
-rwxr-xr-x 1 applmgr appsdba 90899 Nov 9 12:18 ERPTEST_orasolerp.xml
-rw-r--r-- 1 applmgr appsdba 10392 Nov 9 12:10 adovars_ERPTEST_orasolerp.env
-rw------- 1 applmgr appsdba 1016 Nov 9 12:10 oamextensions.xml
-rw------- 1 applmgr appsdba 3340 Nov 9 12:10 ojspCompile.conf
-rw------- 1 applmgr appsdba 7476 Nov 9 12:10

bash-3.00$ cat ERPTEST_orasolerp.xml | grep http | grep login
login_page oa_var="s_login_page"
bash-3.00$ pwd

Here URL is

No comments: