How to add Oracle Database under VCS configuration using Command Line.
book
Article ID: 100023067
calendar_today
Updated On:
Resolution
1) Make sure that Oracle Agent Package is installed and the version is as per Agent Support Matrix.
#pkginfo -l VRTSvcsor (For Solaris)
#rpm -qa | grep VRTSvcsor (For Linux)
#lslpp -l | grep VRTSvcsor (For AIX)
#swlist | grep VRTSvcsor (For HP-UX)
Also, make sure that after OracleAgent installation, you have imported OracleTypes.cf file as follows...
To import using the command line
1 Log in to node as super user.
2 Ensure that all changes to the existing configuration have been saved and that further changes are prevented while you modify main.cf:
#haconf -dump -makero
3 To ensure that VCS is not running while you edit main.cf, stop the VCS engine on all nodes and leave the resources available:
# hastop -all -force
4 Make a backup copy of the main.cf file:
# cd /etc/VRTSvcs/conf/config
# cp main.cf main.cf.orig
5 Copy the Oracle types configuration file into place:
# cp /etc/VRTSagents/ha/conf/Oracle/OracleTypes.cf /etc/VRTSvcs/conf/config/OracleTypes.cf
6 Edit the main.cf file to include the OracleTypes.cf file:
include "OracleTypes.cf"
Now, once the cluster is up and running using #hastart
2) Configure SG as in following Example...
A)Open the Cluster Configuration
# haconf -makerw
B)Add the SG in cluster
#hagrp -add Service_Group_Name
e.g # hagrp -add ORAPRD
Add the System List and AutoStart list as per the requirement.
#hagrp -modify ORAPRD SystemList system1 0 system2 1
#hagrp -modify ORAPRD AutoStartList system1 system2
C) Add the Resources to SG :
i) Add Oracle DB Resource :
#hares -add Resource_Name Resource_Type Service_Group_Name
e.g #hares -add DB_FINPRD Oracle ORAPRD
ii) Add Listener Resource :
#hares -add Listener_Resource_Name Netlsnr Service_Group_Name
e.g #hares -add Listener_FINPRD Netlsnr ORAPRD
iii) Add IP Resource :
#hares -add IP_Resource_Name IP Service_Group_Name
e.g #hares -add IP_Prod IP ORAPRD
iv) Add NIC Resource :
#hares -add NIC_Resource_Name NIC Service_Group_Name
e.g #hares -add NIC_Prod NIC ORAPRD
v) Add Volume Resource:
#hares -add Volume_Resource_Name Volume Service_Group_Name
e.g.#hares -add ORAVol Volume ORAPRD
vi) Add Diskgroup Resource :
#hares -add Diskgroup_Resource_Name DiskGroup Service_Group_Name
e.g #hares -add ORADG DiskGroup ORAPRD
vii) Add Mount Resource :
#hares -add Mount_Resource_Name Mount Service_Group_Name
e.g #hares -add ORAMOUNT Mount ORAPRD
D) Now Add the Required Attributes for each of the Resources using the following command syntax :
#hares -modify Resource_Name Attribute Value
For Oracle Resource :
#hares -modify DB_FINPRD SID Test1 (here Test1is the Oracle DB instance Name)
#hares -modify DB_FINPRD Owner Oracle (here Oracle is the Owner for Oracle)
#hares -modify DB_FINPRD Home/oracle/product/10.2.0 (here /oracle/product/10.2.0 is the Oracle Home Directory)
For Listener Resource :
#hares -modify Listener_FINPRD Owner Oracle (here Oracle is the Owner for Oracle)
#hares -modify Listener_FINPRD Home /oracle/product/10.2.0 (here /oracle/product/10.2.0is the Oracle Home Directory)
For IP Resource :
#hares -modify IP_Prod Address 10.154.146.178 (here 10.154.146.178 is the Virtual IP)
#hares -modify IP_Prod Device ce0 (here ce0 is the NIC Device)
For NIC Resource :
#hares -modify NIC_Prod Device ce0 (here ce0 is the NIC Device. This NIC is separate NIC and not used anywhere)
For Volume Resource :
#hares -modify ORAVol Volume testvol (here testvol is the volume for Oracle Home)
#hares -modify ORAVol DiskGroup testdg (here testdg is the Diskgroup for volume)
For Diskgroup Resource:
#hares -modify ORADG DiskGroup testdg (here testdg is the Diskgroup for volume)
#hares -modify ORADG DiskGroupType private
For Mount Resource :
#hares -modify ORAMOUNT BlockDevice /dev/vx/dsk/testdg/testvol
#hares -modify ORAMOUNT FSType vxfs
#hares-modify ORAMOUNT FsckOpt "%-y"
#hares -modify ORAMOUNT MountPoint /oracle
E) Now Add the dependencies using following command...
#hares -link Resource_Name Resource_it_depends_on
e.g
#hares -link Listener_FINPRD DB_FINPRD
#hares -link DB_FINPRD IP
#hares -link DB_FINPRD ORAMOUNT
#hares -link ORAVol ORADG
#hares-link ORAMOUNT ORAVol
#hares -link IP NIC
Here we completed SG configuration.
3) Now, Start the SG and Failover as following..
i) Enable All Resources for SG:
#hagrp-enable resources Service_Group_Name
e.g # hagrp -enable resources ORAPRD
ii) Online the SG on node 1 :
#hagrp -online Service_Group_Name -sys System_Name
e.g #hagrp -online ORAPRD -sys node1
Now check #hastatus -sum and verify the status on SG.
iii) Failover SG to node 2 :
#hagrp -switch Service_Group_Name -to System_Name
e.g #hagrp -switch ORAPRD -to node2
Check #hastatus -sum and confirm the status of ServiceGroup.
4) Save & Close the Cluster Configuration
#haconf -dump-makero
Issue/Introduction
How to add Oracle Database under VCS configuration using Command Line.
Was this article helpful?
thumb_up
Yes
thumb_down
No