mod_wl_ohs: is a module in Oracle HTTP Server 11g R1 which allows requests to be proxied from Oracle HTTP Server (OHS) to Oracle WebLogic Server. mod_weblogic: This module is part of Apache HTTP Server and allows requests to be proxied from Apache HTTP Server to Oracle WebLogic Server. For difference between mod_wl_ohs and mod_weblogic click here Things good to know about configuring […]
Read MoreLast month I discussed 11g Identity Management (OID, DIP, OVD and OIF) installation here , today’s post covers issues encountered during 11g OID/OVD installation on Linux. 1. Set hard file and soft file limit to at-least 4096 for user installing 11g Identity Management (OID) . /etc/security/limits.conf <os_user> hard nofile 4096 <os_user> soft nofile 4096 If O.S. […]
Read MoreAD4J – Application Diagnostics for Java JADE – Java Application Diagnostics Expert Application Diagnostics for Java (AD4J aka JADE – Java Application Diagnostics Expert) is lightweight application to diagnose performance issues in Java Applications (including Database Tier) . AD4J Architecture 1. AD4J Console : is web based console to setup/monitor performance of Java Virtual Machine […]
Read MoreToday’s post is little different from my other posts as I need your help to identify right diagnostic tool for performance issues in Oracle Fusion Middleware (10g & 11g). Issue : My client is using Oracle Fusion Middleware; 10g R2 (Portal/SSO/OID), 10g R3 (custom J2EE application) and 11g R1 (SOA on WebLogic). Application response time is acceptable for approx. 200 concurrent […]
Read MoreOracle Instance – Oracle Instance contains one or more system components *( HTTP Server, WebCache, Oracle Internet Directory). Oracle Instance Directory contains updatable files like configuration files, log files. Oracle Instance directory is different from Oracle Home Directory and can reside inside or outside Middleware Home. WebLogic Server– is J2EE application Server in Fusion Middleware […]
Read MoreOracle Webcenter Suite is enterprise Portal solution from Oracle. This post covers installation overview of Oracle WebCenter Suite 11g R1 (step by step installation document on Linux coming in next post) . Components of Oracle WebCenter A. Oracle WebCenter Framework B. Oracle WebCenter Spaces C. Oracle Composer D. WebCenter Services – Discussions, Blog, Wiki For […]
Read MoreQ. What happens when you run ALTER DATABASE OPEN RESETLOGS ? The current online redo logs are archived, the log sequence number is reset to 1, new database incarnation is created, and the online redo logs are given a new time stamp and SCN. . Q. In what scenarios open resetlogs required ? An ALTER […]
Read MoreOracle Data Integrator (ODI) is – product from Sunopsis acquired by Oracle in 2006 and now part of Oracle Fusion Middleware Family. 1. ODI is built on E-LT(Extract , Load and Transform) Architecture. 2. Oracle Data Integrator 10g (10.1.3.5.0) suite includes three products a) Oracle Data Integrator b) Oracle Data Quality and c) Oracle Data Profiling 3. ODI uses […]
Read MoreLet suppose below is the read me file of one patch says: This patch contains one or more driver files to be applied with AutoPatch. Please apply the driver files in the following order (if they exist) : c3196140.drv (This is the copy driver) d3196140.drv (This is the database driver) g3196140.drv (This is the generate […]
Read MoreOn popular request from newbie I am posting few more Apps DBA Interview Questions (around Installation). If you are new to Oracle Apps and prefer book then you can order one from Amazon written by Joyjeet Banerjee – Cracking the Oracle Apps DBA Interview: 325 Frequently Asked Questions Q1. Which user you use to install Oracle Apps 11i/R12 on […]
Read More