All posts by Masroof Ahmad
RAC Basics : CRS, Voting Disk, OCR, Cache Fusion ….
Oracle Clusterware (Cluster Ready Services in 10g/ Cluster Manager in 9i) – provides infrastructure that binds multiple nodes that then operate as single server. Clusterware monitors all components like instances and listeners. There are two important components in Oracle clusterware, Voting Disk and OCR (Oracle Cluster Registry). . Voting Disk – is file that resides […]
Read MoreOracle Service Bus << AquaLogic Service Bus (BEA) + Oracle Enterprise Service Bus (Oracle)
BEA’s AquaLogic Service Bus (ALSB) and Oracle’s Enterprise Service Bus (ESB) are now called as Oracle Service Bus (OSB). . Use of Service Bus (SB): Service Bus offers connectivity options (for standard interfaces like SOAP, messages .. and packaged applications & legacy system via adapters), messaging & routing (efficient, reliable and secure flow of data) , […]
Read MoreApplication Object Library is unable to reconnect to your gateway ORACLE account
While starting Apache (Web Server) in E-Business Suite 11i using “adapcctl.sh start“, I got below error message *********** Cannot reconnect to gateway Cause: Application Object Library is unable to reconnect to your gateway ORACLE account after you unsuccessfully attempted to sign-on. Action: Check that your gateway environment variable is set correctly. *********** My first attempt […]
Read MoreHow to find out Schema Passwords in a 10gAS Application Server
There are two basic methods to find out the schema passwords in a Oracle 10gAS Application Server:- A) Steps (through the ODM tool):- 1) Log onto the host that hosts the infrastructure tier (e.g. host is – ausable) using x-windows like Hummingbird. 2) Log on as user “oracle” – the user that did the install. […]
Read MoreLDAP Installation and Migration
How to Migrate LDAP server to another machine with same architecture? The following article explains simple way to install and migrate LDAP server. I have taken two machines (host1.example.com and host2.example.com) with Oracle Enterprise Linux 4, as it is available free. Host1 machine is already installed and running with LDAP server and now we need to […]
Read MoreHow to create user for Read only responsibilites in frontend apps
Steps mentioned below are to create User with Read Only Responsibility and require fair amount of development knowledge 1. Go to $Au_TOP/resource. 2. Copy CUSTOM.pll and open the file in Form builder. 3. If you will open the package body of CUSTOM.pll in the forms builder then you will find the like below : procedure […]
Read MoreTest your Apps DBA skills – Interview Questions for Oracle Apps DBAs
Q. How would you know that your applications setup is a using shared APPL_TOP configuration ? – If you apply a patch, it should be visible on all nodes (APPL_TOP) which are part of shared APPL_TOP configuration. – Since APPL_TOP is on a shared disk, create file in APPL_TOP from one node, it should be […]
Read MoreOracle AIA Foundation Pack : Installation
Application Integration Architecture (AIA) Foundation pack consist of —Enterprise Business Objects (EBO) —Enterprise Business Messages (EBM) —Enterprise Business Services (EBS) —Core Infrastructure Components (Composite Application Validation, Business Service Repository, Error Handling and logging, Diagnostics) . Key Points Good to know with AIA Installation 1. Application Integration Architecture (AIA) Foundation pack runs on Oracle SOA Suite. […]
Read MoreManaging Yum @ Redhat / Oracle Enterprise 4
Most of the times while we are installing prerequisites for the oracle installation, its some what painful to get the updated rpms and dependencies, especially in Redhat Enterprise and Oracle Enterpirse version 4. The following document explains us to overcome this issue. Yum is the easiest way to keep all programs up to date. It […]
Read MoreUpgrade Oracle Application Server to 10.1.3.4 (10g R3 patchset 4)
This post covers overview of applying Oracle Application Server 10g R3 patchset 4 (10.1.3.4) on existing 10g R3 (10.1.3) Key Points for 10.1.3.4 Upgrade 1. Patch Number for OAS 10g R3 patchset 4 (10.1.3.4) is 7272722 2. 10g R3 patchset 4 (10.1.3.4.0 – 7272722) is cumulative and includes all fixes from 10.1.3.0, 10.1.3.1, 10.1.3.2 and […]
Read More