Oracle EBS DBA 面试题
来源:互联网 发布:淘宝店群模式 编辑:程序博客网 时间:2024/09/21 09:27
原文链接:http://rosegun38.blog.163.com/blog/static/1386494512010319101747342/
In my first post i am planning to share whith you some applicatiosn DBA querstions that i have gathered from various sources.
1.How many ORACLE HOME are Oracle Apps and whats significance of each ?
There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and On
# ORACLE_HOME 1 : On Application Tier used to store 8.0.6 techstack software. This is used by forms, reports & discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying Apps Patch.
# ORACLE_HOME 2: On Application Tier used by iAS (WebServer) techstack software. This is used by Web Listener & contains Apache.
# ORACLE_HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database.
2.What is forms server executable Name ?
f60srvm
3.Where is HTML Cache stored in Oracle Apps Server ?
Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions you might find it in $OA_HTML/_pages
4.Where is plssql cache stored in Oracle Apps ?
Usually two type of cache session & plssql stored under $IAS_ORACLE_HOME/Apache/modplsql/cache
5.What is difference between adpatch & opatch ?
# adpatch is utility to apply oracle apps Patches whereas
# opatch is utility to apply database patches in Oracle apps Database
6.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 & FNDSM.
7.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 (defined by environment variable FORMS60_WEB_CONFIG_FILE) for forms client connection used each time a user initiates forms connection.
8.What is difference between ICM, Standard Managers & CRM in Concurrent Manager ?
# ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks & try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well.
# Standard Manager These are normal managers which control/act
# CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers & request. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are actioned/assigned to CRM for Incompatibilities & Conflict resolution.
9.Where would i find .rf9 file, and what execatly it dose ?
These files are used during restart of patch in case of patch failure because of some reason.
10.What are different modes of forms in which you can start Forms Server and which on
You can start forms server in SOCKET or SERVLET by defualt Forms are configured to start in socket mode.
11.Where is Concurrent Manager log file location.
By default standard location is $APPLCSF/$APPLLOG , in some cases it can go to $FND_TOP/log as well.
12.What is .dbc file , where its stored , whats use of .dbc file ?
dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE
13.what is adident utility
adident utility in oracle apps is used to find version of any file . AD Identification.
for ex. “adident Header <filename>
14.What are main configuration files in Web Server (Apache) ?
# httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf
# jserv.conf, ssp_init.txt, jserv.properties, zone.properties
# plsql.conf, wdbsvr.app, plsql.conf
15.Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why its used ?
This file is defined by environment variable FORMS60_WEB_CONFIG_FILE This is usually in directory $OA_HTML/bin on forms tier.
This file is used by any forms client session. When a user try to access forms , f60webmx picks up this file and based on this configuration file creates a forms session to user/client.
16.Where is applications start/stop scripts stored ?
applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME
17.Whats is difference between two env files in <CONTEXT>.env and APPS<CONTEXT>.env under $APPL_TOP ?
APPS<CONTEXT>.env is main environment file which inturn calls other environment files like <CONTEXT>.env under $APPL_TOP, <CONTEXT>.env under 806 ORACLE_HOME and custom<CONTEXT>.env for any Customized environment files.
18.What is your Oracle Apps 11i Webserver Version and how to find it ?
From 11.5.8 to 11.5.10 Webserver version is iAS 1.0.2.2.2, In order to find version under $IAS_ORACLE_HOME/Apache/Apache/bin execute ./httpd -version
./httpd -version
19.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.
20.Can you run multiple sessions of ADPATCH concurrently
No
21.where can u find the applied patch details.
ad_bugs table or Applied Patches report from OAM.
22.Can you uninstall a patch.
No
- Oracle EBS DBA 面试题
- Oracle DBA面试题
- oracle DBA面试题
- Oracle DBA面试题
- oracle dba面试题
- Oracle dba 面试题
- Oracle DBA面试题
- 一份ORACLE DBA面试题
- ORACLE DBA面试题集
- Oracle DBA常见面试题
- piner 的 Oracle DBA 面试题!
- Oracle DBA面试题及参考答案
- oracle dba 面试题集锦1
- Oracle 11i EBS DBA Apps DBA
- Oracle EBS DBA培训提纲
- dba面试题
- DBA面试题1
- DBA面试题2
- Python中有关正则表达式
- HTML转义JAVA代码
- 【hdu1213】How Many Tables【并查集】
- 对话框窗口加上阴影效果
- SQL SERVER 2008 后可能不再支持本地WEB服务方式
- Oracle EBS DBA 面试题
- canny算子得实质
- android 应用程序不出现在最近打开程序列表里
- 不要再对 GPL 是否过时而争论了
- jsp的web.xml配置说明
- file域onchange事件的一些研究
- 程序安全性之配置文件安全
- (C/C++)Windows Data Type
- Qt chat1