注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

风之人生

人生如风,却无法如风般潇洒。

 
 
 

日志

 
 
关于我

一介草民,苟活于上海滩,以甲骨文为生,偶尔对一些国家大事有些兴趣,日常无事常以丝竹之声为乐。

网易考拉推荐

Oracle EBS 面试题  

2010-04-19 10:17:47|  分类: EBS |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
 

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 One in Database Tier.
# 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 (Web Server) 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/action on the requests & does batch or single request processing.
# 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 one is default ?

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

To be continued ...
  评论这张
 
阅读(2563)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017