1.       Introduction Real application testing is a powerful features of Oracle which has been introduced in 11g first and then it was back ported to other version including oracle 9i .  In our Eaga specific scenario we have oracle 9.2.0.7 EBS database and we have 11g database with OEM grid cntrol . The real advantage [...]

continue reading.....

Introduction This document is helping us to install Oracle Diag patch using “adpatch” utility . Oracle Diagnostic patch is one of pwerfull features of Oracle E-business Suit .  Pre-Requisites • Oracle E-Business Suite Diagnostics can only be installed on a minimum of E-Business Suite 11.5.4 or above with FND.D and AD.G installed. • The latest Oracle E-Business [...]

continue reading.....

Introduction The database upgradation process for 11G is same as other version of oracle , Either using DBUA or manually. I followed the manual process to accomplish the task. . Prerequisites i). Apply ATG rollup patch 6   5903765  In my case instances was not updated to ATG roll up patch 6 , so I have [...]

continue reading.....

Introduction This document provides a complete, up-to-date description of Oracle iSetup Minipack 11i.AZ.H (5140723). The main focus of iSetup is to help migrate functional setups from one E-Business Suite instance to another. During migration, setups can be extracted selectively using filters on setup attributes. Extracted setup data can be optionally transformed before loading into target [...]

continue reading.....

 We all know that the proper way to add a custom top directory to your E-Business Suite instance is through the ${APPL_TOP}/admin/topfile.txt (Note 216589.1). By adding an entry to that file, AutoConfig will:1) Create the environment variable for you 2) Put it into the context file 3) Update various commonly missed files (formservlet.ini, for example). [...]

continue reading.....

In order to get better performace of the database , we usually schedule Apps Gather schema . Oracle provide very important tool/script to verify the CBO stats . bde_last_analyzed.sql :-verifies the CBO statistics in the data dictionary for all tables, indexes, and partitions. It also validates the statistics on tables and indexes owned by ‘SYS’. This [...]

continue reading.....

One of the most usefull tool which require for both DBAs and Developers to use it effectively to avoid the performance problem of Custom Code specailly in ERP database as well as any database. We should make best use of it.  An execution plan is a list of steps that Oracle will follow in order to execute a SQL [...]

continue reading.....