# mount -t iso9660 -o loop /root/LxRT50MP3.iso /mnt
# cd /mnt/rhel5_x86_64/cluster_server_agents/oracle_agent/rpms/
# rpm -ivh VRTSvcsor-5.0.30.00-MP3_RHEL4.i686.rpm
# cd /etc/VRTSagents/ha/conf/Oracle/
# cp -p OracleTypes.cf /etc/VRTSvcs/conf/config/
※注意:oracleユーザの環境変数で$を使うとVCSから読み込めないので、フルパス指定
例
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
↓
export LD_LIBRARY_PATH=/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib
参考:以下のファイルに作成方法が記載されている。
/opt/VRTSagents/ha/bin/Oracle/SqlTest.pl
vcsユーザ作成
$ sqlplus / as sysdba
SQL> create user vcs
2 identified by vcs
3 default tablespace USERS
4 temporary tablespace TEMP
5 quota 500K on USERS;
ユーザーが作成されました。
SQL> grant create session to vcs;
権限付与が成功しました。
vcsテーブル作成
SQL> create table vcs.table_vcs ( tstamp date );
表が作成されました。
SQL> insert into vcs.table_vcs ( tstamp ) values ( SYSDATE );
1行が作成されました。
テスト
$ sqlplus vcs/vcs
SQL> update vcs.table_vcs set ( tstamp ) = SYSDATE;
1行が更新されました。
SQL> select TO_CHAR(tstamp, 'MON DD, YYYY HH:MI:SS AM')tstamp from vcs.table_vcs;
TSTAMP
--------------------------------------------------------------------------------
12月 22, 2010 05:48:31 午後
VCSユーザのパスワードを暗号化
(暗号化されて表示されたパスワードをmain.cfの Pword = xxxx に記載)
# /opt/VRTSvcs/bin/vcsencrypt -agent vcs
IWOuLWl
# cd /etc/VRTSagents/ha/conf/Oracle/
# vi main.cf
include "types.cf"
include "OracleTypes.cf"
cluster vcs (
UserNames = { admin = aPQiPKpMQlQQoYQkPN }
Administrators = { admin }
)
system oracle01 (
ShutdownTimeout = 3600
)
system oracle02 (
ShutdownTimeout = 3600
)
group gr1 (
SystemList = { oracle01 = 0, oracle02 = 1 }
AutoStartList = { oracle01 }
)
DiskGroup gr1_DiskGroup_oracledg (
DiskGroup = oracledg
)
IP gr1_IP_eth1 (
Device = eth1
Address = "192.168.1.3"
NetMask = "255.255.255.0"
)
Mount gr1_Mount_ora_arch (
MountPoint = "/opt/oracle/ora_arch"
BlockDevice = "/dev/vx/dsk/oracledg/ora_arch"
FSType = vxfs
MountOpt = log
FsckOpt = "-y"
)
Mount gr1_Mount_ora_data (
MountPoint = "/opt/oracle/ora_data"
BlockDevice = "/dev/vx/dsk/oracledg/ora_data"
FSType = vxfs
MountOpt = log
FsckOpt = "-y"
)
Mount gr1_Mount_ora_redo (
MountPoint = "/opt/oracle/ora_redo"
BlockDevice = "/dev/vx/dsk/oracledg/ora_redo"
FSType = vxfs
MountOpt = log
FsckOpt = "-y"
)
NIC gr1_NIC_eth1 (
Device = eth1
NetworkHosts = { "192.168.1.254" }
)
Netlsnr gr1_Netlsnr_LISTENER (
Owner = oracle
Home = "/home/oracle/app/oracle/product/11.2.0/dbhome_1"
TnsAdmin = "/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora"
Listener = LISTENER
EnvFile = "/home/oracle/.bashrc"
)
Oracle gr1_Oracle_oracle (
Sid = hsmdb
Owner = oracle
Home = "/home/oracle/app/oracle/product/11.2.0/dbhome_1"
Pfile = "/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/inithsmdb.ora"
EnvFile = "/home/oracle/.bashrc"
DetailMonitor = 1
User = vcs
Pword = iwoUlwL
Table = table_vcs
)
gr1_DiskGroup_oracledg requires gr1_IP_eth1
gr1_IP_eth1 requires gr1_NIC_eth1
gr1_Mount_ora_arch requires gr1_DiskGroup_oracledg
gr1_Mount_ora_data requires gr1_DiskGroup_oracledg
gr1_Mount_ora_redo requires gr1_DiskGroup_oracledg
gr1_Netlsnr_LISTENER requires gr1_Oracle_oracle
gr1_Oracle_oracle requires gr1_Mount_ora_arch
gr1_Oracle_oracle requires gr1_Mount_ora_data
gr1_Oracle_oracle requires gr1_Mount_ora_redo
# vi /etc/hosts
192.168.1.1 oracle01
192.168.1.2 oracle02
192.168.1.3 oracle-vcs
- Oracleのinit.oraの作成(spfileから)
$ sqlplus / as sysdba
SQL> create pfile from spfile;
listener.oraのコピー
tnsnames.oraのコピー
pfileのコピー
ログファイルのコピー
稼動系でtar圧縮
# cd /home/oracle/app/oracle
# tar cvf admin.tar admin
# scp admin.tar oracle02:/home/oracle/app/oracle/
待機系でtar展開
# cd /home/oracle/app/oracle
# tar xvf admin.tar
# /opt/VRTSvcs/bin/hastart
# tail -f /var/VRTSvcs/log/engine_A.log
# /opt/VRTSvcs/bin/hastatus -sum
-- SYSTEM STATE
-- System State Frozen
A oracle01 RUNNING 0
A oracle02 RUNNING 0
-- GROUP STATE
-- Group System Probed AutoDisabled State
B gr1 oracle01 Y N ONLINE
B gr1 oracle02 Y N OFFLINE
コマンド
# /opt/VRTSvcs/bin/hacf -verify .
# /opt/VRTSvcs/bin/hastop -all
# /opt/VRTSvcs/bin/hagrp -clear gr1 oracle02
# hagrp -unfreeze gr1
# hagrp -freeze gr1
最終更新:2010年12月22日 18:24