(Continued from previous part...)

What is use of Apps listener ?

Apps Listener usually running on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS and FNDSM.

How to start Apps listener ?

In Oracle 11i, you have script adalnctl.sh which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name)

How to confirm if Apps Listener is Up and Running ?

execute below command
lsnrctl status APPS_$SID (replcae SID with your Instance Name)
so If your SID is VISION then use lsnrctl status APPS_VISION out put should be like
Services Summary...
FNDFS has 1 service handler(s)
FNDSM has 1 service handler(s)

What is Web Listener ?

Web Listener is Web Server listener which is listening for web Services(HTTP) request. This listener is started by adapcctl.sh and defined by directive (Listen, Port) in httpd.conf for Web Server. When you initially type request like http://becomeappsdba.blogspot.com:80 to access application here port number 80 is Web Listener port.

How will you find Invalid Objects in database ?

using query SQLPLUS> select count(*) from dba_objects where status like 'INVALID';

How to compile Invalid Objects in database ?

You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects.

How to compile JSP in Oracle Apps ?

You can use ojspCompile.pl perl script shipped with Oracle apps to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is
perl ojspCompile.pl --compile --quiet

What is difference between ADPATCH and OPATCH ?

# ADPATCH is utility to apply oracle apps Patches whereas
# OPATCH is utility to apply database patches

Can you use both ADPATCH and OPATCH in Apps ?

Yes you have to use both in apps , for apps patches you will use ADPATCH UTILITY and for applying database patch in apps you will use opatch UTILITY.