Steps to upgarde 11i Application database to 11gR1 1) Oracle Application Prerequisites patches before upgrade : Interoperability notes for Oracle Applications 11i with 11gR1 – 452783.12) Install Oracle 11.1.0.x software 3) run pre upgrade tool 4) collect stats on database 5) Check for Connect Role and get user or role list which are having the …
Steps to upgarde 11i Application database to 11gR1 Read More »
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 …
“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 …
ORA-20001 in R12 Gather schema statistics on 11g(FND_HISTOGRAM_COLS) Read More »
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 …
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 …
The PL/SQL Gateway in R11i provides support for building PL/SQL-based applications on the Web. PL/SQL stored procedures can retrieve data from a database and generate HTTP responses containing data and code to display in a Web browser. Also can upload/download file to oracle database table from browser and access that file from the browser. also …
PL/SQL Gateway in R11i Read More »
