There is one important attribute in 11gR2 cluster ie. AUTO_START We can check it using following command $ crsctl status resource ora.TEST.db -p | grep AUTO_START AUTO_START=restore – always: Restarts the resource when the server restarts regardless of the state of the resource when the server stopped. – restore: Restores the resource to the same […]
why-database-not-startup-automatic in 11gR2 cluster 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
AOL/J Setup Test suite Read More »
“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
Oracle Clusterware Read More »
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
how to rebuild the wf_java_deferred queue Read More »
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 »
