Category Archives: 10g

Home »  10g

Convert Single Instance database to RAC database !!!

On April 17, 2016, Posted by , In 10g,11g,12c, By , , With No Comments

This article is a continuation to our previous article where we have seen how to clone a database using RMAN Active Database. Now here we will see the steps to convert single instance database to RAC database. ======================================================================================================   • Follow below steps to convert the Single Instance database to…

Upgrade Oracle Database 10205 to 11203 !!!

in this article we will see the steps to Upgrade Oracle Database 10205 to 11203 on Red Hat Enterprise Linux. ======================================================================================================   Follow the below steps to upgrade Oracle database 10205 to 11203 • Download and Install 11gR2 software We cannot upgrade the existing 10g Oracle Home, since 11gR2 is…

Upgrade Oracle Database 10201 to 10205 !!!

In this article, we will see the steps to upgrade Oracle database 10201 to 10205. ======================================================================================================   Follow the below steps to upgrade Oracle database 10201 to 10205 • Download and Unzip 10205 patch Download the patchset p8202632_10205_Linux-x86-64.zip from Oracle Metalink. We have a 64 bit RHEL 5.8 Server, hence…

Change Existing Hostnames in 10g RAC cluster !!!

Recently we wanted to upgrade an Oracle 10g (10.2.0.5) RAC database having ASM storage to higher version i.e. Oracle 11gR2 (11.2.0.3). While checking the prechecks for the upgradation, we noticed that the 10g RAC Cluster was configured using the hostnames having ‘_’ in their names. The private and virtual hostnames were…

Add a New Node to an existing Oracle 10gR2 RAC !!!

On June 14, 2012, Posted by , In 10g, By , , With 2 Comments

The below article contains the steps to add a single node to an already configured two-node Oracle RAC 10g Release 2 environment on the RHEL 5.4 32-bit (x86) platform. This is an extension to my article Oracle 10g RAC installation on RHEL using NFS Disks. ======================================================================================================   This article assumes…

Oracle 10g ASM Installation Steps in RHEL !!!

On January 29, 2012, Posted by , In 10g, By ,, , With 2 Comments

ASM i.e. Automatic Storage Management simplifies administration of Oracle related files by allowing the administrator to reference disk groups rather than individual disks and files, which ASM manages internally. On Linux, ASM is capable of referencing disks as raw devices or by using the ASMLib software. In this article, we…

Oracle 10g RAC installation on RHEL using NFS Disks !!!

On January 18, 2012, Posted by , In 10g, By ,, , With No Comments

Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing a clustered database. In a non-RAC Oracle database, a single instance accesses a single database. In an Oracle RAC environment, two or more computers (each with an instance) concurrently access a single…

Oracle 10g Database installation steps in RHEL !!!

On January 2, 2012, Posted by , In 10g, By ,, , With 1 Comment

Before proceeding make sure you have downloaded the below software. You can get the software from otn.oracle.com – 10201_database_linux32.zip ======================================================================================================   • Hardware Requirements – Atleast 1GB of physical RAM. – SWAP space should be 2 times the size of RAM. – 400MB of disk space in the /tmp directory….