Changing Database name with nid in oracle

To change the database name

First
old name = hello
New name(to be changed) =hey

Pre requisite: Create pfile from spfile;


Sql> shut immediate;
         startup mount;
         exit;

nid target=sys/oracle dbname=hey setname=yes

it will show control file locations and asks yes/no

enter yes

It will complete the name change. If any problem it will return error

Once its done.

Edit pfile to reflect the new name of database including filename.

Create a new password file
orapwd file=orapwhey password=heyhey entries=3

After this set environment variables and startup as normal.

You can also use the following syntax

nid target=sys/oracle@catalog as sysdba dbname=catalog1

I got an error saying dbname failed error saying open cursors not enough. I increased open cursors and restarted it and ran same command again and it completed fine..

Partitioning and formatting new drive in linux with fidsk

http://www.idevelopment.info/data/Unix/Linux/LINUX_PartitioningandFormattingSecondHardDrive_ext3.shtml

Brief introduction into Materialized Views

Great Article.. See here
http://uhesse.com/2009/07/08/brief-introduction-into-materialized-views/