Search This Blog

Tuesday, September 13, 2011

Adding instance on RAC database without dbca ( 10gR2)

The suggested method to add an instance is via the dbca utility ( below is the silent version)

dbca -silent -addInstance -nodeList rac3 -gdbName ocfs -instanceName ocf3 -sysDBAUserName sysdba -sysDBAPassword xxxxx

If a dbca failed , try to add your new instance manually as follows

Add a new Listener using netca
Add a new Listener information in tnsnames.ora ( Remote Listener section)

Edit the tnsnames.ora for all instances


Prepare the database

Create a new thread
====================

ALTER DATABASE
ADD LOGFILE THREAD 3
GROUP 5 ('/ocfs-disk/ocfs/redo05.log') size 50M,
GROUP 6 ('/ocfs-disk/ocfs/redo06.log') size 50M;

alter database enable thread 3;

Create a new Undo tablespace
=============================

create undo tablespace UNDOTBS3 datafile '/ocfs-disk/ocfs/undotbs03.dbf' size 100M autoextend off;

Create init<>.ora and password file from the new node and assign the new thread and undo tablespace

add the instance using srvctl
==============================

srvctl add instance -d ocfs -i ocfs3 -n rac3
srvctl config database -d ocfs
srvctl start instance -d ocfs -i ocfs3

Ensure that the services_names is not set
ALTER SYSTEM SET service_names='' SCOPE=SPFILE SID='*';