If you want to submit any Interview question for Apps DBA
which might be helpful for other's to understand applications & Interviews
Mail Me.
Q. How to confirm if Apps Listener is Up & 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)
The command completed successfully
Q. 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. When you initially type request like
http://becomeappsdba.blogspot.com:80 to access application here port number 80 is Web Listener port.
Q. How will you find Invalid Objects in database ?
using query
SQLPLUS> select count(*) from dba_objects where status like 'INVALID';
Q. 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.
Q. 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
|
Previous Page
|
Next Page
|