Archive Monthly Archives: June 2009

Install Application (11i/R12) Management Pack 3.0 with OEM Grid Control

Oracle Application Management Pack (AMP) for Oracle E-Business Suite : is management pack which sits on top of Oracle Enterprise Manager (OEM) Grid Control to manage (Monitor/System alerting, Cloning, Data Scrambling …) Oracle Applications/E-Business Suite (11i/R12). This post covers installation of Oracle Application Management Pack (AMP) on existing Oracle Enterprise Manager Grid Control Component (Oracle Management Service & Oracle […]

Read More

Single Instance to RAC conversion using DBCA :Part-I

There is three method available, you can use any of them to convert single instance to RAC instance. a. using dbca b. using EM c. using rconfig utility Here we are converting using DBCA (DataBase Configuration Assistant). Conversion of single instance database to RAC database using DBCA consists of two part. In first part, we […]

Read More

Installing Oracle Enterprise Manager (OEM) Grid – Management Agent

This post covers installation of Oracle Enterprise Management (OEM) Grid Management Agents on Machine which you are planning to monitor using Oracle Enterprise Manager Grid Control. What is OEM Grid Control Management Agent ? Management Agent is software installed on node (machine) which you are planning to monitor. Agent collects information on target node (Host, […]

Read More

Automate SSH Authorization

I usually work on Linux machines. every time its a time taking task to generate ssh key generation between servers and copy the authorization key. i have a small script which will generate and copy the files to your desired destinations and makes your task easy Login to server A #ssh-keygen -t rsa -b 2048 […]

Read More

Oracle Enterprise Manager (OEM) – Basics

Oracle Enterprise Manager (OEM) Grid Control is monitoring software for Oracle Database, Fusion MiddleWare (FMW including OAS & SOA Suite), Oracle E-Business Suite, Siebel, SAP …. This post covers overview of various components in OEM Grid Control Oracle Enterprise Manager (OEM) / Grid Control Component 1. Oracle Management Agent: is software that sits on all nodes(machines) which you would like […]

Read More

Discoverer with Oracle Apps R12

Oracle Discoverer is used to analyze data (ad hoc query, analysis, reporting and publishing) from selected business area like Financials, HR, Manufacturing …  For Discoverer basics click here 1. There are two version of Discoverer i) Standalone Discoverer – No support for Oracle SSO, Portlet Provider or Discoverer Connection Management ii) Discoverer with OracleAS Infrastructure […]

Read More

FRM-92101 with Internet Explorer 8 – How to uninstall IE8

If automatic updates are enabled on your Windows Client machine (Windows XP check here or Widows Vista here ) then there is high probability of FRM-92101 There was failure in the Form Server during Startup error while accessing forms in 11i or R12.   One of our Apps DBA trainee faced this issue during hands-on exercise. (Next Apps DBA Batch starting […]

Read More

Common Wait Events in a Real Application Clusters

Difference in single instance and RAC instance: In a single database instance environment, there will be only one set of shared memory segments for the database. In other words, the buffer cache and shared pool are local to that particular instance; at any point in time the processes attached to that particular instance will be […]

Read More

Node Manager in Oracle WebLogic Server

Node Manageris Weblogic Server utility to start, stop and restartAdministration and Managed Server Instances from remote location (There are other ways as well to start/stop Weblogic check here – Node Manager is optional component). 1. Node Manager Process is associated with a Machine and NOT with specific Weblogic Domain (i.e. Use one node manager for […]

Read More

Backup and recovery of Oracle Clusterware – OCR

The backup of OCR content(Oracle Cluster Registry, to know more about OCR click here) is performed using two methods: Automatic OCR backup Manually OCR backup . 1. Automatic OCR Backup OCR is automatically backed up physically Every four hours At the end of every day At the end of every week To check current location of […]

Read More
Not found