Oracle Apps DBA Interview Questions part 6

41.   How to confirm if Apps Listener is Up & Running?
lsnrctl start APPS_$SID (replace SID with your Instance Name) so if your SID is VISION then use lsnrctl status APPS_VISION
42.   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 & defined by directive (Listen, Port) in httpd.conf for Web Server.
43.   How will you find total number of invalid objects in database?
SQLPLUS> select count(*) from dba_objects where status like 'INVALID';
44.   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.
45.   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
46.   What is difference between adpatch & opatch?
# adpatch is utility to apply oracle apps Patches whereas
# opatch is utility to apply database patches
47.   Can you use both adpatch & 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.
48.   Where will you find forms configuration details apart from xml file?
Forms configuration at time of startup is in script adfrmctl.sh and appsweb_$CONTEXT_NAME.cfg for forms client connection used each time a user initiates forms connection.
49.   What is forms server executable Name?
f60srvm
50.   What are different modes of forms in which you can start Forms Server and which one is default?
You can start forms server in SOCKET or SERVLET by default Forms are configured to start in socket mode.