MoidIITDocID-521: How to upgrade 10g R2 RAC clusterware from 10.2.0.1 to 10.2.0.4? --Moid

Part-1) How to perform non-rolling CRS upgrade from 10.2.0.1 to 10.2.0.4?

Part-2) How to perform non-rolling ORACLE_HOME upgrade from 10.2.0.1 to 10.2.0.4?

Part-3) How to apply Latest CPU Patches and CRS Bundle Patch-4 on 10g R2 RAC?

--Moid

MoidIITDocID-522: How to apply CRS Bundle-4 Patch on 32-bit RHEL4 u8 in 10.2.0.4 CRS HOME? --Moid

Click here for the document.

--Moid

MoidIITDocID-519: My notes on RAC Failover Queries --Moid

Click here for the document.

MoidIITDocID-520: My notes on RAC Failover testing --Moid

--Moid

Document is deleted.

Click here for the document.

--Moid

MoidIITDocID-518.2: How to transport a tablespace using "Transportable Tablespace" feature of Oracle (Part-2)? --Moid

Click here for the document.

--Moid

MoidIITDocID-518.1: How to transport a tablespace using "Transportable Tablespace" feature of Oracle (Part-1)? --Moid

Click here for the document.

--Moid Muhammad

MoidIITDocID-546: Quick reference to Oracle Patchset patch numbers --Moid

As per the Oracle's Document ID 753736.1, the following are the quick reference to Oracle Patchset patch numbers:

Click here for the document.

--Moid


keywords:
oracle version
oracle patches
oracle patchset

MoidIITDocID-547: How to change Oracle Database Name and DBID? --Moid

Click here for the document.

--Moid

MoidIITDocID-548: 11g RAC using openfiler (Jeff Hunter's Document) --Moid

Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-1
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-2
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-3

--Moid

MIITDocID-955: How to enable archivelog mode? --Moid

Click here for the detail.

--Moid



Read more on Redo and Archivelog queries

MoidIITDocID-548: Queries to identify Oracle Foreign Keys (child tables) refrencing Primary Key of Parent Tables.-- Moid

Click here for the document.

--Moid

MoidIITDocID-541: How to install Oracle 11g R2 Client on Windows 7? --Moid

Click here for the document.

--Moid

Download Tora from here --Moid

from http://torasql.com/about

"TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.

In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools."

Tora (a tool similar to TOAD) can be downloaded from here. Main download page is at http://sourceforge.net/projects/tora/

--Moid Muhammad

Download Oracle 11g R2 Client for 32/64-bit Windows --Moid

Oracle Database 11g Release 2 (11.2.0.1.0) Client for 32/64-bit Windows.

1) Go to http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

2) Click on "Accept License Agreement"

3) And then start browsing as per your need. Few links to download Oracle client are as follows:

32-bit http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip

64-bit http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip

Click here for step-by-step Oracle 11g R2 Client Installation on Windows 7.

Click here for step-by-step Oracle 12c R1 Client Installation on Windows 8.

Note: In order for TOAD to work, use 32-bit client installation.

--Moid Muhammad

Backup and Recovery ()

Backup and Recovery ()

RMAN Scenario-21: How to recover database from lost controlfiles? --Moid

Click here for details

Moid

MoidIITDocID-938: My notes on RMAN --Moid

Click here for the document.

--Moid Muhammad

MIITDocID-958: Command Line Reference Guide --Moid

Click here for the document.

Moid

MoidIITDocID-540: How to perform TABLESPACE point in time recovery? --Moid

Click here for the document.

Moid