tag:blogger.com,1999:blog-37112840950296566612024-03-08T01:30:07.791-08:00ORACLE DBA AND ORACLE APPS DBA FAQSThis blog is designed to capture/compile all important,useful and real time questions,scenarios really required for a Oracle DBA and Oracle Apps DBA. Please do comment your comments and suggestions.BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-3711284095029656661.post-85979057751708169602021-06-19T09:54:00.003-07:002021-06-19T09:54:15.478-07:00Oracle Apps DBA R12.2.x Interview Questions and Answers<p> 1. What is Online Patching?</p><p>Ans: Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, and the users are working as normal.</p><p>2. Which Oracle E-Business Suite releases Online Patching feature is available?</p><p>Ans: Online patching is used with Oracle E-Business Suite 12.2 and higher.</p><p>3. What types of patch are applied online?</p><p>Ans: All Oracle E-Business Suite Release 12.2 patches are applied online. This includes one-off patches, patch rollups, consolidated updates and security patches.</p><p>4. What is the Online Patching cycle?</p><p>Ans: The Online Patching cycle is a sequence of inter-related steps (phases) used to apply patches to an Oracle E-Business Suite system.</p><p>5. What tool is used to apply online patches?</p><p>Ans: The AD Online Patching (adop) command-line utility is used to manage the Online Patching cycle.adop invokes adpatch is the background only</p><p>6: Is there any downtime in Online Patching?</p><p>Ans: There is a short period of downtime when the application tier services are shut down and restarted. The database remains open all the time.</p><p>7 Once I upgrade to Release 12.2, can I still apply patches in the traditional way?</p><p>Ans: No. All patches for Release 12.2 will be online patches. The traditional, pre-12.2 method of applying patches will not work.There are option like downtime and hotpatch which works more like traditional way but they are used for patches directed by Oracle</p><p>8. What is the Online Patching infrastructure?</p><p>Ans:This infrastructure includes database objects edition and patch/run file system components.</p><p>9. Does Online Patching require the 11gR2 Oracle Database Edition Based Redefinition (EBR) feature?</p><p>An: Yes. Online patching depends on the Edition Based Redefinition (EBR) feature that was introduced in the Oracle 11gR2 Database. Most notably, EBR allows editioning of code objects in the database. To do this, it provides new object types such as editions, editioning views, and cross-edition triggers, all of which are part of the Online Patching infrastructure.</p><p>10. What are the phases that make up the Online Patching cycle?</p><p>Ans: The Online Patching cycle consists of the following phases:</p><p>1.Prepare a virtual copy (patch edition) of the running application (run edition).</p><p>2.Apply patches to the patch edition of the application.</p><p>3.Finalize the system in readiness for the cutover phase.</p><p>4.Cutover to the patch edition and make it the new run edition.</p><p>5.Cleanup obsolete definitions or data to recover space.</p><p>11.What downtime is required during an Online Patching cycle? or as the name spells online,there is not downtime in the whole process?</p><p>Ans: The cutover phase requires a short period of downtime (typically a few minutes) for transition tasks such as a restart of the application tier services.</p><p>12. Is any downtime required for the database tier?</p><p>Ans: No. In fact, the database needs to be up and running during each phase of the Online Patching cycle. Suite database.</p><p>13. How does Online Patching work on the application tier?</p><p>Ans: During Release 12.2 installation, Rapid Install will lay down two copies of the application tier file system. One of the copies will be labeled as the run file system, and the other as the patch file system. Subsequently, when a patch is applied, adop will:</p><p>1).Synchronize the contents of the run file system to the patch file system. This happens during the prepare phase.</p><p>2).Perform patching actions on the patch file system. This happens during the apply phase.</p><p>3).Finally, during the cutover phase, the adop utility restarts the application tier services. The patch file system is then promoted to be the new run file system, and the old run file system becomes the patch file system for the next patching cycle.</p><p>Note that a third file system, the non-editioned file system (fs_ne), is created to store files containing data that is needed across all file systems,such as log files.</p><p>14. How do I apply Oracle Fusion Middle-ware patches in Oracle E-Business Suite Release 12.2?</p><p>Ans: During the apply phase of an Online Patching cycle, you apply Oracle Fusion Middle-ware patches to the Oracle homes of the patch edition file system. Then, after the cut over phase is complete, you synchronize the file systems by performing an fs_clone operation. (Also see My Oracle Support Knowledge Document 1355068.1, as listed in Appendix A.)</p><p>15. Can I use the patch edition for testing and development purposes?</p><p>Ans: As a specialized component of the Online Patching infrastructure, the patch edition is not supported for use as a test environment. You should continue to employ a separate, dedicated test environment.</p><p>16.Can Online Patching be used with database technologies such as Active Dataguard and Flashback?</p><p>Ans:Yes. Online patching can be used alongside Active Dataguard and Flashback. In fact we can use flashback to rollback the changes after the final cutover</p><p>17. What are the key differences between the DBA_OBJECTS, DBA_OBJECTS_AE, and AD_OBJECTS tables?</p><p>Ans: DBA_OBJECTS shows object information for the current edition, but the STATUS column in this view may show the object as VALID even if the object actually needs to be compiled before use.</p><p>DBA_OBJECTS_AE is similar to DBA_OBJECTS, but shows object information across all editions. This has the drawback of showing objects in old editions that are no longer accessible to the application.</p><p>AD_OBJECTS is the Oracle E-Business Suite workaround to the unreliable STATUS column in DBA_OBJECTS. AD_OBJECTS shows the correct status for each object visible in the current edition. It also shows whether the object is “actual” (a real object) in the current edition, or a “stub” object (the object definition was inherited from a previous edition). You can query AD_OBJECTS to locate objects that need to be recompiled before use:</p><p>SQL>select owner, object_name, object_type from ad_objects where status = ‘INVALID’</p><p>order by 1,2,3</p><p>/</p><p>The same logic can be applied by running the script:</p><p>SQL>sqlplus apps/apps @$AD_TOP/sql/ADZDSHOWINVALID</p><p>18. Does Online Patching increase the network port requirements on an Oracle E-Business Suite instance?</p><p>Ans: Yes. Online patching requires an additional set of network ports for the Oracle WebLogic Server managed servers on the second file system. During the cutover phase, the managed servers run simultaneously on the patch file system and run file system for a brief period, in a rolling transition process.</p><p>19. Is it possible to abort an Online Patching session?</p><p>Ans: Yes. Up to cutover, you can run the abort phase to undo the changes made so far in the patching cycle. It is not possible to back out patches once cutover is complete.</p><p>20. Is the shared APPL_TOP configuration supported with Online Patching?</p><p>Ans: Yes. A shared APPL_TOP configuration is supported and recommended for multi-node application tier implementations in Release 12.2.</p><p>21. How does adop work in a multi-node environment?</p><p>Ans: The adop Online Patching tool uses remote APIs and ssh login to execute patching operations on remote nodes in a multi-node environment. The node that launches adop becomes the ‘master’ node, and the remote nodes are referred to as ‘slaves’.</p><p>22. How do I determine the status of my Online Patching session?</p><p>Ans: You can run the adop -status command. This will display information that includes phases completed and the time taken. If you want additional details of operations performed, you can run the adop -status -detail command.</p><p>23. What is downtime mode and when can it be used?</p><p>Ans: To optimize the process of upgrading to E-Business Suite Release 12.2, the AD Delta 5 Release Update Pack introduced downtime mode, which is used as follows:</p><p>$ adop phase=apply patches=<patch_number> apply_mode=downtime</p><p>Downtime mode does not use an online patching cycle. The process of applying a patch in downtime mode completes more quickly than in online mode, but at the cost of increased system downtime.</p><p>When applying Oracle E-Business Suite patches in this mode, adop will first confirm that the application tier services are down, and will then proceed to apply the patch to the run edition of the Oracle E-Business Suite database and file system.</p><p>Downtime mode is supported for:</p><p>-All patching (including post-upgrade patching) that forms part of the Release 12.2 upgrade process and is completed before the system is scaled up, the application tier services are started, and users log in to the upgraded system.</p><p>-Single-node development or test environments, where production support and high availability are not required.</p><p>Downtime mode allows the 12.2 upgrade process to be completed as quickly as possible. Once the upgrade is complete and users are online, all subsequent patching on a production system should use online mode, not downtime mode, unless the patch readme states otherwise.</p><p>Several restrictions apply to the use of downtime mode:</p><p>-You cannot validate successful patch application before cutover to the updated code takes place.</p><p>-There is no capability to abort a failed patch and return to the existing run edition.</p><p>-Release 12.2 patches are not normally tested in downtime mode.</p><p>-Use of downtime mode in a multi-node application tier environment is not tested or supported.</p><p>24. What can I do to reduce the time required for cutover?</p><p>Ans: It is important to distinguish between the time needed for the whole cutover phase, and the downtime period within the phase. The actual downtime (during which users cannot log in) is significantly shorter than the whole phase. To help reduce the overall time taken by cutover, you can do three things:</p><p>-Run the finalize phase explicitly, to obviate the need for cut over to do so.</p><p>-Shut down the concurrent managers before running cut over, to avoid having to wait for concurrent requests to complete. Alternatively, ensure no long-running concurrent jobs are submitted while a patching cycle is in progress.</p><p>-Ensure you are using the maximum number of parallel workers your system will support.</p><p>25. What is fs_clone and how is it used?</p><p>Ans: The command adop phase=fs_clone is a special command that is used to copy the run file system to the patch file system. Also see previous question.</p><p>26. Will AutoConfig and adadmin maintenance tasks such as adrelink,forms compilation,report compilation be performed online?</p><p>Ans: Yes, these maintenance tasks will be performed online. The relevant operations will be targeted to the patch file system, and should be performed during a patching cycle. They will not have any impact on the run file system.</p><p>27. Does Online Patching change the way data fix patches are applied to Oracle E-Business Suite 12.2?</p><p>Ans: Yes. Data fix patches (used to fix transactional data) require special handling. The patch readme will give full instructions.</p><p>28. How do I apply or patch my customizations in Oracle E-Business Suite Release 12.2?</p><p>Ans: You should apply your customizations to the patch edition during the apply phase of the Online Patching cycle. Because this happens prior to the cutover phase, your changes will be propagated to the new run edition (along with all the fixes in the patches applied during the patching cycle).</p><p>29. If custom code is installed on a separate database schema, do I have to edition-enable my custom database schema?</p><p>Ans: The coding standards in the Oracle E-Business Suite Developer’s Guide state that the first step to any custom application development is to register the custom Oracle schema with the Oracle E-Business Suite applications. The Online Patching enablement patch enables edition on all the schemas registered with the application. If you follow this process, your schema will be edition-enabled automatically.</p><p>30. Are there any special considerations for creating custom patches that are compliant with Online Patching?</p><p>Ans: Yes. There are some special considerations for creating custom patches that are compliant with Online Patching. Refer to the Patching Standards section of Oracle E-Business Suite Developer’s Guide.</p><p>31: How is a non Oracle E-Business Suite database schema able to access the Oracle E-Business Suite tables?</p><p>Ans: Any third-party schema, either from third-party products or custom code, must access Oracle E-Business Suite tables via the synonyms in the APPS schema. Direct access to Oracle E-Business Suite tables may produce incorrect results.</p><p>32: What are the main technological difference between R12.2 and R12.1</p><p>Ans: R12.2 uses weblogic while R12.1 uses OC4J. Apart from that we have online patching feature in r12.2 using edition and patch/run file system</p><p>33: How to change the apps password in R12.2?</p><p>Ans: apps password is same as R12.1 with the exception of changing that in weblogic console also.</p><p>34: where are the log files stored for adop?</p><p>Ans: It is stored in the third filesystem which is non edition filesystem</p><p>35. how do you connect to the patch edition?</p><p>Ans: Source the env using patch option</p><p>/u71/R122/EBSapps.env patch</p><p>36: How to determine the web logic version in R12.2</p><p>Ans: After Logging into the application set the environment to RUN Filesystem</p><p>. /u01/oracle/R122/EBSapps.env run</p><p>Then, cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION</p><p>You will get Below Output:</p><p>WLS_PRODUCT_VERSION=10.3.6.0</p><p>To find the FMW version Oracle E-Business Suite Component Version on R12.2</p><p>$export ORACLE_HOME=/u01/oracle/R122/fs1/FMW_Home/Oracle_EBS-app1</p><p>./opatch lsinv</p><p>You will get below Output</p><p>Oracle E-Business Suite Component 11.1.1.6.0</p><p>Addidtion Info</p><p><br /></p><p>********************************************************************</p><p>Oracle WebLogic Server 10.3.6 in Oracle Fusion Middleware 11g Release 1 (11.1.1.6)</p><p>Oracle Fusion Middleware</p><p>10.3.6 WebLogic Server (WLS)</p><p>11.1.1.6 OHS (WebTier)</p><p>37. How to add and delete the manage node in R12.2?</p><p>Ans: I was working on R12.2 Test env and I was supposed to decrease the JVM for the oacore(delete the manage server)</p><p>The procedure to increase or decrease JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on OC4J instances and were managed by Oracle Process Manager (OPMN).So we just need to increase the numprocs in opmn.xml and start the services or run autoconfig with decrease numprocs in Context file</p><p>I came to know it is quite different in R12.2.X as Oracle WebLogic Server has replaced OC4J in Oracle E-Business Suite Release 12.2, these services are now deployed as applications on individual managed servers.</p><p>Only part of the configuration of these applications and managed servers is still managed via AutoConfig.Rest of things need to done quite different</p><p>I have already explained on how to add manage server in my previous post</p><p>How to add the manage server in R12.2</p><p>In the below, I would be explaining what I learned from that experience and How to delete the manage server in R12.2. I will particularly taking the example of oacore</p><p>Steps on How to delete the manage server in R12.2</p><p>Deletion of managed servers needs to be done on the run file system when there is no active ADOP cycle. During the next adop prepare, the Configuration Change Detector identifies that the addition has been made and the managed servers are automatically synced up from the run file system to the patch file system. The synchronization also gets done when fs_clone is executed.</p><p>2. If the managed server to be deleted is running, shut it down as follows:</p><p>On UNIX:</p><p>$ sh <ADMIN_SCRIPTS_HOME>/admanagedsrvctl.sh stop <MANAGED SERVER NAME></p><p>For example, before deleting a managed server ‘oacore_server2’, execute the following command to shut it down.$ sh <ADMIN_SCRIPTS_HOME>/admanagedsrvctl.sh stop oacore_server2</p><p>3. Run the command below on the application tier node where the managed server resides. This will delete the managed server, and also update the respective context variables that contain references to the deleted managed server.</p><p>$ perl <AD_TOP>/patch/115/bin/adProvisionEBS.pl \</p><p>ebs-delete-managedserver \</p><p>-contextfile=<CONTEXT_FILE> -managedsrvname=<MANAGED_SERVER_NAME> \</p><p>-servicetype=<SERVICE_TYPE> -logfile=<LOGFILE></p><p>For example, for deleting a managed server ‘oacore_server2’ of type ‘oacore’, execute the following command:$ perl <AD_TOP>/patch/115/bin/adProvisionEBS.pl \</p><p>ebs-delete-managedserver \</p><p>-contextfile=<CONTEXT_FILE> -managedsrvname=oacore_server2 \</p><p>-servicetype=oacore -logfile=<APPLRGF>/TXK/delMS_oacoreserver2.log</p><p>4. Perform the following steps on all application tier nodes participating in the same cluster as the deleted managed server:</p><p>(a) Source the run file system.</p><p>(b) If the deleted managed server is part of the cluster configuration defined on the current node, execute the following command to delete details of the managed server from the OHS configuration files mod_wl_ohs.conf and apps.conf on the current node:</p><p>$ perl <FND_TOP>/patch/115/bin/txkSetAppsConf.pl \</p><p>-contextfile=<CONTEXT_FILE> \</p><p>-configoption=removeMS \</p><p>-oacore=<host>.<domain>:<port> \</p><p>-oafm=<host>.<domain>:<port> \</p><p>-forms=<host>.<domain>:<port> \</p><p>-formsc4ws=<host>.<domain>:<port> \</p><p>-ekanban=<host>.<domain>:<port> \</p><p>-accessgate=<host>.<domain>:<port> \</p><p>-yms=<host>.<domain>:<port>where¦The argument contextfile accepts the complete path to the context file.</p><p>¦The arguments oacore, oafm, forms, formsc4ws, ekanban, accessgate and yms accept a comma-separated list of managed server details in the following format:</p><p><host>.<domain>:<port> ¦host, domain and port are the hostname, domain and port of the managed server whose reference is to be deleted.</p><p>For example, to remove references of the deleted managed server oacore_server2 with port 9705 on host ‘myserver’ and domain ‘go.com’, the following command should be executed:</p><p>$ perl <FND_TOP>/patch/115/bin/txkSetAppsConf.pl -contextfile=<CONTEXT_FILE> \</p><p>-configoption=removeMS -oacore=myserver.go.com:9705</p><p>3. If Oracle HTTP Server is enabled on the node, restart it as follows:</p><p>On UNIX:</p><p>$ sh <ADMIN_SCRIPTS_HOME>/adapcctl.sh stop</p><p>$ sh <ADMIN_SCRIPTS_HOME>/adapcctl.sh start</p><p>As I told earliar ,the steps are very different from R12.1.X in R12.2.X.</p><p>38. Where are the log file located in R12.2 Apache and Weblogic?</p><p>Ans: Apache Logs</p><p>$IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/EBS_web_*/*log</p><p>OPMN Log</p><p>$IAS_ORACLE_HOME/instances/*/diagnostics/logs/OPMN/opmn/*</p><p>Weblogic Logs</p><p>$IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager $EBS_DOMAIN_HOME/servers/oa*/logs/*</p><p>$EBS_DOMAIN_HOME/servers/forms*/logs/*</p><p>$EBS_DOMAIN_HOME/servers/AdminServer/logs/*</p><p>$EBS_DOMAIN_HOME/sysman/log/*</p><p>39. How to stop and start the services in R12.2</p><p>Ans: When we want to stop all application services using script adstpall.sh , we provide apps password in R12.1.3.But in R12.2 it will ask weblogic admin password in addition to bring down to all services .</p><p>We need to provide Weblogic admin password</p><p>Component Command</p><p>Node Manager $adnodemgrctl.sh start Enter Weblogic Admin Password:</p><p>Weblogic Admin Server $adadminsrvctl.sh start Enter Weblogic Admin Password:</p><p>Application Listener $adalnctl.sh start</p><p>Oracle Process Manager $adopmnctl.sh start</p><p>Apache Services $adapcctl.sh start</p><p>Managed Server for OACORE Services $admanagedsrvctl.sh start oacore_server1 Enter Weblogic Admin Password:</p><p>Managed Server for FormsServices $admanagedsrvctl.sh start forms_server1 Enter Weblogic Admin Password:</p><p>Managed Server for Fusion MiddleWare Services $admanagedsrvctl.sh start oafm_server1 Enter Weblogic Admin Password:</p><p>Managed Server for Forms web Services $admanagedsrvctl.sh start forms-c4ws_server1 EnterWeblogic Admin Password:</p><p>Concurrent Manager Service $adcmctl.sh start apps/apps</p><p>Fullfillment Serer Services $jtffmctl.sh start</p><p>40. Do we need to copy the Oracle fusion middleware in R12.2 cloning?</p><p>Ans: It is not required in R12.2 cloning as adpreclone copies the Oracle fusion middle in compressed format on the application tier</p><p>41. What is domain in Web Logic?</p><p>Ans: Domain is logical grouping of resources and services and consist of Administration Server, Managed Server and cluster. There can only be one administration Server in domain and zero to N Managed Server.</p><p>Note: Before creating domains let us understand Domain, Administration Server, Managed Server and Cluster in Oracle Web Logic. How to create basic Domain (Administration Server only) and Domain with Managed Server Cluster (one Administration Server and two Managed Server in cluster) using Configuration Manager.</p><p>42. What is Administration Server?</p><p>Ans: Administration Server is WebLogic Server instance that maintains configuration data for a domain. You can deploy your application on administration Server but it is recommended to create managed Server and deploy your application in managed server and leave Administration domain for configuration and maintenance.</p><p>—There will always be at least one Administration Server in a domain.</p><p>43. What is Managed Server?</p><p>Ans: Any WebLogic Server instance apart from Administration Server is called as Managed Servers. This is weblogic server where you deploy your application (Though you can deploy your application in Administration server as well but it is not recommended in production/UAT instance)</p><p>44. What is Cluster in WebLogic ?</p><p>Ans: Group of WebLogic Managed Server Instances that work together to provide high availability and scalability for applications is called cluster. WebLogic Servers with in cluster can run on same machine or different machines. These are also called as managed Server cluster.</p><p>45. Things you should know before creating domain in WebLogic Server ?</p><p>Ans: You use configuration wizard to create or extend domain but this can be used only in offline mode (when weblogic server is not running)</p><p>— You can also use WLST (WebLogic Scripting Tool), command line tool to create and extend domains in WebLogic Server.</p><p>— You can also use unpack command to create new domain. This command can’t be used to extend domain.</p><p>— Extending a domain means, you already created domain and now wish to extend it (use more application, add managed server, create cluster…)</p><p>— Configuration wizard can be run in Graphical Mode (interactive GUI) or Console Mode (interactive text based)</p><p>— For silent mode use WLST (WebLogic Scripting Tool)</p><p>— While creating domain you specify Startup Mode (Development or Production). In development mode, you get autodeploy option and security is low. In production mode you need username/password to deploy applications.</p><p>— When you create domain, it creates following directories</p><p>i) autodeploy ii) bin iii) config (config.xml for domain sits here) iv) console-ext v) lib vi) security vii) servers</p><p>–You use config.cmd (windows) or config.sh (unix) from $BEA_HOME/ wlserver_<ver>/ common/ bin to start configuration manager to create domain</p><p>- Below Flowchart (image from Oracle Documentation) displays steps to create domain.</p>BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com0tag:blogger.com,1999:blog-3711284095029656661.post-91559817564756953602012-01-21T20:42:00.000-08:002012-01-21T20:43:48.892-08:00Patch Application Assistant (admsi.pl) in Oracle Apps R12<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<strong>PAA </strong>(Patch Application Assistant) is tool/Perl script to <strong>generate customized installation instructions</strong> for a patch in Oracle Applications R12 which helps user to<strong>track and perform manual steps</strong> during patching.<br /><br />1. <strong>admsi.pl</strong> is under $AD_TOP/bin</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
2. You can run <strong>admsi.pl</strong> (Patch Application Assistant) in two mode<br /><strong>i) GUI</strong> (Graphical User Interface)<br /><strong>ii) CLI </strong>(Command Line Interface)</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
3. Once you complete manual steps as instructed in <strong>PAA report</strong>, you can record that step as completed.</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
.<br /><strong><u>How to Run PAA (Patch Application Assistant) in R12</u></strong><br /><strong>1.</strong>Source environment file i.e. $ORACLE_R12_BASE/ apps/ apps_st/ appl/ APPS[SID]_[hostname].env</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<strong>2.</strong>Run PAA using admsi.pl in either CLI or GUI</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<strong>2.1</strong> CLI</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<span style="color: red;">perl admsi.pl <strong>-patch_top</strong>=[patch-top-directory]<strong>-appspass</strong>=[apps-password]</span></div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<span style="color: black;">For example to generate PAA report for 12.0.6 patch (6728000) run it as </span></div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<span style="color: red;"><strong>perl $AD_TOP/bin/admsi.pl -patch_top=/stage/ oracle/ patches/ r12/ 6728000 -appspass=apps</strong></span></div>
<span style="background-color: white; color: red; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;"></span><div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<span style="color: red;"></span><span style="color: red;">Gathering Information..<br />Logfile for this session is located at admsi.log<br />Generating installation instructions for patch 6728000..<br />Updating database….<br />install_6728000.html generated successfully<br />install_6728000.txt generated successfully</span></div>
<span style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;"></span><div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
Now view report (text or html format) containing manual steps for 12.0.6</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
.</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<strong>2.2 GUI</strong></div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
Invoke PAA in GUI by running <strong>admsi.pl</strong> as shown below</div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<a href="http://onlineappsdba.com/wp-content/uploads/2008/11/admsi_2.jpg" style="color: #ff9900; font-weight: bold; text-decoration: none;"><img src="http://onlineappsdba.com/wp-content/uploads/2008/11/admsi_2.jpg" style="background-color: #f7f7f7; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; padding-bottom: 2px; padding-left: 2px; padding-right: 2px; padding-top: 2px;" /></a></div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
<br /></div>
<div style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Arial; font-size: 12px; line-height: 22px; text-align: -webkit-auto;">
</div>
3. Once you get list of manual steps, follow instructions in report<br />
4. Apply apps patches using AUTOPATCH utility (<strong>adpatch</strong>)<br />
<br />
Source : <a href="http://onlineappsdba.com/index.php/2008/11/11/admsipl-patch-application-tool-in-oracle-apps-r12/">http://onlineappsdba.com/index.php/2008/11/11/admsipl-patch-application-tool-in-oracle-apps-r12/</a><br />
<br />
<br />
</div>BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com2tag:blogger.com,1999:blog-3711284095029656661.post-43151454923588447922010-08-10T04:22:00.000-07:002010-08-10T04:27:12.477-07:00Clearing JSP cache in R12 (s_jsp_main_mode)There is a change in the default behaviour of handling JSP cache<br />
in R12 as opposed to 11i. Remember, JSPs were handled by Apache<br />
Jserv engine in 11i and is being handled by OC4J (10.1.3 AS) in R12.<br />
<br />
In 11i, when we clear cache ($COMMON_TOP/_pages) and try to<br />
access JSP pages, it gets automatically recompiled. However, this<br />
is not the case in R12 by default.<br />
<br />
So, in an R12 instance, if you clear _pages and restart apache,<br />
you will only get a blank screen since AppsLocalLogin.jsp wouldn’t<br />
get compiled by default. You will not even see a new _pages directory.<br />
<br />
To overcome this, as per Oracle, whenever JSP cache is cleared, we have to run<br />
“ojspcompile.pl” to recompile ALL jsp pages in the Application.<br />
This will take roughly around 15 to 20 mts. However, in the real world<br />
(atleast in the pre-production stage) this is not affordable.<br />
<br />
The solution to this is to change the XML file parameter<br />
s_jsp_main_mode to a value of “recompile” from the default value of<br />
“justrun” and run autoconfig. JSP pages will be recompiled automatically<br />
after this change.<br />
<br />
Source : <a href="http://oraclepitstop.wordpress.com/">http://oraclepitstop.wordpress.com</a>BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com0tag:blogger.com,1999:blog-3711284095029656661.post-37497768136971805072010-08-10T04:20:00.000-07:002010-08-10T04:27:26.946-07:00How to clear cache for a specific component in R12?As we all know the normal tendency for clearing cache in Oracle Apps is to delete the $COMMON_TOP/_pages directory. In 11i, after deleting we dont have to recompile the jsps but in R12 we have to recompile the pages since s_jsp_main_mode is set to justrun by default which is in turn updated in orion-web.xml. Click here for more info.<br />
<br />
Ok coming to this post, how can i clear cache for a specific component of Oracle Apps R12 viz., iprocurement, istore etc., Is this even possible ? Yes it is and this option comes handy when somebody modifies a jsp page which is part of say istore, then it makes sense to clear cache for istore and not for the whole server.<br />
<br />
<b>Clearing cache for specific Component/Application in R12</b><br />
<br />
Login as sysadmin<br />
Select “Functional Administrator” responsibility<br />
Go to Core Services ==> Caching Framework ==> Tuning<br />
Query the application (for example iStore) or by Name or code.<br />
Select the component and clear the cache.<br />
<br />
Note: For some specific configuration changes, we need to bounce Apache also.<br />
<br />
<b>Clearing Global Cache in R12</b><br />
<br />
a) Go to Functional Administrator Responsibility<br />
b) Go to Core Services ==> Caching Framework<br />
c) Go to Global configuration and clear all the cache from there.(Only If you want to clear all the cache)<br />
<br />
Source : <a href="http://oraclepitstop.wordpress.com/">http://oraclepitstop.wordpress.com</a>BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com0tag:blogger.com,1999:blog-3711284095029656661.post-72982055184062926232010-08-10T04:15:00.000-07:002010-08-10T04:15:23.628-07:00Apps 11i Components are replaced by Apps R12<b>Do we have mod_plsql,jserv,reports server in R12 ?</b><br />
<br />
mod_plsql :<br />
<br />
Mod_plsql is an Apache web server extension that can be used to develop web application pages using Server PL/SQL.<br />
Unlike Oracle E-Business Suite Release 11i, Release 12 does not include mod_plsql as part of its technology stack.<br />
Modplsql component of Apache is removed in R12 .you have to see the alternate for custom developed programs which will be using this.<br />
If you have developed mod_plsql extensions to Oracle E-Business Suite Release 11i, and are considering upgrading to Release 12, you will have to take some action to preserve that functionality.<br />
mod_plsql is replaced by Oracle Application Framework in R12. The reasong for replacing the mod_plsql with Oracle Application Framework in R12 is that , mod_plsql does not provide solutions for a number of important problems that must be solved in a robust and secure web application.<br />
<br />
<b>The following components/modules were removed from Release 12</b><br />
<br />
1. mod_plsql<br />
2. Oracle Reports Server<br />
3. Oracle Graphics Integration with Oracle Forms<br />
4. Oracle Applications Framework pages in the AK Repository (AK mode)<br />
<br />
JServ :<br />
<br />
OC4J replaces the Jserv component which is there in the current release 11i of Oracle Applications. Also as a result the mod_jserv component would be replaced by the mod_oc4j component in release 12 of Oracle Applications. The mod_oc4j is used to communicate between different OC4J instances.<br />
<br />
The default installation Release 12 of Oracle Applications creates 3 OC4J instances<br />
<br />
– Oacore: This runs the OA Framework -based applications.<br />
– Forms: This runs the Forms-based applications.<br />
– OAFM: This is responsible for running the web services.<br />
<br />
The Jserv groups which are there current in Oracle Applications Release 11i are also planned be replaced by OC4J instances.<br />
<br />
As mentioned earlier the OC4J properties are controlled using the XML files and OC4J.properties file. These files are managed by the standard Oracle Applications Autoconfig.<br />
<br />
The Java code deployment in Oracle E-Business suite for OC4J is done at the time of install using rapid install and maintained by ad tools like adadmin and adpatch. New custom code deployment can be done by using the Application Server Control user interface.<br />
<br />
The OC4J implementation In Oracle Applications Release 12 includes the following directory structure.<br />
<br />
– applications: Contains applications deployed<br />
– applications-deployment: Contains configuration settings for the applications deployed<br />
– config: Contains common configuration setting for the OC4J instance.<br />
<br />
Remember there are no jserv.properties or jserv.conf or zone.properties in R12 (new techstack), Jserv is replaced by Oacore.<br />
<br />
<b>Finally …</b><br />
<br />
- Jserv component is removed and it is replaced in R12 by OC4J(oacore)<br />
- mod_plsql is replaced by Oracle Application Framework<br />
- The reports server has been removed in R12 and it runs as a spawned process called rwrun which is spawned by conc manager.<br />
<br />
Ref Note : 726711.1<br />
<br />
Source : <a href="http://learnwithme11g.wordpress.com/">http://learnwithme11g.wordpress.com</a>BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com1tag:blogger.com,1999:blog-3711284095029656661.post-12159266737367474882010-04-07T00:41:00.000-07:002010-04-07T00:41:04.767-07:00Oracle Apps DBA - Miscellaneous1. What are the problems u have faced while shutting down applications?<br />
Ans: While shutting down application generally concurrent manager won’t go<br />
down because some or the other request may be running. We will see what are<br />
the concurrent requests running by querying fnd_concurrent_requests,<br />
fnd_concurrent_program_vl, v$session,v$process and v$sqltext. If that request is<br />
only doing some select statement then we will kill those requests, otherwise we<br />
will check what time it will take to complete by querying the previous runs of that<br />
request and then we will decide what to do.<br />
<br />
2. What are the problems u have faced while starting up applications?<br />
Ans: Most of the time we will encounter problem with starting up concurrent<br />
managers. Reasons, database listener may be down or FNDSM entries are<br />
wrong in tnsnames.ora of 806_ORACLE_HOME.<br />
<br />
3. How to find the locks and what is the resolution?<br />
Ans: we can find general locks with the following query:<br />
Select * from sys.dba_dml_locks order by session_id.<br />
We can find the dead locks with the following query:<br />
Select * from v$lock where lmode > 0 and id1 in (select distinct id1 from<br />
v$lock where request > 0)<br />
If it’s a dead lock, we need to kill that session.<br />
<br />
4. How to kill a database session?<br />
Ans: alter system kill session '&sid,&sno';<br />
<br />
5. How to find adconfig is enabled for oracle operating system user/database?<br />
Ans: If appsutil directory is there in RDBMS_ORACLE_HOME<br />
<br />
6. Which files tell u the database health?<br />
Ans: alert log file @RDBMS_ORACLE_HOME/admin/<context name="">/bdump</context><br />
<br />
7. How to apply a RDBMS patch?<br />
Ans: Using opatch<br />
<br />
8. How to find opatch is enabled or not for u r database?<br />
Ans: If Opatch directory exists under RDBMS_ORACLE_HOME.<br />
<br />
9. What is the pre-req for applying a RDBMS patch?<br />
Ans: Inventory should be set in file oraInst.loc @/var/opt/oracle or /etc<br />
<br />
10. What is Inventory?<br />
Ans: The oraInventory is the location for the OUI (Oracle Universal Installer)'s<br />
bookkeeping. The inventory stores information about:<br />
o All Oracle software products installed in all ORACLE_HOMES on a machine<br />
o Other non-Oracle products, such as the Java Runtime Environment (JRE)<br />
In a 11i Application system the RDBMS and iAS ORACLE Homes are registered in the oraInventory. The 806 ORACLE_HOME, which is not managed through OUI, is not.<br />
<br />
11. What are different types of inventories?<br />
Ans: The Global inventory (or Central inventory)<br />
The Local inventory (or Home inventory)<br />
<br />
12. What is Global inventory?<br />
Ans: The Global Inventory is the part of the XML inventory that contains the high level list of all<br />
oracle products installed on a machine. There should therefore be only one per machine. Its<br />
location is defined by the content of oraInst.loc.<br />
The Global Inventory records the physical location of Oracle products installed on the machine,<br />
such as ORACLE_HOMES (RDBMS and IAS) or JRE. It does not have any information about<br />
the detail of patches applied to each ORACLE_HOMEs.<br />
The Global Inventory gets updated every time you install or de-install an ORACLE_HOME on the<br />
machine, be it through OUI Installer, Rapid Install, or Rapid Clone.<br />
Note: If you need to delete an ORACLE_HOME, you should always do it through the OUI deinstaller<br />
in order to keep the Global Inventory synchronized.<br />
<br />
13. What is local inventory?<br />
Ans: There is one Local Inventory per ORACLE_HOME. It is physically located inside the<br />
ORACLE_HOME at $ORACLE_HOME/inventory and contains the detail of the patch level for<br />
that ORACLE_HOME.The Local Inventory gets updated whenever a patch is applied to the ORACLE_HOME, using OUI.<br />
<br />
14. What is rapid clone?<br />
Ans: Rapid Clone is the new cloning utility introduced in Release 11.5.8. Rapid Clone<br />
leverages the new installation and configuration technology utilized by Rapid Install<br />
<br />
15. How do I determine if my system is rapid clone enabled?<br />
Ans: First, verify that your system is AutoConfig enabled. Then, verify that you have<br />
applied the latest Rapid Clone patch.<br />
<br />
<br />
16. What is the location of adpreclone.pl for oracle user?<br />
Ans: RDBMS_ORACLE_HOME/appsutil/scripts/<context name=""></context><br />
<br />
17. What is the location of adpreclone.pl for applmgr user?<br />
Ans: $COMMON_TOP/admin/scripts/<context name=""></context><br />
<br />
18. What is the location of adcfgclone.pl for oracle user?<br />
Ans: $RDBMS_ORACLE_HOME/appsutil/clone/bin<br />
<br />
19. What is the location of adcfgclone.pl for applmgr user?<br />
Ans: $COMMON_TOP/clone/bin<br />
<br />
<br />
20. What is form server URL?<br />
Ans: http://hostname.domain:<port>/dev60cgi/f60cgi</port><br />
<br />
21. What is jinitiator?<br />
Ans: Oracle jinitiator is the one which provide the required jvm to run forms<br />
interface/applet. When we access forms applet first time, oracle jinitiator will be<br />
installed automatically.<br />
<br />
22. What is discoverer server?<br />
Ans: Discoverer server is reporting tools which allow no voice user to use oracle<br />
application reports. Discoverer will come along with oracle applications when<br />
installed.<br />
<br />
23. What is discoverer viewer URL?<br />
Ans: http://hostname.domain:<port>/discoverer4i/viewer</port><br />
<br />
24. What is discoverer plus URL?<br />
Ans: http://hostname.domain:<port>/discwb4/html/english/welcome.htm</port><br />
<br />
25. What is aoljtest and its url?<br />
Ans: Aoljtest is a web based utility to test the availability of the different<br />
components of oracle applications like jserv, modplsql, jsp, forms etc<br />
URL: http://hostname.domain:<port>/OA_HTML/jsp/fnd/aoljtest.jsp</port><br />
<br />
26. What is adsplicer?<br />
Ans: Adsplicer is a utility used to register off cycle products.<br />
<br />
27. What is license manager?<br />
Ans: License manager(adlicmgr) utility is used to licence/unlicence , enable new<br />
languages,enbale country specific functionality.<br />
<br />
28. What is tnsping?<br />
Ans: tnsping is command used to check the connectivity to the database server<br />
node from other nodes.<br />
Ex: tnsping <dbsid></dbsid><br />
Note: Tns entry should be there in tnsnames.ora for the database we are trying<br />
to work this command.<br />
<br />
29. What is top command?<br />
Ans: top is a operating system command, it will display top 10 processes which<br />
are taking high cpu and memory.<br />
<br />
30. How to compile a form using f60gen?<br />
Ans: f60gen module=/TEST/testappl/au/11.5.0/forms/F/ARXTWMAI.fmb<br />
userid=APPS/APPS outputfile=/TEST/testappl/ar/11.5.0/forms/F/ARXTWMAI.fmx module type=form<br />
batch=yes compile all=special<br />
<br />
31. What is APPLPTMP environment variable?<br />
Ans: This is the temporary file location for the pl/sql temp files. If this variable was<br />
not set then the concurrent programs may errored out.<br />
<br />
32. What is mean by enabling maintenance mode?<br />
Ans: Maintenance mode is the adadmin option introduced from AD.I. When<br />
maintenance mode is enabled user may able to login to application but they only<br />
get profile option in the front-end navigation menu.<br />
<br />
33. Is that necessary to enable maintenance mode while applying a patch?<br />
Ans: We can even apply a patch without enabling maintenance mode with the<br />
following option adpatch options=hot patch<br />
<br />
34. How to find out oracle application framework version?<br />
Ans: 1. through aoljtest<br />
2. cd $COMMON_TOP/html/<br />
3. adident Header OA.jsp<br />
<br />
35. How to find out what are the rdbms patches applied to an oracle home?<br />
Ans: 1. opatch –lsinventory<br />
2. $RDBMS_ORACLE_HOME/.patch_storage directory contains the<br />
directories with the rdbms patch number, which is applied to this oracle home.<br />
<br />
36. Is that necessary to shutdown database while applying a database patch?<br />
Ans: Yes.<br />
<br />
37. What is the command line utility to submit a concurrent request?<br />
Ans: CONSUB<br />
<br />
38. What is the significance of utl_file_dir parameter in init.ora file?<br />
Ans: The value of this parameter is the group of directories to which u r database<br />
can write, means u r database packages have permission to write to flat files in<br />
these directories.<br />
<br />
39. How you will find out discoverer version?<br />
Ans: cd $806_ORACLE_HOME/discwb4/lib<br />
Strings libd* | grep 'Version:'BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com0tag:blogger.com,1999:blog-3711284095029656661.post-1253520701332475822010-03-27T00:10:00.000-07:002010-03-27T10:49:39.091-07:00Oracle Apps DBA - Configuration1. How to find out what component of u r oracle applications was installed on<br />
which node?<br />
Ans: Xml file (context file)<br />
<br />
2. How to find the version of httpd/Apache web server?<br />
Ans: $IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version<br />
<br />
3. What is the configuration file for httpd and what is the location of it ?<br />
Ans: httpd.conf @IAS_ORACLE_HOME/Apache/Apache/conf<br />
<br />
4. Where you will see when you have some problem with u r web server<br />
(httpd/Apache)?<br />
Ans: access_log & error_log @IAS_ORACLE_HOME/Apache/Apache/logs<br />
<br />
5. When Apache starts what other components its start?<br />
Ans: PL/SQL Listener, Servlet Engine, OJSP Engine<br />
<br />
6. What is jserv?<br />
Ans: jserv is nothing but servlet engine which will run u r servlets. It’s a module of apache which supports servlets.<br />
<br />
7. What is self service application?<br />
Ans: Whatever part of u r oracle application u r able to see through web browser is self service.<br />
<br />
8. Where u will see when u r not able to get self service applications?<br />
Ans: access_log, error_log, error_pls, jserv.log, wdbsvr.app(for apps password)<br />
<br />
9. What is the location of jserv.log?<br />
Ans: IAS_ORACLE_HOME/Apache/Jserv/log<br />
<br />
10. What is the location of wdbsvr.app?<br />
Ans: IAS_ORACLE_HOME/Apache/modplsql/cfg<br />
<br />
11. What are jserv.conf and jserv.properties files?<br />
Ans: These are the configuration files which were used to start jvm’s (servlet<br />
engine) by apache.<br />
<br />
12. What is mean by clearing cache and bouncing apache?<br />
Ans: 1. Stop apache (adapcctl.sh stop apps)<br />
2. Clear cache – Go to $COMMON_TOP/html/_pages and delete _oa_html<br />
directory (rm –r _oa__html)<br />
3. Start apache (adapcctl.sh start apps)<br />
<br />
13. What is forms configuration file and its location?<br />
Ans: appsweb_contextname.cfg @$COMMON_TOP/html/bin<br />
<br />
14. What are the different modes u can start u r form server?<br />
Ans: socket and servlet<br />
<br />
15. What is the difference between socket and servlet mode?<br />
Ans: In socket mode forms sessions are represented by f60webmx<br />
In servlet mode forms sessions are represented by apache processes.<br />
<br />
16. What are forms metric server and client?<br />
Ans: When there are more than one form sever instances then forms metric<br />
server and client will be used to load balance.<br />
<br />
17. Where the forms server related errors will be logged?<br />
Ans: access_log and error_log<br />
<br />
18. What are report server configuration and log file name and its location?<br />
Ans: Configuration file – REP_<sid>.ora<br />
Log file – REP_<sid>.log @806_ORACLE_HOME/reports60/server<br />
</sid></sid><br />
19. What is CGIcmd.dat file and its location?<br />
Ans: CGIcmd.dat file is the run time parameter file the report server located @<br />
806_ORACLE_HOME/reports60/server<br />
<br />
20. What is the significance of DISPLAY variable?<br />
Ans: Vnc server should be up and running at the specified port value in DISPLAY variable, otherwise report server may not able to show the graphics in<br />
Reports.<br />
<br />
21. Where is the concurrent manager log file located?<br />
Ans: $COMMON_TOP/admin/<sid>/log or $APPLCSF/$APPLLOG<br />
</sid><br />
22. Is apps password necessary to start all the components of oracle<br />
application?<br />
Ans: No. Only to start/stop concurrent manager’s apps password is needed.<br />
<br />
23. What are dbc file and its location?<br />
Ans: dbc file contain database connection information. DBC file is used by oracle applications to connect to database. Its location is $FND_TOP/secure<br />
<br />
24. What is the other script by which u can start apache other than adapcctl.sh?<br />
Ans: apachectl @IAS_ORACLE_HOME/Apache/bin<br />
<br />
25. What is the configuration file for PL/SQL listener?<br />
Ans: httpd_pls.conf @IAS_ORACLE_HOME/Apache/Apache/conf <br />
<br />
26. How to find form server version?<br />
Ans: f60gen and press enter, it will tell u the form server version or we can find out from the front-end using help menu.<br />
<br />
27. What is RRA?<br />
Ans: RRA stands for Report Review Agent. RRA is nothing but FNDFS which is<br />
part of apps listener. RRA job is to pick the log/out file from the file system and show on the editor when u press view log/out button in ‘View concurrent requst form’.<br />
<br />
28. What is apps listener?<br />
Ans: Apps listener is the combination of FNDFS and FNDSM. FNDSM is service<br />
manager which will monitor application services on that node when GSM: enable profile value is ‘Y’.<br />
<br />
29. What is GSM?<br />
Ans : GSM stands for Generic service Manager, which will monitor application<br />
processes like web, forms etc and restarts any of this processes if goes down.<br />
<br />
30. How to find the application version like 11.5.8/11.5.9….?<br />
Ans: select release_name from fnd_product_groups;<br />
<br />
31. How to find out what are the languages enabled in u r applications?<br />
Ans: Query fnd_languagesBalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com1tag:blogger.com,1999:blog-3711284095029656661.post-39043058582847748932010-03-27T00:06:00.000-07:002010-03-27T00:06:08.809-07:00Oracle Apps DBA - Adutilities1. What is for “validating apps schema” option in adadmin?<br />
<br />
Ans: It will check for the corrupted objects in apps schema<br />
<br />
2. What is “compile apps schema” option in adadmin?<br />
Ans: It will compile the invalid database objects.<br />
<br />
3. How to find MRC is enabled or not?<br />
Ans: In adadmin if covert to MRC options is there, then MRC is not enabled.<br />
If maintain MRC options is there, then MRC is enabled.<br />
<br />
4. How to find Multi-Org is enabled or not?<br />
Ans: In adadmin if covert to Multi org option is there, then Multi-org is not<br />
enabled. If maintain multi-org options is there, then Multi-org is enabled.<br />
<br />
5. What is mean by MRC?<br />
Ans: MRC stands for Multiple reporting Currency, this should be enabled to see<br />
the reports in different currencies like (rupees, yaans etc).<br />
<br />
6. What is Multi-Org?<br />
Ans: If this is enabled we can store multiple organization information in a single oracle application instance.<br />
<br />
7. What is the configuration file for ad utilities (like adadmin,adconfig etc)?<br />
Ans: adconfig.txt @APPL_TOP/admin<br />
<br />
8. What is adrelink?<br />
Ans: adrelink will relink the executables with the libraries. Generally we will go for adrelink when some patch delivers some library files, or when executables were corrupted.<br />
<br />
9. How to find the version of a file?<br />
Ans: 1. adident Header <filename><br />
2. Strings -a filename | grep Header<br />
</filename><br />
10. What is adodfcmp utility?<br />
Ans: This utility is used to recreate/repair corrupted database objects from<br />
odf(object definition files) files.<br />
<br />
11. How you will change apps password?<br />
Ans: FNDCPASS 0 y apps/<pwd> system/<pwd> SYSTEM APPLSYS <new><br />
pwd><br />
</new></pwd></pwd><br />
12. what if apps password is changed with alter command?<br />
Ans: Applications won’t work.<br />
<br />
13. What is the difference between alter and FNDCPASS in changing apps<br />
password?<br />
Ans: FNDCPASS will update some fnd tables other than standard tables.<br />
<br />
14. Where the FNDCPASS utility is located?<br />
Ans: Concurrent node @FND_TOP/binBalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com1tag:blogger.com,1999:blog-3711284095029656661.post-21102758032114574932010-03-26T23:56:00.000-07:002010-03-26T23:56:34.410-07:00Oracle Apps DBA - Concurrent Managers1. What is a concurrent manager?<br />
Ans: A concurrent manager is one which runs concurrent requests.<br />
<br />
2. What are the different types of concurrent managers?<br />
Ans: 1. internal concurrent manager – Will start all other managers and monitor<br />
2. Standard Manager – All concurrent requests by default will to go this<br />
3. Conflict resolution manager – Concurrent programs with<br />
incompatibilities will be handled by this<br />
4. Transaction manager – Handle all transaction requests<br />
<br />
3. What are actual and target count in ‘Administer Concurrent Managers form’?<br />
Ans: Target is the no. of concurrent processes a manager is supposed to start<br />
(specified in the definition of concurrent manager).<br />
Actual is the no. of processes a manager started actually.<br />
Target and Actual should be always same.<br />
<br />
4. What if Target and Actual are not same?<br />
Ans: It means at operating system level resources are low to accommodate the<br />
required processes for concurrent managers.<br />
<br />
5. What are work shifts?<br />
Ans: Work shifts are nothing but timings at which the concurrent manager is<br />
supposed to run.<br />
<br />
6. What if internal concurrent manager target and actual are not same?<br />
Ans: we need to bounce the concurrent manager using adcmctl.sh<br />
<br />
7. How to bounce a single concurrent manager?<br />
Ans: From front-end using ‘Administer Concurrent Manager form’.BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com0tag:blogger.com,1999:blog-3711284095029656661.post-89018016652943732022010-03-26T23:39:00.000-07:002010-03-26T23:41:58.503-07:00Oracle Apps DBA - Autoconfig1. What is autoconfig?<br />
Ans: Autoconfig is an ad utility which is used to main application environment and configuration files.<br />
<br />
2. What are the parameter autoconfig will ask for?<br />
Ans: Context file name and apps password<br />
<br />
3. What is context file?<br />
Ans: Context file is a central repository, which stores all application configuration information. The name is like <instance name="">_ <server name="">.xml</server></instance><br />
<br />
4. How you will find autoconfig is enabled/not for u r applications?<br />
Ans:<br />
1. Open any env / configuration files, the first few lines will tell u that these files are maintained by autoconfig.<br />
2. If contextname.xml file is there in APPL_TOP/admin<br />
<br />
5. How autoconfig will create env and configuration files?<br />
Ans: Autoconfig will go to each and every top template directory take the<br />
templates from there and fill the values from xml file and create the required files.<br />
<br />
6. In how many phases autoconfig will run?<br />
Ans: Autoconfig will run in 3 phases.<br />
1. INIT – Instantiate the drivers and templates<br />
2. SETUP – Fill the template with values from xml and create files<br />
3. PROFILE – Update the profile values in database.<br />
<br />
7. What is the location of adconfig log file?<br />
Ans: APPL_TOP/admin/<context_name>/log/<timestamp directory=""><br />
</timestamp></context_name><br />
8. Is it possible to restore a autoconfig run?<br />
Ans: Partially. Adconfig will create a restore script at<br />
$APPL_TOP/admin/<context_name>/out/<timestamp directory="">. This restore.sh will copy the backed up files before autoconfig run to its original locations. But the profile values updated in the database can’t be restored back.</timestamp></context_name><br />
<br />
9. How to run autoconfig in test mode?<br />
Ans: adchkcfg.sh script at AD_TOP/bin. This script will run autoconfig in test<br />
mode and create the difference file which tells us what is going to change, when u actually run autoconfig.<br />
<br />
10. How to find autoconfig is enabled or not for database?<br />
Ans: If we have appsutil directory under RDBMS_ORACLE_HOMEBalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com2tag:blogger.com,1999:blog-3711284095029656661.post-28388018196730742622010-03-26T22:40:00.000-07:002010-03-26T23:53:37.569-07:00Oracle Apps DBA - Patching1. What is a patch?<br />
Ans: A patch can be a solution for a bug/it can be a new feature.<br />
<br />
2. What are the different types of patches?<br />
Ans: one-off, mini packs, family packs, maintenance packs, rollup patches,<br />
consolidated patches.<br />
<br />
3. What is a one-off patch?<br />
Ans: An one-off patch is a small patch of (20-90K size) without any pre-req’s<br />
<br />
4. What is a mini pack?<br />
Ans: A mini pack is one which will upgrade any product patch set level to next<br />
level like AD.H to AD.I<br />
<br />
5. What is Family pack?<br />
Ans: A Family pack is one which will upgrade the patch set level of all the<br />
products in that family to particular patchsetlevel.<br />
<br />
6. What is Maintenance pack ?<br />
Ans: A maintenance pack will upgrade applications from one version to another<br />
like 11.5.8 to 11.5.9<br />
<br />
7. What is a Rollup patch?<br />
Ans: A rollup patch is one which will deliver bug fixes identified after the release of any major application versions like 11.5.8/11.5.9<br />
<br />
8. What is consolidated patch?<br />
Ans: Consolidated patches will come into pictures after upgrades from one<br />
version of applications to another, all post upgrade patches will a consolidated<br />
and given as consolidated patch. <br />
<br />
9. How u will find whether a patch is applied/not?<br />
Ans: Query ad_bugs.<br />
<br />
10. What is the other table where u can query what are the patches applied?<br />
Ans: Ad_applied_patches.<br />
<br />
11. What is the difference between ad_bugs and ad_applied_patches?<br />
Ans: A patch can deliver solution for more than one bug, so ad_applied_patches<br />
may not give u the perfect information as in case of ad_bugs.<br />
<br />
12. How u apply a patch?<br />
Ans: ad patch<br />
<br />
13. What inputs you need to apply a patch other than driver name and etc?<br />
Ans: apps and system passwords<br />
<br />
14. What are the table u r ad patch will create and when?<br />
Ans: Ad patch will create FND_INSTALL_PROCESSES and<br />
AD_DEFERRED_JOBS table when it will apply d, g and u drivers<br />
<br />
15. What is the significance of FND_INSTALL_PROCESSES and<br />
AD_DEFERRED_JOBS table?<br />
Ans: FND_INSTALL_PROCESSES table will store the worker information like<br />
what job is assigned to which worker and its status. AD_DEFERRED_JOBS will<br />
come into picture when some worker is failed, it will be moved to<br />
AD_DEFERRED_JOBS table, from where again adpatch will take that job and try<br />
to resign, after doing this 3 times if still that worker is failing, then adpatch will stop patching and throw the error that particular worker has failed. We need to trouble shoot and restart the worker.<br />
<br />
16. If it is a multinode installation which driver we need to apply on which node?<br />
Ans: c, d, g on concurrent node and c, g on web node. If it is u-driver we need to apply on all nodes.<br />
<br />
17. While applying a application patch is that necessary that u r database and<br />
listener should be up?<br />
Ans: Yes. Why because adpatch will connect to database and update so many<br />
tables etc…..<br />
<br />
18. While applying a patch if that patch is failing because of a pre-req then how you will apply that pre-req patch and resume with the current patch?<br />
Ans: We need to take the backup of FND_INSTALL_PROCESSES and<br />
AD_DEFERRED_JOBS tables and restart directory at APPL_TOP/amdin/SID<br />
and then use adctrl to quit all the workers. Then apply the pre-req patch, after<br />
that rename u r restart directory to its original name and create<br />
FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables from the<br />
backup tables. Start adpatch session and take the options want to continue<br />
previous session.<br />
<br />
19. What is adctrl?<br />
Ans: Adctrl is one of the ad utilities, which is used to check the status of workers and to manage the workers.<br />
<br />
20. Can u name some of the menu options in adctrl?<br />
Ans: Check the status of workers, tell manager that worker has quitted, restart a failed worker etc….<br />
<br />
21. How to skip a worker and why?<br />
Ans: We can skip a worker using option 8 in adctrl which is hidden. We will go for skipping a worker when we have executed the job which the worker is supposed to do.<br />
<br />
22. How adpatch knows what are the pre-req for the patch which it is applying?<br />
Ans: With every patch a file called b<patch number="">.ldt file will be delivered<br />
which contain the pre-req information. Adpatch load this into database using<br />
FNDLOAD and check, whether those pre-req patches were applied or not.</patch><br />
<br />
<patch number="">23. What is FNDLOAD?<br />
Ans: FNDLOAD is a utility which is similar to sql-loader but loads code objects<br />
into database, where as SQLLOADER loads data objects into database.<br />
</patch><br />
<patch number="">24. What c-driver will do?<br />
Ans: C-drive copies the files from patch unzipped directory to required location in u r application file system. Before copying it will check the file version of the<br />
existing file at the file system with the file version of the file in the patch. If the patch file version is higher than what it is at file system level then only c-driver will copy that files.<br />
</patch><br />
<patch number="">25. How adpatch will know the file versions of the patch delivered files?<br />
Ans: With each patch a file with name f<patch number="">.ldt is delivered, which<br />
contain the file versions of the files delivered with the patch. Adpatch will use this file to compare the file versions of files it’s delivering with the file on file system.<br />
</patch></patch><br />
<patch number="">26. What is the adpatch log file location?<br />
Ans: APPL_TOP/admin/SID/log<br />
</patch><br />
<patch number="">27. What are the worker log file name and its location?<br />
Ans: adwork01, adwork02…… and location is APPL_TOP/admin/SID/log<br />
</patch><br />
<patch number="">28. How u will know what are the files the patch is going to change just my<br />
unzipping the patch?<br />
Ans: When u unzip a patch it will keep all the files related to a particular product under that directory inside u r patch directory for example if the patch delivering files related to FND product then it will create a sub directory under the patch directory with the name FND in which it will put all related files to that product<br />
</patch><br />
<patch number="">29. What is the significance of backup directory under u r patch directory?<br />
Ans: When we apply a patch it will keep the copy of the files which its going to<br />
change in file system.<br />
</patch><br />
<patch number="">30. What are the different modes you can run your adpatch?<br />
Ans: 1.Interactive – default mode<br />
2. Non interactive – Use defaults files to store prompt values<br />
(Adpatch defaults file=<filename> interactive=no)<br />
3. Test – Without actually applying a patch just to check what its<br />
doing.(adpatch apply=no)<br />
4. Pre-install – (adpatch preinstall=y) this mode will be useful to decrease<br />
upgrade downtime as it applies bug fixes without running SQL, EXEC and<br />
generate portion of patch.<br />
</filename></patch><br />
<patch number="">31. How u will monitor u r applications as well as database?<br />
Ans: We have our custom scripts which are scheduled to run at a specific time<br />
which will monitor whether applications and databases are up/not. And it will mail us if some processes is not running. And we have one script which will check database alert log for ORA errors and mails it to us . Based on this we will react. </patch><br />
<br />
<patch number="">32. When a patch delivers java files what extra file u will get when u unzip the<br />
patch, other then u r driver and read me files?<br />
Ans: j<patch number="">.zip<br />
</patch></patch><br />
<patch number="">33. What is apps.zip/appsbrog2.zip file?<br />
Ans: apps.zip/appsbrog2.zip is the patchable archive of all java class files<br />
required for oracle application.<br />
Apps.zip was used to old application version, but from 11.5.8 onwards its<br />
appsbrog2.zip<br />
</patch><br />
<patch number="">34. What is the location of apps.zip/appsbrog2.zip?<br />
Ans: AU_TOP/java and JAVA_TOP</patch><br />
<patch number=""> </patch><br />
<patch number="">35. How to skip copy portion while applying a patch?<br />
Ans: Adpatch options=nocopyportion<br />
</patch><br />
<patch number="">36. How to merge patches and what type of patches can be merged?<br />
Ans: admrgpch. We can merge any kind of application patches, if any of the<br />
patch contain a u-driver then merged patch will contain u_merged.drv otherwise c_merged.drv, d_merged.drv and g_merged.drv</patch>BalaGanesh Gembalihttp://www.blogger.com/profile/03733513523646777561noreply@blogger.com0