Oracle Applications

Change the WebLogic password How do you change password  in EBS 12.2 for weblogic  The following sections show the steps for updating the WebLogic password for Txk Delta 7 and later and for versions earlier than Txk Delta 7. TKX DELTA 7 AND LATER The following steps apply to WebLogic Txk Delta 7 and later: ⦁ Run the following command to source the run filesystem, shut down all application tier services except the Admin Server, and ensure that no application services (except admin server and node manager) are running on the primary application server: ⦁ adstpall.sh apps/apps_password -mode=allnodes -skipNM -skipAdmin ⦁ Run the following command to change the Weblogic administration password and start the services: ⦁ perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword The system prompts you for the Apps password, the old WebLogic password and the new WebLogic password. Following is some sample output from this process: $ perl $FND_TOP/patch

How to perform Non Rac to Rac database clone Convert Single Instance to RAC – Part 1: Duplicate DB using RMAN This article is for users of Oracle Database version 10g+ who want to convert their Oracle single instance database to RAC. I will provide detailed procedure for converting non-RAC database to RAC and we will use Oracle Automatic storage management (ASM) as shared storage. In general, if the database is small then you can consider installing a new RAC database… This article is for users of Oracle Database version 10g+ who want to convert their Oracle single instance database to RAC.  I will provide detailed procedure for converting non-RAC database to RAC and we will use Oracle Automatic storage management (ASM) as shared storage. In general, if the database is small then you can consider installing a new RAC database and export/import your current database. If the database is large then using RMAN for migration would be one of the preferred methods.  If your single instan

This is mostly asked during interviews for Apps DBA's All About Oracle Parallel Concurrent Processing (PCP) All About Oracle Parallel Concurrent Processing (PCP) 1) What is PCP    - Parallel Concurrent Processing (PCP) is an extension of the Concurrent Processing architecture.    - PCP allows concurrent processing activities to be distributed across multiple nodes, maximizing throughput and providing resilience to node failure. 2) How to Configure Parallel Concurrent Processing (PCP)   Below are steps to configure the PCP in Oracle Applications.   A) Set Up PCP     - Edit the applications context file via Oracle Applications Manager, and set the value of the variable APPLDCP to ON.   - Execute AutoConfig by running the following command on all concurrent processing nodes:   - $ $INST_TOP/admin/scripts/adautocfg.sh   - Source the Applications environment.   - Check the tnsnames.ora and listener.ora configuration files, located in $INST_TOP/ora/10.1.2/netw

1. What is the use of ASM (or) Why ASM preferred over filesystem? Answer: ASM provides striping and mirroring. a) Provides automatic load balancing over all the available disks, thus reducing hot spots in the file system. b) Prevents fragmentation of disks, so you don’t need to manually relocate data to tune I/O performance. c) Adding disks is straight forward – ASM automatically performs online disk reorganization when you add or remove storage. d) Uses redundancy features available in intelligent storage arrays. e)The storage system can store all types of database files. f) Using disk group makes configuration easier, as files are placed into disk groups. 2. What are the init parameters related to ASM? Answer: INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 ASM_DISKSTRING = '/dev/rdsk/*s2', '/dev/rdsk/c1*' ASM_DISKGROUPS = DG_DATA, DG_FRA 3. What is rebalancing (or) what is the use of ASM_POWER_LIMIT? Answer: ASM_POWER_LIMIT is dynamic parameter, which wi

In interview questions are asked like what is undo,what it contains? What Is Undo? Every Oracle Database must have a method of maintaining information that is used to roll back, or undo, changes to the database. Such information consists of records of the actions of transactions, primarily before they are committed. These records are collectively referred to as undo. Undo records are used to: Roll back transactions when a ROLLBACK statement is issued Recover the database Provide read consistency Analyze data as of an earlier point in time by using Oracle Flashback Query Recover from logical corruptions using Oracle Flashback features When a ROLLBACK statement is issued, undo records are used to undo changes that were made to the database by the uncommitted transaction. During database recovery, undo records are used to undo any uncommitted changes applied from the redo log to the datafiles. Undo records provide read consistency by maintaining the before image of the data fo

This is an important interview question asked in every interview if you have experience in 12.2 Online Patching Cycle Steps - Prepare Phase This section describes the principles of adop operation in the prepare phase, followed by the steps you take to run this phase. Note: The exact actions taken during the prepare phase are context-dependent: for example, the first time it is ever run on a system; when it is run after an apply phase has been aborted; and when it has been run after cutover. Principal adop Actions During the prepare phase, adop performs the following steps. ⦁ Checks whether to perform a cleanup, which will be needed if the user failed to invoke cleanup after the cutover phase of a previous online patching cycle. ⦁ Validates system configuration to ensure that the system is ready to start an online patching cycle. ⦁ Checks to see if the database is prepared for online patching: ⦁ Checks if the database user is edition-enabled. If not, adop immediately exi