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 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 »

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 »

How to correct error RMAN-20004

Last updated on December 21st, 2015 at 04:14 amProblem:When Recovery catalog has been configured.and Production Database has been cloned and a connection has been made from the clone to Catalog database using rman with out changing the DBID of the clone,then we are in some trouble Then when you try to backup the production instance with the catalog,The backup fails with following error RMAN-06004: ORACLE … Continue reading How to correct error RMAN-20004 »

How to add debug codes in the application executable

Last updated on December 21st, 2015 at 03:53 amIt often happens the executable are either coredumping or not behaving exactly.We need to debug the executable. Here are the General steps on How to add debug codes in the application executable. Infact these are steps even followed  by adpatch to replace lib files in the product executables Let’s say that you need to link the object file … Continue reading How to add debug codes in the application executable »

Staged APPL_TOP in R12

Last updated on September 1st, 2016 at 05:22 amA staged Applications system represents an exact copy of your Production system, including all APPL_TOPs as well as a copy of the Production database. Patches are applied to this staged system, while your Production system remains up. When all patches have been successfully applied to the test system, the reduced downtime for the Production system can begin. … Continue reading Staged APPL_TOP in R12 »

Oracle apps:Topology information

Last updated on November 23rd, 2015 at 03:32 pmHere is the statement to find out Topology information for R12/R11i SELECT fn.HOST || ‘.’ || fn.DOMAIN HOSTNAME, ftlp.PORT, fdi.SID SID FROM FND_DATABASES fd, FND_DATABASE_INSTANCES fdi, FND_TNS_LISTENERS ftl, FND_TNS_LISTENER_PORTS ftlp, FND_APP_SERVERS fas, FND_NODES fn WHERE fd.DB_GUID=fdi.DB_GUID AND fdi.SERVER_GUID=fas.SERVER_GUID AND ftl.LISTENER_GUID = ftlp.LISTENER_GUID AND ftl.SERVER_GUID = fas.SERVER_GUID AND fn.NODE_ID = fas.NODE_ID; select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES where FND_APP_SERVERS.NODE_ID … Continue reading Oracle apps:Topology information »