24.08.2019-673 views -Apps Dba
ORACLE Software DBA
How to confirm if Apps Audience is Up and Running?
perform below command
lsnrctl status APPS_$SID (replcae SID with your Instance Name)
How to make Invalid Items in databases?
You can use adadmin utility to compile or else you can use utlrp. sql script shipped with Oracle Repository to put together Invalid Databases Objects.
The right way to compile JSP in Oracle Applications?
You can use ojspCompile. pl perl software shipped with Oracle Applications to compile JSP data files. This script is beneath $JTF_TOP/admin/scripts. Test compilation method is perl ojspCompile. pl --compile --quiet
What is difference among ADPATCH and OPATCH?
# ADPATCH is utility to use ORACLE app Patches although # OPATCH is energy to apply data source patches
Can you use both ADPATCH and OPATCH in app?
Yes you have to use both in application, intended for application patches you will make use of ADPATCH UTILITY and for applying database spot in application you will make use of opatch ELECTRICITY.
How to start Applications listener?
In Oracle 11i, you have script adalnctl. sh which will start your apps listener. You can also start this by command lsnrctl commence APPS_$SID (Replace sid from your Instance SID Name)
Precisely what is difference among ICM, Common Managers and CRM in Concurrent Manager?
# ICM stand for Interior Concurrent Administrator, which settings other managers. If it discovers other managers down, it checks trying to restart these people. You can say it while administrator to other contingency managers. It includes other tasks as well. # Standard Director These are typical managers which control/action for the requests nd does set or solitary request control.
# CRM acronym intended for Conflict Resolution Supervisor is used to solve conflicts among managers nd request. If a request is submitted whose execution is definitely clashing another problem is that it can often be defined to not run although a particular form of request is definitely running after that such asks for are actioned/assigned to CUSTOMER RELATIONSHIP MANAGEMENT for Incompatibilities and Resolve conflicts.
How to check if application 11i System is Autoconfig enabled?
Below $AD_TOP/bin search for file adcfginfo. sh of course, if this is out there use adcfginfo. sh contextfile= show=enabled
How you can check if Oracle application 11i System is Speedy Clone allowed? For syetem to be Quick Clone allowed, it should be Autoconfig enabled (Check above Tips on how to confirm in the event application 11i is Autoconfig enabled). You ought to have Rapid Identical copy Patches used, Rapid Identical copy is a part of Rapid Mount Product whose Family Packs Name is usually ADX. By default all program 11i Occasions 11. a few. 9 and above will be Autoconfig and Rapid Identical copy enabled.
What is is difference between two env documents in. env and SOFTWARE. env underneath $APPL_TOP?
SOFTWARE. env is usually main environment file which inturn calls other environment files like. env below $APPL_TOP,. env under 806 ORACLE_HOME and custom
Precisely what is main contingency Manager types.
# ICM - Inside Concurrent Supervisor which manages concurrent Managers # Normal Managers -- Which Control processesing of requests. # CRM - Conflict Resolution Manag
ers, solve conflicts in case of incompatibility.
What is US directory in $AD_TOP or underneath various merchandise TOP's.
US directory is usually defauly terminology 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 certainly contain reports, fmx and also other code in this respective listing like FR for France, AR for arabic, makes simple chinese or spanish.
Wherever is Concurrent Manager journal file site.
By default normal location is definitely $APPLCSF/$APPLLOG, in some instances it can go to $FND_TOP/log too.
Where might I find. rf9 document, and what dose?
These types of files are used during restart of patch in case of spot failure as a result of some purpose.
Where can be appsweb. cfg or appsweb_$CONTEXT. cfg placed and for what reason its utilized?
This data file is defined by environment variable FORMS60_WEB_CONFIG_FILE This is usually in directory...