How can you licence a product after installation ? You can use ad utility adlicmgr to licence product in Oracle Apps.  ...

What is adsplice utility ? adsplice in oracle apps is utility to add a new product....

Can you apply patch without putting Applications 11i in Maintenance mode ? Yes, use options=hotpatch as mentioned above with adpatch....

 Important Tables For ADPATCH :AD_APPL_TOPS AD_APPLIED_PATCHES AD_BUGS AD_PATCH_DRIVERS AD_FILE_VERSIONS AD_FILES AD_PATCH_DRIVER_LANGS AD_PATCH_DRIVER_MINIPKS AD_PATCH_RUN_BUG_ACTIONS AD_PATCH_RUN_BUGS AD_PATCH_RUNS AD_RELEASES AD_PATCH_COMMON_ACTIONS...

How you put Applications 11i in Maintenance mode ? [applmgr@srvr33 appltop]$ . APPSdb4_srvr33.env [applmgr@srvr33 appltop]$ adadmin  AD Administration Main Menu  --------------------------------------------------    1.    Generate Applications Files menu    2.    Maintain Applications Files menu    3.    Compile/Reload Applications Database Entities menu    4.    Maintain Applications Database Entities menu    5.    Change Maintenance Mode    6.    Exit AD Administration Enter your choice [6] : 5 Change Maintenance Mode    ---------------------------------------- Maintenance...

How to find log files locations in 11i and R12 The following log files location could help you to find-out issues and errors from your application 11i instance. Database Tier Logs are Alert Log File location: $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Trace file location: $ORACLE_HOME/admin/SID_Hostname/udump Application Tier Logs Start/Stop script log files location: $COMMON_TOP/admin/log/CONTEXT_NAME/ OPMN log file location $ORACLE_HOME/opmn/logs/ipm.log Apache, Jserv, JVM log files locations: $IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log $IAS_ORACLE_HOME/Apache/Apache/logs/ssl_request_log $IAS_ORACLE_HOME/Apache/Apache/logs/access_log $IAS_ORACLE_HOME/Apache/Apache/logs/error_log $IAS_ORACLE_HOME/Apache/JServ/logs Concurrent...

What is the Location of Autoconfig  logfile ? Autoconfig log files will be stored in this directory$APPL_TOP/admin/$CONTEXTFILE/<timestamp>/log/adconfig.log.log Eg: $APPL_TOP/admin/SID_Hostname/log//DDMMTime/adconfig....

Can C driver in apps 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/modifi...

When you apply C driver patch does it require database to be Up & Why ? Yes , database & db listener should be Up when you apply any driver patch in apps. even if driver is not updating any database object connection is required to validate apps & other schema and to upload patch history information in database tabl...

What are the AutoPatch Restart files? Restart files store information about completed processing in the event of a patch or system failure. They allow AutoPatch, AutoUpgrade, and AD Administration to continue processing at the point where they stopped. Its location is $APPL_TOP/admin/<SID>/rest...

How do you know the product versions, patchset levels? $AD_TOP/sql/ adutconf. lst (or) Query PRODUCT_COMPONENT_ VERSION tabl...

What is the use of the InterOperability Patch? We apply this patch for the compatability between OS and Orac...

what is the Location of Patch History files? $APPL_TOP/admin/ SID/javaupdates<timestamp>.txt (for java related files) $APPL_TOP/admin/ SID/adpsv<timestamp>.txt (non-java related files...

How do you find out which drivers have been applied? From the following query you can find the applied dtriver name Query the ad_patch_driver...

While applying the Apps patch using adpatch, if you want to hide the apps password, how will that be possible? Use adpatch flags=hidepw while applying patches in apps to hide apps or system password being displayed on Users Scre...

What do you do if the patch fails? Review log file(s) to determine the cause of the error Fix the cause of the error Restart adpatch when adpatch asks if you want to continue the previous session Adpatch will skip already completed jobs, and pick up from where it left off...

Where to find the adpatch log files ? Patch log files will be stored in this directory $APPL_TOP/admin/$SID/log like adpatchXXX....

How to check if a patch is applied or not ? Patch information in 11i is stored in AD_BUGS & AD_APPLIED_PATCHES table . You can query like: SQL> select bug_number from AD_BUGS where bug_number =’&patch_no’; Alternatively you can check patch information from OAM (Oracle Application Manager...

Modes of the Patching? Test mode (apply=n), With the Test mode, we can see the effects applying the patch will have on your system before applying the patch. Pre-install mode (preinstall= y), Pre-install mode of Autopatch is used when the version of Oracle Applications AutoPatch works with is different than the version of Oracle Applications in the database. We use this mode during upgrade process. Non-interactive mode (adpatch defaultsfile= $APPL_TOP/ admin/<SID>/log...

What are the drivers present in patching? C driver copies the files and links executables D driver runs the SQL scripts and programs that updates the database G driver generates the forms, reports and message files U driver is a consolidated driver containing all copy, database, and generate file...

Contents of a Patch? Readme files Driver files Metadata files Replacement file...

Naming conventions of Oracle Apps Patches? Minipack naming convention? 11i.<prod>.A, 11i.<prod>.B For example: 11i.AD.G, 11i.AD.H Maintenance pack naming convention? 11.5.1, 11.5.2, 11.5.3 Family pack naming convention? 11i.<prod family name>.<letter> For example: 11i.HR_PF...

RMAN Cross check Commands Crosscheck is needed when an archivelog or file is manually removed i.e., not deleted by RMAN.  This command ensures the data about backups in recovery catalog or controlfile is synchronized with corresponding data on disk The crosscheck command does not delete any file that is unable to find out, but updates their repository records to expired Use the crosscheck command to synchronize the physical reality of backups and copies with their logical records in the RMAN repository For example             RMAN> crosscheck backupset 326;                        You will get O/P as backup piece found...

Validate Commands for RMAN  The validate commands helps you ensure that the backed-up files exist in the proper location and they are readable and free from any logical and physical corruption for exampme             RMAN> validate backupset 9                         The following command doesn’t restore any data files.  It only validates the contents of the backup sets are restorable              RMAN> run {                                     Allocate channel d1 type disk;    ...

Reports commands for RMAN  Use the report commands to answer for the following questionwhich files need a backup? which files or backups are obsolete and can be deleted which files have not been backed up recently and etc….  if you have retention policy configured, then you can just run report need backup to determine which files need backups             RMAN> report need backupTo report the database structure at a specified point in time              RMAN> report schema Which backup can be delete (obsolete)                ...

RMAN List commands The primary purpose of list command is to determine which backups or copies are availableTo list backup sets, backup pieces and proxy copies              RMAN> list backup To list backups by file              RMAN> list backup by file To list backups in summary mode              RMAN> list backup summary To list backups of all files in database              RMAN> list backup of database; To list copy of specified datafile              ...

RMAN-Show commands  To show all RMAN configuration settings               RMAN> show all; To show retention policy configuration settings               RMAN> show retention policy To show the automatic channel settings               RMAN> show channel To show the default device type              RMAN> show default device type To show the number of identical copies of each backup             ...

Steps for RMAN CLONING Step – 1  Create a new init.ora(parameter file) file for the auxiliary database.  Create physical directories like udump, cdump, bdump.  If your target db datafiles and log files directories are different from source then mention following converters in parameter file              . DB_file_name_convert             . LOG_file_name_convert  Step – 2  Start the auxiliary db instance in nomount stage.  Target should be in mount or open stage              Sql> startup nomount  Step – 3  Create network files.  Create listener at auxiliary side and tns...

Analyzing the Oracle Apps 11i JVM logs  In order to analyze Oracle apps 11i JVM, lets open stdout file for one of Group, I have selected OACoreGroup here,  log file ($IAS_ORACLE_HOME/Apache/Jserv/logs/jvm), open file like OACoreGroup.X.stdout you should see output like below if GC(Grabage Collector) is set in Verbose mode. 48561.624: [GC 325980K->170382K(519168K), 0.2751056 secs] 49307.880: [GC 334862K->179171K(519168K), 0.2660486 secs] 50236.662: [GC 343651K->187797K(519168K), 0.2518720 secs] 50515.494: [Full GC[Unloading class sun. reflect. Generated Method Accessor 143] [Unloading class sun. reflect. GeneratedMethodAccessor136] [Unloading class sun. reflect. GeneratedMethodAccessor74] Here first...

Where to find the Apps 11i JVM logs ? JVM log location is defined in java.sh ( found in $IAS_ORACLE_HOME/Apache/Apache/bin) Oracle Apps 11i JVM log file directory is defined by parameter JVMLOGDIR ( $IAS_ORACLE_HOME/Apache/Jserv/logs/jvm ) and log file are defined by STDOUTLOG & STDERRLOG. Example of JVM log files are     OACoreGroup.0.stderr ,OACoreGroup.0.stdout, DiscoGroup.0.stdout, DiscoGroup.0.stderr, XmlSvcsGrp.0.stderr, XmlSvcsGrp.0.stdout - where 0 denotes first JVM & if  1 denotes second JVM. stderr records error encountered in JVM & stdout records other information like GC(Gargbage Collecter...

How to increase the No. Of JVM’s Since you know the place where number of JVM’s are stored in Apps 11i in Context File , so you can change them as per your requirement. There are basically following Groups with their own JVM’s.     OACoreGroup, where most of Java request goes     DiscoGroup, which serve your Discoverer related requests     FormsGroup, for Forms (If they are running in Servlet Mode, confirm it again)     XmlSvcsGroup, for XML Services In Context File disco_nprocs oa_var=”s_disco_nprocs” osd=”Solaris” 1 /disco_nprocs Sets 1 JVM Process for Discoverer. oacore_nprocs oa_var=”s_oacore_nprocs” 1 /oacore_nprocs Sets 1 JVM for for OACoreGroup Similarly , s_forms_servlet_nprocs...

How & Where to check JVM related configuration in Oracle Apps 11i? Open CONTEXT file under $APPL_TOP/admin (xml file) which is of pattern $SID_$HOSTNAME.xml There are two important lines in CONTEXT file which will help you in understanding JVM     . jvm_options oa_var=”s_jvm_options” osd=”Solaris” -verbose:gc -Xmx512M -Xms128M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB /jvm_options - Verbose:gc means JVM is configured to print output when gc(Garbage Collector) runs. - Xmx is maximum memory allocated to JVM in above example its 512 MB. - Xms is JVM will start with this much memory i.e. 128 MB.  Now Check another line in 11i Context file like     oacore_nprocs...

What is JVM ?  JVM acronym for Java Virtual Machine which executes instructions generated by Java compiler . So user click on any Self Service Request or any program which uses Java, then Apache forwards this request to mod_jserv (mod_oc4j in 10g AS) & mod_jserv caters this request with help of J...

What is *.dbc file and what is the location of dbc file ?  DBC as name stands for is database connect descriptor file used to connect to database. DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses DBC file. This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory. Typical entry in DBC file is: GUEST_USER_PWD APPS_JDBC_URL DB_HO...

Whats is the 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 TransferL...

What is the 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...

What are the restart files? and its location?  These files contains the previous session info about AD utilities like... adadmin.. Location is $APPL_TOP\admin\sid\restart\*....

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

Where is  appsweb.cfg or appsweb_$CONTEXT.cfg files are stored and why it’s 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/clien...

What are things you do to reduce the patch timing? To Reduce the Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch   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 ) Reduce the Patching Downtime in Oracle Applications Following are the various ways to reduce Oracle Application patching downtime. 1. Consolidate Patches Using AD Merge Patch to merge multiple patches into a single patch that eliminates the time it takes to start a new AutoPatch session. 2. Apply Patches in Non-interactive Mode You...

Activate extended SQL trace for a given session  Enable extended SQL trace since they had already found the session id. Here are the steps for activating extended SQL trace as given in the book, Optimizing Oracle Performance by Cary Milsap: There are several ways to activate extended SQL tracing for a given session. Two such ways are shown in Example 6-5 and Example 6-6. Oracle encourages you to use the DBMS_SUPPORT package instead of DBMS_SYSTEM if you have a choice (Oracle MetaLink note 62294.1). However, Oracle does not ship dbmssupp.sql and prvtsupp.plb with some software distributions. If you cannot find DBMS_SUPPORT on your system, don't despair. My colleagues and I have used DBMS_SYSTEM.SET_EV in hundreds...

How to start trace of an existing session in 10g 10g has a new package called DBMS_MONITOR EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(&sid,&serial,waits=>true, binds=>false); To disable EXECUTE DBMS_MONITOR.SESSION_TRACE_DISABLE(&sid,&serial) My old article on tracing http://appstier.blogspot.in/2012/05/activate-extended-sql-trace-for-given.htm...

Where is OA_HTML defined in R12 OA_HTML is defined in R12 is  $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/oc4j.properties&nb...

What is the naming conventions for concurrent request log,out files and manager log files Log file :                 l<request id>.req Output files:                  o<request id>.out Where are the managers logfiles goes: Similar to concurrent requset output and log, the concurrent manager does also generate some files and typical naming convention are as below: ICM logfile: Default is std.mgr, can be changed with the mgrname     Concurrent manager log: w<XXXXXX>.mgr     Transaction manager log: t<XXXXXX>.mgr     Conflict Resolution manager log: c<XXXXXX>.mgr Where: <XXXXXX>...

If APPLCSF is not set where is the location of concurrent Requests ? If we not set the APPLCSF location for concurrent Requests . Here it will store in Product top i.e $PRODUCT_TOP/log/ Where is the location of log file of ICM if APPLCSF is not set. $FND_TOP/log/...

How can we find the log & out files of concurrent Requests? or  what is the location of log & out files of concurrent Requests? From Back end : Log file Locations:  $APPLCSF/$APPLLOG Out File Locations: $APPLCSF/$APPLOUT Each log file and out file related to each request is identified with that request id. From Front End: Navigate to System Administrator --> Concurrent-->Requests-->find [button] Log file: Click on view log button Out file : Click on view output button Using SQL: Connect to sqlplus as 'apps' user SQL>@$FNS_TOP/sql/afcmcreq.sql Then it will promts for the request id . By using this we can view only log files....

Concurrent Manager FAQs Which Concurrent Managers (CCMs) are supported by the Sysadmin team?     Internal Concurrent Manager (ICM)     Standard Manager     Conflict Resolution Manager  (CRM) The setup of product-specific managers related issues should be directed to the associated product group, i.e. the Inventory manager Q: Where do the concurrent request output and log files reside? A: $APPLCSF/out or $Product_Top/out for output files $APPLCSF/log or $Product_Top/log for log files Q: Where are temporary files located? A: Temporary files reside in: $APPLPTMP$APPLTMP $REPORTS25_TMP (Release 11.0) $REPORTS60_TMP (Release 11.5) Q: How to change PMON  method to LOCK. To...

Lets classify how to start troubleshooting CM Issues related to startup/shutdown of CM If you try to start CM using adcmctl.sh or adstrtall.sh script & you encounter problem in starting CM then check for log files. All information related to why Concurrent Manager not coming up is recorder in log file at $APPLCSF/$APPLLOG with default name as $SID_$DD ( where DD is date on which you started Concurrent Manager ). This Concurrent Manager naming convention will be listed in file adcmctl.sh file (Concurrent Manager startup file). If $APPLCSF is not set then you can look for this file in $FND_TOP$APPLLOG ICM is Up but some managers are still down As you know adcmctl.sh script starts ICM (Internal Concurrent Manager) and...

Concurrent Manager(CM) Trouble shooting : For Concurrent manager(CM) trouble shooting 1. First check the CM is up or not by using below any one procedure.       i. ps –ef|grep FNDLIBR      ii. adcmctl.sh status apps/<appsPWD>     iii. Login as system administrator responsibilities go to the below navigation Concurrent -> manager -> Administer -> see the  Actual and target for all the managers 2. If CM in down check the internal manager Logfile in $APPLCSF/APPLLOG location for errors. 3. If any errors related to FNDFS then check the Application listener STATUS , if it is not running start it. 4. If CM is up/running then log file and output file are not able see...

Concurrent Manager not starting after Cloning ? CM not starting after Cloning ? Once after doing Rapid cloning some of concurrent managers were not starting. The issue was that the node was wrongly defined as source node in Administer Manager screen. Then i checked in the FND_NODES table which wrongly had the source nodes as well apart from the target nodes. I performed the following action plan which resolved the issue-> * Shutdown the apps services* EXEC FND_CONC_CLONE.SETUP_CLEAN;   COMMIT;   EXIT; * Ran AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers.* Start the apps services. Actually FND_CONC_CLONE.SETUP_CLEAN clears up the tables with nodes information...

Installation  of Oracle Application 11i Oracle Apps 11i Installation  Actually there are 2 types of instalations 1. Single Node 2. Multi Node Again Multi Node is classified into 3 types 1. Distributed Appl Top. 2. Shared Appl Top(Appltop, Common Top). 3. Shared Apps Tier(806,ias,Appltop, Common Top). 1.  Single Node=============== STEPS======== 1.  Create the required directories. [root@srvr33 ~]# mkdir -p /m01/abc/rdbms   <----  ORACLE_HOME [root@srvr33 ~]# mkdir -p /m02/abc/{806,ias} <--- DEVELOPER,IAS [root@srvr33 ~]# mkdir -p /m02/abc/{appltop,commtop} [root@srvr33 ~]# mkdir -p /m01/abc/oradata [root@srvr33 ~]# chown -R oracle:dba /m01/abc [root@srvr33 ~]# chown -R applmgr:dba...

ADCTRL Options [applmgr@srvr33 appltop]$ . APPSdb4_srvr33.env [applmgr@srvr33 appltop]$ adctrl                 AD Controller Menu      ---------------------------------------------------      1.    Show worker status      2.    Tell worker to restart a failed job      3.    Tell worker to quit      4.    Tell manager that a worker failed its job      5.    Tell manager that a worker acknowledges quit      6.    Restart a worker on the current machine      7.    Exi...

ADADMIN Options [applmgr@srvr33 appltop]$ . APPSdb4_srvr33.env [applmgr@srvr33 appltop]$ adadmin  AD Administration Main Menu  --------------------------------------------------    1.    Generate Applications Files menu    2.    Maintain Applications Files menu    3.    Compile/Reload Applications Database Entities menu    4.    Maintain Applications Database Entities menu    5.    Change Maintenance Mode    6.    Exit AD Administration Enter your choice [6] : 1          Generate Applications Files    ----------------------------------------  ...

Some of the Directory Structure and File Locations Directories ----------- APPL_TOP    :  Where the  Apps files reside.                  (/m03/db1/appltop) COMMON_TOP  :  Where the  common files  resides        (/m03/db1/commontop) 806    :  Forms , Reports run time engine (/m02/db1/806) IAS         :  Webserver and Front-end connectivity enginge (/m02/db1/ias) Environment Variables---------------------- DB TIER------- [oracle@srvr33 bin]$ echo $ORACLE_HOME /m01/db2/rdbms APPS TIER---------- [applmgr@srvr33 db2]$ echo $APPL_TOP /m03/db2/appltop [applmgr@srvr33 db2]$...