Search This Blog

Thursday, April 26, 2012

Convert Oracle Database From Non-ASM to ASM.

Modify parameters

SQL> alter database disable block change tracking;

SQL> alter system set db_create_file_dest='+DATA' scope=spfile;

System altered.

SQL> alter system set db_recovery_file_dest='+FLASH' scope=spfile;

System altered.
Read more >>

Wednesday, April 25, 2012

Single Instance To RAC Conversion Using RCONFIG.

Nodes Available.

vmlinux1,vmlinux2

Single instance running at vmlinux1

ORACLE_HOME=/u05/app/oracle/product/10.2.0/db_1
SID=racorcl
Read more >>

Saturday, April 21, 2012

How to Delete ASM ?

Log in to the asm instance as Oracle User

$ export ORACLE_SID=+ASM

$ sqlplus / as sysdba

Enter the following command to determine whether any Oracle database instance is using the ASM instance: 
Read more >>

How To Clear Oracle Clusterware Installation ?

There are two methods to do it.

Automatic

Run the following scripts as root user.

cd $ORA_CRS_HOME/install/
Read more >>

Monday, April 16, 2012

Single Instance Conversion To RAC Using DBCA.

This tutorial shows how to convert a single instance database to a RAC one by using DBCA.
Below is the configuration of my single instance Database and RAC Nodes.

Single Instance Database.

OS: RHEL4
Oracle Software Version: 10.2.0.4
SID: orascott
Read more >>

Drop or Delete a RAC Database Using DBCA 10g.

This example shows how to drop a RAC database using DBCA.

Read more >>

Create Database Template Using DBCA.

In this example i am creating a template of an existing database named "ORASCOTT" by using DBCA.

Read more >>