Guenadi N Jilevski's Oracle BLOG

Creating the RAC database in Oracle 11g R1 (11.1.0.7)

Creating the RAC   database in Oracle 11g R1 (11.1.0.7)

Login as oracle user and run Database Configuration Assistant (dbca)

Select Oracle Real Application Clusters database and press Next to continue.

Select Create a Database and press Next to continue.

Select all the nodes where the clustered database will have instances and press Next to continue.

Select Custom Database and press Next to continue.

Specify the database SID and press next to continue.

Select the option to configure the Enterprise Manager and press Nest to continue

Select the same password for the Administrative users and press Next to continue.

Select the option to use Automatic Storage Management (ASM) and press next to continue.

Select the password for the sys user and select the type of parameter file that will be used for the ASM instance. Press Next to continue.

Confirm it by pressing OK.

The database configuration assistants (dbca) starts creating the ASM instance.

Here we make a selection of the disks for the DATA group for the RACDB database. We select external redundancy and ok it.

Select the disk for the FLASH diskgroup which will be used for Flash Recovery area. Select external redundancy and press OK.

Here we have the DATA and FLASH diskgroups mounted by the ASM instance. Press Next to continue.

Select DATA disk group for the Database Are and usage of Oracle Managed files. Press Next to continue.

Specify the Flash Recovery Area as an option. Specify the location of the flash recovery area and finally the flash recovery size. Press Next to continue.

Select the database components to be installed and press Next to continue.

Enable Automatic Maintenance tasks and Press Next to continue.

Examine the Database storage features and press Next to continue.

Examine the summary and press the OK to continue.

Wait until Database Configuration Assistant completes.

In case that you have run installer on a different node there will be RACDB1 instance on node raxlinux2 or +ASM2 on raclinux1. For example to reverse the instances use the following methodology. Stop the databases. After that remove the instances , then add the instances on the correct nodes. While doing it make sure you copy the correct password and spfiles. This apply both for RACDB database and for the ASM database. Please see the commands below for both RACDB and for ASM instance.

Example for the RACDB database

srvctl stop database -d RACDB
srvctl remove instance -d RACDB -i RACDB1
srvctl remove instance -d RACDB -i RACDB2
srvctl add instance -d RACDB -i RACDB1 -n raclinux1
srvctl add instance -d RACDB -i RACDB2 -n raclinux2
srvctl start database -d RACDB

Example for the ASM instance

srvctl stop asm -n raclinux1
srvctl stop asm -n raclinux2
srvctl remove asm -n raclinux2 -i +ASM1
srvctl remove asm -n raclinux1 -i +ASM2
srvctl add asm -n raclinux1 -i +ASM1 -o /u01/app/oracle/product/11.1.0/db_1
srvctl add asm -n raclinux2 -i +ASM2 -o /u01/app/oracle/product/11.1.0/db_1
srvctl start asm -n raclinux1
srvctl start asm -n raclinux2

Enterprise Manager Database Control can be recreated using the command below.

./emca -config dbcontrol db -repos recreate

Crs_stat –t –v
Name           Type           R/RA   F/FT   Target    State     Host
———————————————————————-
ora….B1.inst application    0/5    0/0    ONLINE    ONLINE    raclinux1
ora….B2.inst application    0/5    0/0    ONLINE    ONLINE    raclinux2
ora.RACDB.db   application    0/0    0/1    ONLINE    ONLINE    raclinux2
ora….SM2.asm application    0/5    0/0    ONLINE    ONLINE    raclinux1
ora….X1.lsnr application    0/5    0/0    ONLINE    ONLINE    raclinux1
ora….ux1.gsd application    0/5    0/0    ONLINE    ONLINE    raclinux1
ora….ux1.ons application    0/3    0/0    ONLINE    ONLINE    raclinux1
ora….ux1.vip application    0/0    0/0    ONLINE    ONLINE    raclinux1
ora….SM1.asm application    0/5    0/0    ONLINE    ONLINE    raclinux2
ora….X2.lsnr application    0/5    0/0    ONLINE    ONLINE    raclinux2
ora….ux2.gsd application    0/5    0/0    ONLINE    ONLINE    raclinux2
ora….ux2.ons application    0/3    0/0    ONLINE    ONLINE    raclinux2
ora….ux2.vip application    0/0    0/0    ONLINE    ONLINE    raclinux2

[oracle@raclinux2 RACDB]$ srvctl config database -d RACDB
raclinux2 RACDB1 /u01/app/oracle/product/11.1.0/db_1
raclinux1 RACDB2 /u01/app/oracle/product/11.1.0/db_1
[oracle@raclinux2 RACDB]$ srvctl status database -d RACDB
Instance RACDB1 is running on node raclinux2
Instance RACDB2 is running on node raclinux1
[oracle@raclinux2 RACDB]$

# listener.ora.raclinux2 Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.raclinux2
# Generated by Oracle configuration tools.

LISTENER_RACLINUX2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux2-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.144)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

RACDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACDB)
(INSTANCE_NAME = RACDB1)
)
)

RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux1-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACDB)
)
)

LISTENER_RACDB2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux1-vip)(PORT = 1521))

LISTENER_RACDB1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux2-vip)(PORT = 1521))

LISTENERS_RACDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux1-vip)(PORT = 1521))
)

RACDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = raclinux1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACDB)
(INSTANCE_NAME = RACDB2)
)
)

December 18, 2009 - Posted by gjilevski | oracle