The AOL/J Setup Test suite consists of Java Server Pages (JSPs) designed to trouble-shoot AOL/J setup problems. These JSPs exercise various features of AOL/J and provide feedback on the results. The test suite is accessed from the URL http://:/OA_HTML/jsp/fnd/aoljtest.jsp where host_name and port_number correspond to the host name and port number of your instance’s Apache […]
ORA-20001 in R12 Gather schema statistics on 11g(FND_HISTOGRAM_COLS)
“Gather Schema Statistics” program reported the 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 […]
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(*) COUNTfrom applsys.aq$wf_java_deferred wfjdwhere msg_state IN(‘READY’, ‘WAIT’)group by corr_id, wfjd.msg_state; (2) Shut down the Workflow Agent Listener Service and backup the records on the WF_JAVA_DEFERRED […]
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 […]