MWA information for 11i and R12

Last updated on September 19th, 2015 at 07:19 amMobile Warehousing Application is a important components of Oracle Ebuisness Suite and it is used in warehouse to scan items.In this section , i am sharing the information for MWA MWA  information for 11i and R12 MWA Configuration file  for 11i Configuration file is used to set server related properties. Setup mwa.cfg file as follows: 1. Locate … Continue reading MWA information for 11i and R12 »

What is Oracle Clusterware?

Last updated on December 10th, 2018 at 04:38 amThe Oracle Clusterware was introduced in 10.1 (initially called CRS ) and is the product that lies under RAC. Oracle Clusterware provides different services to RAC including: Group Services Node Monitor Locking services HA Resource management Event framework, etc Components.Several components are needed to have CRS running on Unix machine. Here is a brief description of each: … Continue reading What is Oracle Clusterware? »

How to find RAC interconnect information

Last updated on July 26th, 2018 at 09:06 amThe RAC interconnect is a very important part of the cluster environment it is on of the aorta’s of a cluster environment. The interconnect is used as physical layer between the cluster nodes to perform heartbeats as well as the cache fusion is using it. The interconnect must be a private connection. Cross over cable is not … Continue reading How to find RAC interconnect information »

how to rebuild the wf_java_deferred queue

Last updated on December 21st, 2015 at 05:44 amFollowings steps are to be followed to rebuild the queue 1. Check to see what records will be backed up on the wf_queue_temp_jms_table backup table. select wfjd.corr_id corrid, msg_state state, count(*) COUNT from applsys.aq$wf_java_deferred wfjd where msg_state IN(‘READY’, ‘WAIT’) group by corr_id, wfjd.msg_state; 2). Shutdown the Workflow Agent Listener Service and backup the records on the WF_JAVA_DEFERRED … Continue reading how to rebuild the wf_java_deferred queue »

ADODFCMP Utility

Last updated on December 21st, 2015 at 05:40 amThe ODF Comparison utility is used to compare the data model of a customer’s data to a standard set of data model files from the current Oracle Application release. It can optionally modify the database to match the standard data model. Each application consists of certain building blocks. There is an object descriptor file (ODF) describing the … Continue reading ADODFCMP Utility »

Single Client Access Name (SCAN)

Last updated on August 27th, 2016 at 08:41 amWhat is Single Client Access Name (SCAN) It is a new Oracle Real Application Clusters (RAC) 11g Release 2 feature that provides a single name for clients to access Oracle Databases running in a cluster. The benefit is that the client’s connect information does not need to change if you add or remove nodes in the cluster. … Continue reading Single Client Access Name (SCAN) »

How to recover corrupt blocks using RMAN

Last updated on December 21st, 2015 at 05:34 am1. Recovering Data blocks By Using All Available Backups Run the BLOCKRECOVER command at the RMAN prompt, specifying the file and block numbers for the corrupted blocks RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15; Recover multiple blocks in single command RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15 DATAFILE 2 BLOCK 10; 2. Recovering Data blocks Using Selected Backups Run the BLOCKRECOVER … Continue reading How to recover corrupt blocks using RMAN »

How to identify corrupts blocks in the database

Last updated on December 21st, 2015 at 05:35 am1. Run below command to populate v$database_block_corruption view with information of all the corrupted blocks. RMAN> backup validate check logical database; “CHECK LOGICAL” option is used to identify both Physical and Logical Block Corruptions. Select the view to identify the corrupted blocks detected by RMAN. SQL> select * from v$database_block_corruption; Please note, After a corrupt block is … Continue reading How to identify corrupts blocks in the database »

How to create RMAN recovery catalog and register database in catalog

Last updated on July 29th, 2018 at 10:33 amRMAN Recovery catalog is a very important registry. Control file registry get rotated after some time so you lost many backup information. By storing backup information in recovery catalog ,you get rid of this problem Also it provides a central repository where you can find all the backup information. Here are the steps on How to create recovery … Continue reading How to create RMAN recovery catalog and register database in catalog »

How to check if Port pool is free in Oracle applications R12

Last updated on March 30th, 2019 at 12:35 pmWhat is Port Pool? Oracle Applications 11i/R12.0/R12.1/R12.2 uses the concept of a port pool. A port pool is a preconfigured set of unique port assignments for every E-Business Suite technology stack component that requires network connectivity. So multiple Release 12 environments can coexists on the same machine,provided  you have  configured each of them to use a different … Continue reading How to check if Port pool is free in Oracle applications R12 »

FNDCPASS and AFPASSWD

Last updated on March 3rd, 2019 at 06:06 pmFNDCPASS is an important utility in EBS application and it is located in $FND_TOP/bin.  It is used to change password for apps schema, oracle EBS schema password and application user password change. $FNDCPASS FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS FNDCPASS apps/apps 0 Y system/manager ORACLE FNDCPASS apps/apps 0 Y system/manager USER When you execute FNDCPASS, it … Continue reading FNDCPASS and AFPASSWD »

How to set Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL

Last updated on July 28th, 2018 at 04:08 pmWhat is Table Monitoring in Oracle Table monitoring is checking for how many updates,deletes ,insert happened in the tables so that we can find out if the statistics are stale or good for the table .It is a very useful functionality in gathering stats for the tables in Oracle How to Set the  Table Monitoring in Oracle … Continue reading How to set Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL »