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.
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)
)
)
No comments yet.
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
Leave a Reply