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=<CONTEXT> 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 <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

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 $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.

What is Multi Node System ?

Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is Database, Concurrent Manager on one machine and forms, Web Server on second machine is example of Two Node System.

Can you clone from multi node system to single node system and vice versa ?

Yes , this is now supported via Rapid Clone, Check if your system has all prereq. patches for Rapid Clone and you are on latest rapid clone patch.

Does rapid clone takes care of Updating Global oraInventory or you have to register manually in Global OraInventory after clone ?

Rapid Clone will automatically Update Global oraInventory during configuration phase. You don’t have to do any thing manually for Global oraInventory.

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

What are things you do to reduce patch timing ?

You can take advantage of following –
# Merging patches via admrgpch
# Use various adpatch options like nocompiledb or nocompilejsp
# Use defaults file
# Staged APPL_TOP during upgrades
# Increase batch size (Might result into negative )

How you put Applications 11i in Maintenance mode ?

Use adadmin to change Maintenance mode is Oracle application. With AD.I you need to enable maintenance mode in order to apply application patch via adpatch utility. If you don’t want to put application in maintenance mode you can use adpatch options=hotpatch feature.

Can you apply patch without putting Applications 11i in Maintenance mode ?

Yes, use options=hotpatch as mentioned above with adpatch.

What are various options available with adpatch ?

Various options available with adpatch depending on your AD version are autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate

ADIDENT UTILITY is used for what ?

ADIDENT UTILITY in ORACLE application is used to find version of any file . AD Identification. for ex. “adident Header <filename>

What is iAS Patch ?

iAS Patch are patches released to fix bugs associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shiiped as Shell scripts and you apply iAS patches by executing Shell script. Note that by default ORACLE_HOME is pointing to 8.0.6 ORACLE_HOME and if you are applying iAS patch export ORACLE_HOME to iAS . You can do same by executing environment file under $IAS_ORACLE_HOME

If we run autoconfig which files will get effected ?

In order to check list of files changes during Autoconfig , you can run adchkcfg utility which will generate HTML report. This report will list all files and profile options going to change when you run AutoConfig.

What is difference between .xml file and AutoConfig ?

Autoconfig is Utility to configure your Oracle Application environment. .xml file is repository of all configuration from which AutoConfig picks configuration and polulates related files

What is .lgi files ?

lgi files are created with patching along with .log files . .lgi files are informative log files containing information related to patch. You can check .lgi files to see what activities patch has done. Usually informative logs.

How will you skip worker during patch ?

If in your adctrl there are six option shown then seventh is hidden option.(If there are seven options visible then 8th option is to Skip worker depending on ad version).

Which two tables created at start of application Patch and drops at end of Patch ?

FND_INSTALLED_PROCESS and AD_DEFFERED_JOBS are the tables that get updated while applying a patch mainly d or unified driver.

How to compile an Oracle Reports file ?

Utility adrepgen is used to compile Reports. Synatx is given below adrepgen userid=apps<psswd> source = $PRODUCT_TOPsrwfilename.rdf dest=$PRODUCT_TOPsrwfilename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character

What is difference between AD_BUGS and AD_APPLID_PATCHES ?

AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.

AD_APPLIED_PATCHES holds information about the “distinct” Oracle Applications patches that have been applied. If 2 patches happen to have the same name but are different in content (eg. “merged” patches), then they are considered distinct and this table will therefore hold 2 records.


ADSPLICE UTILITY in ORACLE application is utility to add a new product.

What is MRC ? What you do as application DBA for MRC ?

MRC also called as Multiple Reporting Currency in oracle application. Default you have currency in US Dollars but if your organization operating books are in other currency then you as application DBA need to enable MRC in applications.

What is access_log in apache , what entries are recored in access_log ? Where is default location of this file ?

access_log in Oracle Application Server records all users accessing oracle applications 11i. This file location is defined in httpd.conf with default location at $IAS_ORACLE_HOME/Apache/Apache/logs. Entries in this file is defined by directive LogFormat in httpd.conf Typical entry in access_log is – –

[10/Sep/2006:18:37:17 +0100] “POST /OA_HTML/OA.jsp?…. HTTP/1.1” 200 28035

Where is applications start/stop scripts stored ?

applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME

What are main configuration files in Web Server (Apache) ?

Main configuration files in Oracle application Web Server are
# httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf
# jserv.conf, ssp_init.txt,,
# plsql.conf,, plsql.conf

Can C driver in application patch create Invalid Object in database ?

No , C driver only copies files in File System. Database Object might be invalidated during D driver when these objects are created/dropped/modified.

What is dev60cgi and f60cgi ?

CGI stands for Common Gateway Interface and these are Script Alias in Oracle application used to access forms server . Usually Form Server access directly via http://hostname:port/dev60cgi/f60cgi

Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ?

Apps Patch worker can fail in case it doesn’t find expected data, object, files or any thing which driver is trying to update/edit/modify. Possible symptoms may be underlying tables/objects are invalid, a prereq patch is missing , login information is incorrect, inconsistency in seeded data…

What is FNDSM ?

FNDSM is executable and core component in GSM ( Generic Service Management Framework discussed above). You start FNDSM services via application listener on all Nodes in Application Tier in E-Business Suite.

Whats is location of access_log file ?

access_log file by default is located in $IAS_ORACLE_HOME/ Apache/Apache/logs. Location of this file is defined in httpd.conf by patameter CustomLog or TransferLog

What is your Oracle application 11i Webserver Version and how to find it ?

From 11.5.8 to 11.5.10 Webserver version is iAS, In order to find version under $IAS_ORACLE_HOME/Apache/Apache/bin execute ./httpd -version
./httpd -version

What is Location of Jserv configuration files ?

Jserv configuration files are located in $IAS_ORACLE_HOME /Apache/Jserv/etc .

What is plssql/database cache ?

In order to improve performance mod_pls (Apache component) caches some database content to file. This database/plssql cache is usually of type session and plsql cache
# session cache is used to store session information.
# plsql cache is used to store plsql cache i.e. used by mod_pls

Where is DATABASE/PLSSQL cache stored ?

PLSSQL and session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory.

What is content of DBC file and why its important ?

DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses DBC file. Typical entry in DBC file is

How to retrieve SYSADMIN password ?

If forgot password link is enabled and SYSADMIN account is configured with mail id user forget password link else you can reset sSYSADMIN password via FNDCPASS.

What is GWYUID ?

GWYUID , stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB

Where GWYUID defined and what is its used in Oracle Applications ?

GWYUID is defined in dbc i.e. Database Connect Descriptor file . It is used to connect to database by think clients.

If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?

For products like Payable, Recievables which uses MRC and if MRC is enabled then each transaction table in base schema related to currency now has an assoicated MRC Subtables.

When you apply C driver patch does it require database to be Up and Why ?

Yes , database and db listener should be Up when you apply any driver patch in application. even if driver is not updating any database object connection is required to validate application and other schema and to upload patch history information in database tables.

How to confirm if Report Server is Up and Running ?

Report Server is started by executable rwmts60 on concurrent manager Node and this file is under $ORACLE_HOME/bin .execute command on your server like
ps -ef | grep rwmts60