“Gather Schema Statistics” program reported following errors in request log files : Error #1: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #2: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #3: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions […]
Oracle Clusterware
What is Oracle cluster The Oracle Clusterware was introduced in 10.1 (initially called CRS ) and is the product that lies under RAC. It enables servers to operate together as if they are one server. Each server looks like any standalone server. However, each server has additional processes that communicate with each other so the […]
how to rebuild the wf_java_deferred queue
Followings 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 […]
ADODFCMP Utility
The ODF Comparison utility(ADODFCMP) 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) […]
How to recover corrupt blocks using RMAN Blockrecover
1. 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 […]
How to set Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL
What 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 […]
