10gGrid : Oracle On Demand Grid

"As Oracle pushes the boundaries of grid computing, the Austin Data Center remains a unique test bed for the industry as a whole. But the real beneficiaries are Oracle customers, who end up with better products as a result of Oracle's experience." .... readmore

"Oracle OnDemand ADC - Largest Dell/Linux installation on earth" ....read what netapp says

10gGrid : Explained @ OBE

Came across few links related to Grid at Oracle By Example

Using Patch Wizard to Patch 10.2.0.1.0 Management Agents to 10.2.0.3.0

Provisioning and Patching your Oracle Environment with Oracle Enterprise Manager 10g

New Features in Oracle Enterprise Manager 10g Release 2 based Patching

Monitoring Hosts using Oracle Enterprise Manager 10g Grid Control Release 3

Managing Host Configuration using Oracle Enterprise Manager 10g Grid Control Release 3

10gGrid : Oracle EBusiness Suite Application Pack , Features & Key Benefits

Reference : Oracle EBusiness Suite Application Pack , Features & Key Benefits

FEATURES

CONFIGURATION MANAGEMENT

* Configuration Management Database
* Automatic Discovery
* System Modeling
* Service Modeling
* Configuration Snapshot
* Change Audit Trail
* Configuration Compare
* Topology Visualization


APPLICATION PERFORMANCE MANAGEMENT

* Thresholds
* Alert Notifications
* Metric History
* SARM Analysis / Transaction Tracing
* Event Log Analysis
* Root Cause Analysis
* End-User Performance Monitoring
* Enterprise Dashboard


SERVICE LEVEL MANAGEMENT

* Service Level Objective
* Business Process Service Level Monitoring
* Service Metrics
* Service Test
* Service Level Reports

GRID AUTOMATION

* Step-by-step cloning interview process to guide system administrators through the cloning process New cloning dashboard to monitor the enterprise-wide status of clone jobs
* Automated clone process that includes the capability to customize clone process and to obfuscate sensitive data

Key Benefits:
With Oracle Application Management Pack for Oracle E-Business Suite,
you get the tools that help you achieve the required application performance and availability, improve your management productivity, better utilize your resources, and drive down costs. You may also plan, organize and execute enterprise-wide clone jobs from a single location, maintain mirror systems at the same patch level and data, and have the flexibility to adapt to an enterprise custom clone process.

10gGrid : Discovery of Oracle Application E-Business Suite on Management Grid

Discovery of Oracle Application E-Business Suite on Management Grid

Overview:
1. Login to the Grid
2. Select Oracle Application Tab
3. Select ADD and add the Oracle Application E-Business Database Target
4. Click on Start Discovery to discover the Instance
5. Select the Instance and explore Oracle Application on the Grid.

Detailed:





Summary : We have added Oracle Application EBusiness Suite Instance as a Target to the Grid.

10gGrid : Patching Management Agent Plug In for Oracle Application E-Business Suite

Patching Management Agent Plug In for Oracle Application E-Business Suite

Overview:
1. Export ORACLE_HOME as the oracle home of the managment agent
2. Unzip the Patch 5489352 and Start the RunInstaller /Disk1/runInstaller
3. Select the Option Management Agent Plug-in for Oracle Application 2.0.0.0.0
4. Select the Agent10g Home
5. Complete the Installation
6. The Installer would bounce the Agent for the Change to take place.

Detailed:



Summary : We have seen how to Patch the Management Agent Plug In for Oracle Application E-Business Suite.

10gGrid : Patching Management Service for Oracle Application E-Business Suite

Patching Management Service for Oracle Application E-Business Suite

Overview:
1. Stop the Management Service Completely
2. Export ORACLE_HOME as the oracle home of management service
3. Unzip the Patch 5489352 and Start the RunInstaller /Disk1/runInstaller
4. Select the Option Grid Control Plug-in for Oracle Application 2.0.0.0.0
5. Select the OMS10g Home
6. Specify the Repository Database SYS authentication.
7. Complete the Installation.

Detailed:

























Summary : We have seen how to Patch the Management Service for Oracle Application E-Business Suite

10gGrid : Application Management Pack for Oracle E-Business Suite

Application Management Pack Version 2.0 for Oracle E-Business Suite

Overview:
The Application Management Pack for Oracle E-Business Suite provides extensions for the Enterprise Manager 10g Grid Control management service, repository, and agent.
This pack introduces target types for both Oracle E-Business Suite Release 11i as well as Release 12.

Some of the Target Types for R12/R11i System are below;
Oracle E-Business Suite
Oracle Applications Service
Oracle Applications Infrastructure Service
Concurrent Processing Service
Forms Applications Service
Self Service Applications Service
Workflow Service
Order Management Service
Oracle Applications JVM Usage
Oracle E-Business Suite Custom Objects
Oracle E-Business Suite Patch Information

This pack also provides new pages within Grid Control, which helps you to monitor the performance, availability and configuration changes of your Oracle E-Business system and also to provision your E-Business Suite application.
Grid Control provides a complete view of your enterprise, allowing you manage all of your Oracle E-Business Suite systems from a single console.



Grid Control allows you to monitor multiple Oracle E-Business systems (both 11i & 12) from the outside. From within Grid Control, you can drill down into Oracle Applications Manager, which is built directly into the Oracle Applications system itself. Grid Control and Oracle Applications Manager combine together to provide a comprehensive Oracle Applications system management solution.


System Requirement :
Enterprise Manager 10g Grid Control 10.2.0.3
The Application Management Pack for Oracle E-Business Suite installs into the Enterprise Manager 10g Grid Control management service, repository, and agent.
Before installing this pack, you must first apply the Enterprise Manager 10.2.0.3 patch set to the management service, repository, and agent.

I had a test instance on R12 so will go with the following patching.
Patch 5489352 - EM PLUGIN V2 FOR ORACLE APPLICATIONS



Installation:
Download the Application Management Pack for Oracle E-Business Suite Patch 5489352 from OracleMetaLink to the Enterprise Manager Oracle Management Server.
The Application Management Pack for Oracle E-Business Suite is installed using Oracle Universal Installer.
To install this pack, you must have an existing Grid Control installation.
The pack must be installed into each existing Grid Control Management Service and Management Agent that will be used for Oracle E-Business Suite.

Step 1: Patching the Management Service

1. Stop the Management Service Completely
2. Export ORACLE_HOME as the oracle home of management service
3. Unzip the Patch 5489352 and Start the RunInstaller /Disk1/runInstaller
4. Select the Option Grid Control Plug-in for Oracle Application 2.0.0.0.0
5. Select the OMS10g Home
6. Specify the Repository Database SYS authentication.
7. Complete the Installation.

Step 2: Pathing the Management Agent Plug-in

1. Export ORACLE_HOME as the oracle home of the managment agent
2. Unzip the Patch 5489352 and Start the RunInstaller /Disk1/runInstaller
3. Select the Option Management Agent Plug-in for Oracle Application 2.0.0.0.0
4. Select the Agent10g Home
5. Complete the Installation
6. The Installer would bounce the Agent for the Change to take place.

Step 3: Discovering Oracle Application in the Grid.

Summary: We have seen a brief introduction of Application Management Pack for Oracle E-Business Suite.
The readme of the Patch contains full detailed report with good screenshots.

10gGrid : Manual and Automatic Discovery of Target Database

By default all the Targets on the host where the agent is installed gets configured to the grid.
If any of the targets are not discovered then the following procedure can be used



Now I have added TEST01 which runs on lab01.testserver.com
When I added the second node lab02.testserver.com , database TEST02 got automatically discovered.



Summary : We have seen Automatic Discovery and Manual Discovery on Database Instance.

10gGrid : Deploying Agents

I have Installed Release 2 and Upgraded to Release 3 in my earlier blog.
Now we have to deploy the agents. I have deployed agents on two nodes.

Step by Step Instructions for Installing Agent



Note : The Agent automatically contacts the Managment Server and gets registered.
No user intervention is required. Listing below the status of the agent from one of the host.

[oragent@lab01]$ emctl status agent
Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.3.0
OMS Version : 10.2.0.3.0
Protocol Version : 10.2.0.2.0
Agent Home : /home/oragent/agent10g
Agent binaries : /home/oragent/agent10g
Agent Process ID : 3250
Parent Process ID : 3224
Agent URL : https://lab01.testserver.com:3872/emd/main/
Repository URL : https://managementserver.grid.com:1159/em/upload
Started at : 2007-04-21 21:03:32
Started by user : oragent
Last Reload : 2007-04-21 21:03:32
Last successful upload : 2007-04-21 21:05:36
Total Megabytes of XML files uploaded so far : 7.62
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 79.42%
Last successful heartbeat to OMS : 2007-04-21 21:05:39
---------------------------------------------------------------
Agent is Running and Ready
[oragent@lab01]$

Summary : Installed Agent and Configured with the Management Server.

10gGrid v10.2.0.1.0 : Upgrading to Release 3 on Oracle Enterprise Linux

Upgrading the Existing 10.2.0.1.0 Enterprise Manager Grid Control installations to Enterprise Manger 10g Grid Control Release 3

Requirement : Running 10g Grid v10.2.0.X. In my case the version is 10.2.0.1.0

Software Requirement for Upgrade:
Download GridControl_10.2.0.3_Linux.zip
URL: http://www.oracle.com/technology/software/products/oem/index.html

Step by Step Instructions for Upgrading

[root@managementserver 10..3]# unzip GridControl_10.2.0.3_Linux.zip
Archive: GridControl_10.2.0.3_Linux.zip
extracting: 3731596.zip
extracting: 3822442.zip
creating: doc/
inflating: doc/BugList_EMGC_10.2.0.3.pdf
inflating: doc/BugList_EMGC_10.2.0.3.html
inflating: doc/ReleaseNotes_EMGC_10.2.0.3.html
inflating: doc/ReleaseNotes_EMGC_10.2.0.3.pdf
extracting: p3731593_10203_linux.zip
extracting: p4329444_10104_LINUX.zip
extracting: p4329444_10105_LINUX.zip
inflating: README.txt
[root@managementserver 10..3]# cat README.txt
Table of Contents
1.General
2.Fresh Installation of Enterprise Manger 10g Grid Control Release 2 and upgrading it to Release 3
3.Upgrading any existing 10.2.0.X.0 Enterprise Manager Grid Control installations to Enterprise Manger 10g Grid Control Release 3.
4.Upgrading an existing 10.1.0.4.0 or a higher 10.1.0.X.0 Enterprise Manager Grid Control installation to the latest Enterprise Manger 10g Grid Control Release 3


Here I will be doing an upgrade to R3 from 10.2.0.1.0 with option 3 on the Readme
To know the current version access the aboutApplication URL

http://managementserver.grid.com:4889/em/console/aboutApplication
Oracle Enterprise Manager 10g Grid Control Release 10.2.0.1.0

em_grid_102010_version:

Upgrading any existing 10.2.0.X.0 Enterprise Manager Grid Control installations to Enterprise Manger 10g Grid Control Release 3.

3.1 Roll-back patch 5191377 if it has been applied to the Oracle Management Service (OMS)
Not executing Step 3.1 as in my case the inventory does not have 5191377

[orgrid@managementserver ~]$ export ORACLE_HOME=/home/orgrid/oms10g
[orgrid@managementserver ~]$ cd $ORACLE_HOME/OPatch
[orgrid@managementserver OPatch]$
[orgrid@managementserver OPatch]$ ./opatch lsinv | grep -i 5191377
[orgrid@managementserver OPatch]$
SQL> select 1 from dba_indexes where index_name=upper('mgmt_current_violation_idx_05');

no rows selected

SQL>

3.2 Apply patches if required
In the case of Grid Control environment installed via "Enterprise Manager using New Database" option or "Enterprise Manager using an existing Database " option with 10.1.0.4 or 10.1.0.5 Database, apply the patch for bug 4329444 on the Database Home. In order to apply this patch for the Linux platform:

In my case it was done using the option "Enterprise Manager using New Database"


[orgrid@managementserver 10..3]$ ls -rlt *4329444*
-rw-r--r-- 1 root root 70783 Jan 31 21:34 p4329444_10105_LINUX.zip
-rw-r--r-- 1 root root 70431 Jan 31 21:34 p4329444_10104_LINUX.zip
[orgrid@managementserver 10..3]$

Database version is 10.1.0.4.0

[root@managementserver 10..3]# unzip p4329444_10104_LINUX.zip
Archive: p4329444_10104_LINUX.zip
creating: 4329444/
creating: 4329444/files/
creating: 4329444/files/lib/
creating: 4329444/files/lib/libserver10.a/
inflating: 4329444/files/lib/libserver10.a/qerix.o
creating: 4329444/etc/
creating: 4329444/etc/config/
inflating: 4329444/etc/config/inventory
inflating: 4329444/etc/config/actions
creating: 4329444/etc/xml/
inflating: 4329444/etc/xml/GenericActions.xml
inflating: 4329444/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 4329444/README.txt
[root@managementserver 10..3]#

[orgrid@managementserver ~]$ export ORACLE_HOME=/home/orgrid/db10g
[orgrid@managementserver ~]$ export ORACLE_SID=emrep
[orgrid@managementserver ~]$ cd /stage/Grid/10..3/4329444/
[orgrid@managementserver 4329444]$

Before proceeding with the Patching SHUTDOWN Services
$OMS_ORACLE_HOME/opmn/bin/opmnctl stopall
$EMAGENT_ORACLE_HOME/bin/emctl stop agent
Shutdown Database and Listener

[orgrid@managementserver 4329444]$ opatch apply
Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..


Oracle Home : /home/orgrid/db10g
Central Inventory : /home/orgrid/oraInventory
from : /home/orgrid/db10g/oraInst.loc
OPatch version : 10.2.0.1.0
OUI version : 10.2.0.1.0
OUI location : /home/orgrid/db10g/oui
Log file location :
/home/orgrid/db10g/cfgtoollogs/opatch/opatch-2007_Apr_21_10-01-38-IST_Sat.log

ApplySession applying interim patch '4329444' to OH '/home/orgrid/db10g'
Invoking fuser to check for active processes.
Invoking fuser on "/home/orgrid/db10g/bin/oracle"
OPatch finds following executables active:
/home/orgrid/db10g/bin/oracle
Before you proceed, stop all active processes. Press when ready.
Do you want to proceed? [y|n]
y
User Responded with: Y

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/home/orgrid/db10g')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '4329444' for restore. This might take a while...
Backing up files affected by the patch '4329444' for rollback. This might take a while...

Patching component oracle.rdbms, 10.1.0.4.0...
Updating archive file "/home/orgrid/db10g/lib/libserver10.a" with "lib/libserver10.a/qerix.o"
Running make for target ioracle
ApplySession adding interim patch '4329444' to inventory

The local system has been patched and can be restarted.
OPatch succeeded.
[orgrid@managementserver 4329444]$

3.3 Install Oracle Enterprise Manager 10g Release 3
Follow step 2.3 above.

2.3 Install Oracle Enterprise Manager 10g Release 3

2.3.1 Copy the p3731593_102030_.zip patch set installation archive from the DVD to any directory on the host which has the Oracle Management Service running on it.

2.3.2 Perform the installation
- Enter the following command to unzip and extract the installation files from the downloaded image described in section 1.2:
$ unzip p3731593_102030_.zip
This extracts the files to the "3731593" directory.
- Navigate to the 3731593/Disk1 subdirectory
$ cd 3731593/Disk1
- Set the ORACLE_HOME variable to the Oracle Management Service(OMS) oracle home.
- Execute the runInstaller (setup.exe for Windows)
$ ./runInstaller
The upgrades process then upgrades the Oracle Management Service (OMS), Oracle Management Repository and the Management Agent on the same host as the OMS to the latest Enterprise Manager 10g release 3 version.
Important: The same Patch Set can be used for patching OMS,Repository, and Management Agent. For more detail on installing the patchset, refer to the release note.

[root@managementserver 10..3]# ls -lrt *3731593*
-rw-r--r-- 1 root root 554291128 Feb 1 15:45 p3731593_10203_linux.zip
[root@managementserver 10..3]#

[root@managementserver 10..3]# unzip p3731593_10203_linux.zip

- Navigate to the 3731593/Disk1 subdirectory
$ cd 3731593/Disk1
- Set the ORACLE_HOME variable to the Oracle Management Service(OMS) oracle home.
- Execute the runInstaller (setup.exe for Windows)
$ ./runInstaller

10g_grid_upgrade_all:

[orgrid@managementserver~]$ emctl getversion
Oracle Enterprise Manager 10g Release 3 Grid Control
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Enterprise Manager 10g OMS Version 10.2.0.3.0
Enterprise Manager 10g AS Control Version 10.2.0.0
Enterprise Manager 10g Agent Version 10.2.0.3.0
[orgrid@managementserver~]$

Summary : Installed 10g Grid Release 2 and Upgraded to Release 3 on Oracle Enterprise Linux

10gGrid v10.2.0.1.0 : Installation on Oracle Enterprise Linux

Hardware Requirement :
One Node with Linux Operating System
I downloaded Oracle Enterprise Linux from edelivery.oracle.com

Software Requirement :
Oracle Enterprise Manager Downloads
Version Used : Oracle Enterprise Manager 10g Grid Control Release 2(10.2.0.1.0)

Documentation :
http://download-west.oracle.com/docs/cd/B16240_01/welcome.html


Introduction:
Oracle Enterprise Manager 10g Grid Control (Oracle Grid Control) delivers centralized management functionality for the complete Oracle IT infrastructure, including systems running Oracle and non-Oracle technologies. With a broad set of administration, configuration management, provisioning, end-to-end monitoring, and security capabilities, Oracle Grid Control reduces the cost and complexity of managing grid computing environments. Robust service-level management functionality within Oracle Grid Control dramatically improves service levels through rich transaction and end-user performance monitoring and deep diagnostics for multi-tier Internet applications. Oracle Grid Control also offers a comprehensive extensibility framework for management of custom applications and integration with other management tools. These capabilities allow companies to deliver superior performance for their systems and applications, while continually reducing management complexity and costs.

After installing and deploying the Oracle Enterprise Manager components, you can use Grid Control to:

* Simplify deployment of Oracle solutions by cloning fully patched and tested Oracle homes to multiple hosts.
* Quickly identify available patches for the components in your enterprise and bring those components up to the latest patch level with just a few clicks.
* Apply consistent, proactive management practices across your enterprise using policies and management templates.
* Automatically assess the security vulnerabilities in your enterprise using the Critical Patch Facility, which provides notifications and a direct link to Oracle Support.
* Enhanced security rules harden the infrastructure database and host. Violation score reporting helps administrators prioritize security operations.
* Schedule and run multi-task jobs across multiple targets using the more powerful, feature-rich job system.
* Create groups to monitor heterogeneous or homogeneous target groups using enhanced group management pages.

Installation Procedure:



Summary : Installed 10g Grid Release 2 version 10.2.0.1.0 on Oracle Enterprise Linux

Discoverer : Role of Administrator

Role of Discoverer Administrator

As the Discoverer administrator, one should:

* Identify user requirements
* Choose the database tables that best meet the requirement
* Build useful and robust business areas
* Create meaningful names for business areas, folders, and items
* Control user access to business areas
* Create a usable relational structure in the EUL with joins and complex folders
* Create calculations, conditions and drills that support end-user analysis
* Create summary tables to improve performance

Discoverer : Summary Management

Summary Management
The Summary Management feature in Discoverer uses native features in the Oracle DBMS, and is therefore only available when running against the Oracle database. This feature uses the same highly scalable and reliable processing procedures within the kernel as the workbook scheduling capability and the setup for both features is similar. These procedures use standard packages in the DBMS called "DBMS_JOB".

Privileges
The user ID that you intend to use to create the Summary Folders must have the following database privileges:
CREATE TABLE
CREATE VIEW
CREATE PROCEDURE
SELECT ON V_$PARAMETER
ANALYZE ANY (ASM)
CREATE/DROP/ALTER ANY MATERIALIZED VIEW (8.1.6+)
GLOBAL QUERY REWRITE

We will be looking on the following

* Defining Privileges Required
* Open a Business Area and Access Summary Wizard
* Running the Wizard to have Discoverer recommendation and best summaries.
* Running the Wizard to have Discoverer Administration to it him/her self.



Defining Privileges Required



Open a Business Area and Access Summary Wizard



Running the Wizard to have Discoverer recommendation and Best Summaries














Running the Wizard to have Discoverer Administration to it him/her self





Summary : Ran Summary Wizard with two options. One with Oracle Discoverer Recommendation and Implementing the Best Practise. Other option with Self Management which an Administrator can perform on his/her own.

Discoverer : Refreshing a Business Area

Discoverer Administration - Refreshing a Business Area

We will be looking on the following

* Open an Existing Business Area
* Refresh the Business Area
* Make a DML Change to the Table and Refresh the Business Area
* Make a DDL Change to the Table and Refresh the Business Area


Open an Existing Business Area





Refresh the Business Area



Make a DML Change to the Table and Refresh the Business Area



Make a DDL Change to the Table and Refresh the Business Area













Summary : Refreshed a Business Area and have also seen the Refresh happens when there is a DDL Change to the Table and not on a DML Change to the Table.

Discoverer : Export / Import of Business Area

Discoverer Administration - Export / Import of Business Area

We will be looking on the following

* Open an Existing Business Area
* Export it to a Physical EEX File
* Import the exported EEX File Back as another Business Area


Open an Existing Business Area



Exporting it to a Physical EEX File







Importing the exported EEX File Back as another Business Area
















Summary : Exported and Imported a Business Area