Apps Dba

Only available on StudyMode
  • Topic: Oracle Corporation, Oracle software, Oracle Database
  • Pages : 10 (2176 words )
  • Download(s) : 355
  • Published : September 27, 2011
Open Document
Text Preview

How to confirm if Apps Listener is Up and Running ?

execute below command
lsnrctl status APPS_$SID (replcae SID with your Instance Name)

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.

How to compile JSP in Oracle Applications ?

You can use perl script shipped with Oracle Applications to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is perl --compile --quiet

What is difference between ADPATCH and OPATCH ?

# ADPATCH is utility to apply ORACLE application Patches whereas # OPATCH is utility to apply database patches

Can you use both ADPATCH and OPATCH in application ?

Yes you have to use both in application , for application patches you will use ADPATCH UTILITY and for applying database patch in application you will use opatch UTILITY.

How to start Applications listener ?

In Oracle 11i, you have script which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name)

What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?

# ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks and 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 nd does batch or single request processing.

# CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers nd 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 and Conflict resolution.

How to check if application 11i System is Autoconfig enabled ?

Under $AD_TOP/bin check for file and if this exists use contextfile= show=enabled

How to check if Oracle application 11i System is Rapid Clone enabled ? For syetem to be Rapid Clone enabled , it should be Autoconfig enabled (Check above How to confirm if application 11i is Autoconfig enabled). You should have Rapid Clone Patches applied , Rapid Clone is part of Rapid Install Product whose Family Pack Name is ADX. By default all application 11i Instances 11.5.9 and above are Autoconfig and Rapid Clone enabled.

Whats is difference between two env files in .env and APPS.env under $APPL_TOP ?

APPS.env is main environment file which inturn calls other environment files like .env under $APPL_TOP, .env under 806 ORACLE_HOME and custom

What is main concurrent Manager types.

# ICM - Internal Concurrent Manager which manages concurrent Managers # Standard Managers - Which Manage processesing of requests. # CRM - Conflict Resolution Manag

ers , resolve conflicts in case of incompatibility.

What is US directory in $AD_TOP or under various product TOP's .

US directory is defauly language directory in Oracle Applications. If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for arabic, simplifies chinese or spanish.

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.

Where would I find .rf9 file, and what it dose ?

These files are used during restart of patch in case of patch failure because of some reason.

Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored and why its used ?

This file is defined by environment variable FORMS60_WEB_CONFIG_FILE This is usually in directory...
tracking img