DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, August 11, 2015

step by step 11gr2 RAC One Node Installation


Installing Oracle 11g r2 RAC One Node


This post describes how to create  a rac one node database and how it functions.


Pre-requisite:


Set up  Linux Servers  with oracle cluster software installed for cluster database and install oracle database software (11.2) (only software without database ).


1.Now start dbca 

[oracle@racnode1 ~]$

[oracle@racnode1 ~]$ dbca


2.Choose the option “Oracle  rac one node database”




3. Choose the option “Create a database”






4. Choose the option “General Purpose or Transaction Processing” as follows






5.Choose the option “Admin-managed” and proceed with other details for the database and select the hosts you wish to configure for RAC one node.






6.Click Next if you want to skip Enterprise Manager configuration .





 7.Specify the password.



8. Choose ASM and the disk group for Database Area

 




9.Specify fast recovery area location and size.



10.Click Next

 


 11.Specify memory for the database.

 


12.Click finish for the database creation.




13.Database installation is completed.


RAC One Node installation is completed , Now check configurations of the database.


[oracle@racnode1 ~]$ srvctl config database -d test

Database unique name: test

Database name: test

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_2

Oracle user: oracle

Spfile: +DATA/test/spfiletest.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: test

Database instances:       

Disk Groups: DATA,FRA

Mount point paths:

Services: test_svc

Type: RACOneNode

Online relocation timeout: 30

Instance name prefix: test

Candidate servers: racnode1,racnode2

Database is administrator managed

[oracle@racnode1 ~]$

[oracle@racnode1 ~]$



Note :  online relocation timeout is 30 mins(default)



Now check the status of the database



[oracle@racnode1 ~]$ srvctl status database -d test

Instance test_1 is running on node racnode1

Online relocation: INACTIVE

[oracle@racnode1 ~]$  



Now relocate the database instance



[oracle@racnode1 ~]$

[oracle@racnode1 ~]$ srvctl relocate database -d test -n racnode2 -w 05 -v

Configuration updated to two instances



Note : I have given wait time of 5 mins



Checking  parallelly  in another session



[oracle@racnode1 ~]$ srvctl status database -d test

Instance test_2 is running on node racnode2

Online relocation: ACTIVE

Source instance: test_1 on racnode1

Destination instance: test_2 on racnode2

[oracle@racnode1 ~]$



While checking in the pevious session

[oracle@racnode1 ~]$

[oracle@racnode1 ~]$ srvctl relocate database -d test -n racnode2 -w 05 -v

Configuration updated to two instances

Instance test_2 started

Services relocated

Waiting for up to 5 minutes for instance test_1 to stop ...

Instance test_1 stopped

Configuration updated to one instance

[oracle@racnode1 ~]$


And  the final status



[oracle@racnode1 ~]$ srvctl status database -d test

Instance test_2 is running on node racnode2

Online relocation: INACTIVE

[oracle@racnode1 ~]$

Hope this helps .


No comments: