Tuesday, March 31, 2009

Upgrade 9i RAC to 10G RAC

Upgrade 9i RAC to 10G RAC:
A very nice and stepwise document to upgrade 9i RAC to 10G RAC database.
This article provides the procedures for converting Oracle 9i ( RAC to Oracle 10g ( RAC on Red Hat Enterprise Linux 3 (RHEL3).

Upgrade Guide: Oracle9i Release 2 RAC to Oracle RAC 10g Release 2 on Linux:
If you've been waiting to take advantage of the extensive list of new features and functionality in Oracle Database 10g and Oracle Real Application Clusters (RAC) 10g, there's no longer any need for delay. In September 2005, Oracle Database 10g Release 2 and Oracle RAC 10g Release 2 became available on all major platforms.
In this guide, I will describe the various steps involved in upgrading an Oracle9i RAC Release 2 environment configured on Oracle Cluster File System (OCFS) to Oracle RAC 10g Release 2 configured on Oracle Automatic Storage Management (ASM)—which is best practice for shared storage on RAC systems. Part 1 will cover the basic upgrade process; Part 2 will cover OCFS-to-ASM migration.
Please note that this guide is intended for evaluation purposes only; it is not an amendment of, or replacement for, official Oracle documentation.


Few other helpful links for RAC documents:

Monday, March 30, 2009

Oracle Support Contacts

Oracle Global Customer Support Contacts Directory:

Expect Lifetime Support:

Acquired Products Support:

What's New in Oracle Support Services:

Oracle Support Tools and Resources:

Oracle Technical Support Policies:

Thursday, March 26, 2009

Oracle Database Performance

This is a nice document which gives enough ideas how to improve the performance of the application and database by reducing the over all cost of resources.

Oracle Database Performance Analysis:

Oracle High Availability

Oracle High Availability Presentation:
A beautiful presentation which covers most of the scenarios of Oracle high availability architecture. This high availability architecture are designed to reduce the down time of the services and make sure the services are available to customers. This solutions reduces the service loss and increases the company revenue.

Oracle Maximum Availability Architecture - MAA:
Oracle Maximum Availability Architecture (MAA) is Oracle's best practices blueprint based on proven Oracle high availability technologies and recommendations. The goal of MAA is to achieve the optimal high availability architecture at the lowest cost and complexity.

  • MAA best practices span Oracle Database, Oracle Application Server, Oracle Applications and Grid Control.
  • MAA considers a range of business requirements to make these best practices as widely applicable as possible.
  • MAA leverages lower-cost servers and storage.
  • MAA evolves with new Oracle versions and features.
  • MAA is hardware and OS independent.

This Maximum Availability Architecture Overview describes how MAA is used to maximize systems availability and meet the most aggressive Service Level Agreements (SLAs) for system availability, quality of service, and data protection.
MAA Best Practices for each of the following areas are provided below:

Oracle Discoverer Basics

Very nice documents. These documents will help you understand about the basics of Oracle Discoverer and also it will help you to understand how to use Discoverer plus and Discoverer Administrator.

Oracle Discoverer Basics Presentation



Oracle Tutorials

The Oracle tutorials provides hands-on, step-by-step instructions on how to implement various technology solutions to business problems. These solutions are built for practical real-world situations, allowing you to gain valuable hands-0n experience. These are the best materials to start with Oracle products and gain knowledge to work in depth.


Wednesday, March 25, 2009

Datawarehouse Concepts

This is a presentation to understand the basics of Oracle Datawarehouse. This a nice knowledge content for the beginners.

Basic Datawarehouse Concepts Part 1

Basic Datawarehouse Concepts Part 2

Basic Datawarehouse Concepts Part 3

Oracle Database Features

Oracle Database New Release Features:
These features are very interesting and covers all most every new feature included in Oracle database 10G.
Oracle Database 10g: The Top 20 Features for DBAs:

Oracle Database 10g: Top Features for DBAs Release 2 Features Addendum :
Part 1SQL and PL/SQL Features
Part 2Manageability Features
Part 3Performance Features
Part 4Data Warehousing and Integration Features
Part 5Backup and Availability Features


Oracle Database 11g: Top Features for DBAs
These features are amazing and covers all most every new feature included in Oracle database 11G.
Oracle Database 11g: The Top New Features for DBAs and Developers

Recently I found this presentation presented by Arup Nanda. He has mentioned 11g features beautifully in this presentation. Follow this:

Basic Unix

This link covers basic Unix Commands to Manage Oracle Database. These commands will help the DBAs to handle Oracle Database running on Unix Servers.

Vi Editor Help:

Oracle Errors

This link will provide all Oracle Errors Published By Oracle on Oracle 9i Database:

This link will provide all Oracle Errors Published By Oracle on Oracle 10G Database:

This link will provide all Oracle Errors Published By Oracle on Oracle 11G Database:

Interactive method to find the description and resolution of Oracle Errors:

Oracle Software Library

This link will provide an easy access to all Oracle Softwares published by Oracle.


Oracle Document Library

This Link will provide an easy access to all Oracle Documents Published by Oracle:


Tuesday, March 24, 2009

Oracle Database Docs

This Gives a quick reference to Oracle Important and Daily DBA used documents to manage Oracle Database.

Oracle Database 11G

Oracle Database Document Library 11G

Oracle Database Concepts 11g Release 1 (11.1) http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/toc.htm

Oracle Database Administrator's Guide 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/toc.htm

Oracle Database SQL Language Reference 11g Release 1 (11.1) http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/toc.htm

Oracle Database Licensing Information 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/toc.htm

Oracle Database Performance Tuning Guide 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/toc.htm

Oracle Database Backup and Recovery Reference 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/backup.111/b28273/toc.htm

Oracle Database Administrator's Reference11g Release 1 (11.1) for Linux and UNIX-Based Operating Systems http://download.oracle.com/docs/cd/B28359_01/server.111/b32009/toc.htm

Oracle Data Guard Concepts and Administration 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/toc.htm

Oracle Database Advanced Replication 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/server.111/b28326/toc.htm

Oracle Real Application Clusters Administration and Deployment Guide 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/rac.111/b28254/toc.htm

Oracle Clusterware Administration and Deployment Guide 11g Release 1 (11.1)http://download.oracle.com/docs/cd/B28359_01/rac.111/b28255/toc.htm

Oracle Database High Availability Overview 11g Release 1 (11.1) http://download.oracle.com/docs/cd/B28359_01/server.111/b28281/toc.htm

Oracle Database 10G

Documentation Library 10G R2

Oracle Database Licensing Information10g Release 2 (10.2)

Oracle Database Concepts 10g Release 2 (10.2):

Oracle Database Administrator's Guide 10g Release 2 (10.2):

Oracle Database Performance Tuning Guide 10g Release 2 (10.2):

Oracle Database SQL Reference 10g Release 2 (10.2):

Oracle Database Backup and Recovery Basics 10g Release 2 (10.2):

Oracle Database Backup and Recovery Quick Start Guide10g Release 2 (10.2)

Oracle Enterprise Manager Concepts 10g Release 5 (

Oracle Enterprise Manager Advanced Configuration 10g Release 3 (

Oracle Data Guard Concepts and Administration 10g Release 2 (10.2)

Oracle Database Advanced Replication 10g Release 2 (10.2)