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 (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).
http://www.arhun.com/techtalk/oracle9i-rac-oracle10g-rac.html

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.

http://www.oracle.com/technology/pub/articles/vallath_rac_upgrade.html

Few other helpful links for RAC documents:
http://www.oracledba.org/index.html
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

Monday, March 30, 2009

Oracle Support Contacts

Oracle Global Customer Support Contacts Directory:
http://www.oracle.com/support/contact.html

Expect Lifetime Support:
http://www.oracle.com/support/lifetime-support-policy.html

Acquired Products Support:
http://www.oracle.com/support/support-integration.html

What's New in Oracle Support Services:
http://www.oracle.com/support/news.html

Oracle Support Tools and Resources:
http://www.oracle.com/support/tools-resources/index.html

Oracle Technical Support Policies:
http://www.oracle.com/support/policies.html

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:
http://docs.google.com/Presentation?id=dfwx283d_630r39f3fgw

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.
http://docs.google.com/Presentation?id=dfwx283d_618hjrztddr


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:
http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm

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
http://docs.google.com/Presentation?id=dfwx283d_519f94b99hc

DISCOVERER ADMINISTRATOR PRESENTATION
http://docs.google.com/Presentation?id=dfwx283d_745qxshr23f

DISCOVERER PLUS PRESENTATION
http://docs.google.com/Presentation?id=dfwx283d_876c5hjxmhj

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.

http://www.oracle.com/technology/obe/start/index.html

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
http://docs.google.com/Presentation?id=dfwx283d_62cfvp4mgc

Basic Datawarehouse Concepts Part 2
http://docs.google.com/Presentation?id=dfwx283d_123gvbx8dcs

Basic Datawarehouse Concepts Part 3
http://docs.google.com/Presentation?id=dfwx283d_202gsqfpwvw

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:
http://www.oracle.com/technology/pub/articles/10gdba/index.html

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

http://www.oracle.com/technology/pub/articles/10gdba/index_r2.html

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
http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/index.html

Recently I found this presentation presented by Arup Nanda. He has mentioned 11g features beautifully in this presentation. Follow this:
http://www.proligence.com/oow09_11g_nf.pdf

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.
http://www.math.utah.edu/lab/unix/unix-commands.html

Vi Editor Help:
http://www.cs.colostate.edu/helpdocs/vi.html

Oracle Errors

This link will provide all Oracle Errors Published By Oracle on Oracle 9i Database:
http://www.oracle.com/pls/db92/db92.error_search

This link will provide all Oracle Errors Published By Oracle on Oracle 10G Database:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10744/toc.htm

This link will provide all Oracle Errors Published By Oracle on Oracle 11G Database:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28278/toc.htm

Interactive method to find the description and resolution of Oracle Errors:
http://www.ora-error.com/

Oracle Software Library

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

http://www.oracle.com/technology/software/index.html

Oracle Document Library

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

http://www.oracle.com/technology/documentation/index.html

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
http://www.oracle.com/pls/db111/homepage

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
http://www.oracle.com/pls/db102/portal.portal_db?selected=4

Oracle Database Licensing Information10g Release 2 (10.2)
http://download.oracle.com/docs/cd/B19306_01/license.102/b14199/toc.htm

Oracle Database Concepts 10g Release 2 (10.2):
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

Oracle Database Administrator's Guide 10g Release 2 (10.2):
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm

Oracle Database Performance Tuning Guide 10g Release 2 (10.2):
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

Oracle Database SQL Reference 10g Release 2 (10.2):
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm

Oracle Database Backup and Recovery Basics 10g Release 2 (10.2):
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm

Oracle Database Backup and Recovery Quick Start Guide10g Release 2 (10.2)
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14193/toc.htm

Oracle Enterprise Manager Concepts 10g Release 5 (10.2.0.5)
http://download.oracle.com/docs/cd/B19306_01/em.102/b31949/toc.htm

Oracle Enterprise Manager Advanced Configuration 10g Release 3 (10.2.0.3.0)
http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/toc.htm

Oracle Data Guard Concepts and Administration 10g Release 2 (10.2)
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm

Oracle Database Advanced Replication 10g Release 2 (10.2)
http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/toc.htm