Archive Monthly Archives: November 2008

Oracle 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 More

Managing 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 More

Upgrade 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

Security in Oracle WebLogic : Realm, Security Provider, Authentication, Authorization, Users

Security Providers – are modules that provide security service to application to protect Weblogic resource. Types of security providers in WebLogic Server are Authentication Provider, Authorization Provider, Auditing Providers, Credential Mapping Provider, Identity Assertion Provider, Principal Validation Provider, Adjudication Providers, Role Mapping Providers, Certificate Lookup and Validation Providers, Keystore Providers and Realm Adapter providers. Security Provider […]

Read More

Verify CBO stats and Database initalization parameters for 11i

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 […]

Read More

Explain Plan In Oracle

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 […]

Read More

Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting

Objective: This paper is related to the Multi Master Replication setup, testing and troubleshooting. Introduction: In this Multi Master Replication testing two machines are being used. There will be two databases on the two different machines i.e. a) Master1 (Master definition Site) This site will be used for the administration of the Replication setup. b) […]

Read More

SQL to monitor (check status) of Workflow Notification Mailer (Java)

 SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS where COMPONENT_ID=10006;  

Read More

Steps / How to Migrate Non ASM Instance Database to ASM Instance

NOTE: Always Do Exercise on Test Environment, First.  Assumptions :  1. ASM Instance is already Created and Ready to Use. 2. DB Instance was Started using ‘spfile’ 3. Disk Group Name : ‘+DGDATA’  – Set the Parameter ‘db_create_file_dest’ to ‘+DGDATA’   alter system set db_create_file_dest=’+DGDATA’ scope=spfile; – Set the Parameter ‘control_file’ to the destination in ASM […]

Read More

JVM Tuning (Garbage Collection) in Oracle Apps 11i

There are some good notes on JVM tuning from Mike Shaw on Steven Chan’s blog  here , here and here and some good Metalink notes at end of this post.                      Important thing missing from all these notes (for some one like me who is new to Java) is basics of Garbage Collection, Generation and how to […]

Read More
Not found