Page-2
16: What is the other script by which u can start apache other than adapcctl.sh?
A : apachectl @IAS_ORACLE_HOME/Apache/bin
17: What is the configuration file for PL/SQL listener?
A : httpd_pls.conf @IAS_ORACLE_HOME/Apache/Apache/conf
18: How to skip copy portion while applying a patch?
A : adpatch options=nocopyportion
19: How to merge patches and what type of patches can be merged?
A : admrgpch We can merge any kind of application patches, if any of the patch contain a u-driver then merged patch will contain u_merged.drv otherwise c_merged.drv, d_merged.drv and g_merged.drv
20: What is the Tiered architecture of your instance?
A : Two Tier: Web and Forms on one node and Conc, admin and report on other node.
21: How to find formserver version?
A : f60gen and press enter, it will tell u the formserver version or we can find out from the front end using help menu.
21: How to find out what are the languages enabled in u r applications?
A : Query fnd_languages
23: How to retrieve SYSADMIN password ?
A : If forgot password link is enabled and sysadmin account is configured with mail id user forget password link else you can reset sysadmin password via FNDCPASS.
24: What are the problems u have faced while starting up applications?
A : Most of the time we will encounter problem with starting up concurrent managers. Reasons , database listener may be down or FNDSM entries are wrong in tnsnames.ora of 806_ORACLE_HOME.
25: What is RRA?
A : RRA stands for Report Review Agent. RRA is nothing but FNDFS which is part of apps listener. RRA job is to pick the log/out file from the file system and show on the editor when u press view log/out button in ‘View concurrent request form’.
26: What is GSM?
A : GSM stands for Generic service Manager, which will monitor application processes like web, forms etc and restarts any of this processes if goes down.
27: What is apps listener?
A : Apps lintener is the combination of FNDFS and FNDSM. FNDSM is service manager which will monitor application services on that node when GSM:enable profile value is ‘Y’.
28: How to find the application version like 11.5.8/11.5.9….?
A : select release_name from fnd_product_groups;
29: How to confirm if Report Server is Up & Running ?
A : Report Server is started by executable rwmts60 on concurrent manager Node & this file is under
$ORACLE_HOME/bin .execute command on your server like
$ps -ef | grep rwmts60
You should get output like
applmgr ……. rwmts60 name=REP60_apps
where apps is your Instance name.
Else you can submit a request like “Active Users” with display set to PDF, check output & log file to
see if report server can display PDF files.
30: How to find the database/sqlplus version?
Ans : select banner from v$version;
No comments:
Post a Comment
Ask your Questions....