Apache is widely used Web server. Oracle HTTP server is based on Apache web server and includes modules developed specifically by Oracle. Here in this section we will have discussion about Apache (Oracle HTTP server) used in EBS 11i and R12 Important Directive in httpd.conf Listen:The Listen directive instructs Apache to listen to more than …
All about Apache(Oracle HTTP Server) in EBS 11i/R12 Read More »
How to setup diag wait in cluster 1. Execute as root#crsctl stop crs #/bin/oprocd stop 2. Ensure that Clusterware stack is down on all nodes by executing #ps -ef |egrep “crsd.bin|ocssd.bin|evmd.bin|oprocd” This should return no processes. If there are clusterware processes running and you proceed to the next step, you will corrupt your OCR. Do …
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 »
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 »
