双机中安装第二个Oracle库并用MC/ServiceGuard配包的全程实录

shgc

终于有时间坐下来好好整理以下这个文档了：双机中安装第二个Oracle库并用MC/ServiceGuard配包的全程实录
简要说明：rp5470双机，hp-ux B.11.11，oracle 9.2.0.6，磁盘阵列为7100，集群中原已有一个oracle库：ora9，文件系统已准备好，
vglock、vg01、vg02中的lv均来自磁盘阵列。
[/@machine01]vgchange -a y vg02
[/@machine01]mount /dev/vg02/data /data_sgc
[/@machine01]su - oracle
$vi .profile
改DISPLAY变量
$exit
[/@machine01]su - oracle
$dbca
在GUI中选Create a database-New Database-全局数据库名：ora9sgc.world,SID:ora9sgc-Dedicated Server
Mode-Initialization Parameters画面中Memory Tab中选Custon，默认参数;Character sets、DB Sizing、Fil
e Locations、ArchiveTAB中使用默认选项-改变DataBase Storage画面中Controlfile、datafile、Redo Log文
件位置均为/data_sgc/-Create a database并生成创建代码-OK
因为是练习，所以很多选项都是默认的
[/@machine01]#mkdir /etc/cmcluster/pkgsgc_ora
[/@machine01]#cmmakepkg -p /etc/cmcluster/pkgsgc_ora/pkgsgc_ora.conf
[/@machine01]#vi /etc/cmcluster/pkgsgc_ora/pkgsgc_ora.conf
PACKAGE_NAME pkgsgc_ora
PACKAGE_TYPE FAILOVER
FAILOVER_POLICY CONFIGURED_NODE
FAILBACK_POLICY MANUAL
NODE_NAME machine01
NODE_NAME machine02
AUTO_RUN YES
LOCAL_LAN_FAILOVER_ALLOWED YES
NODE_FAIL_FAST_ENABLED NO
RUN_SCRIPT /etc/cmcluster/pkgsgc_ora/pkgsgc_ora.cntl
RUN_SCRIPT_TIMEOUT NO_TIMEOUT
HALT_SCRIPT /etc/cmcluster/pkgsgc_ora/pkgsgc_ora.cntl
HALT_SCRIPT_TIMEOUT NO_TIMEOUT
SERVICE_NAME oracle_service1
SERVICE_FAIL_FAST_ENABLED NO
SERVICE_HALT_TIMEOUT 300
SUBNET 192.168.100.0
[/@machine01]#cmmakepkg -v -s /etc/cmcluster/pkgsgc_ora/pkgsgc_ora.cntl
[/@machine01]#vi /etc/cmcluster/pkgsgc_ora/pkgsgc_ora.cntl
VG[0]="/dev/vg02"
LV[0]="/dev/vg02/data"; FS[0]="/data_sgc"; FS_MOUNT_OPT[0]="-o rw"
IP[0]="192.168.100.42"
SUBNET[0]="192.168.100.0"
SERVICE_NAME[0]="oracle_service1"
SERVICE_CMD[0]="/etc/cmcluster/pkgsgc_ora/oracle9i.sh monitor"
SERVICE_RESTART[0]=""
function customer_defined_run_cmds
{
# ADD customer defined run commands.
: # do nothing instruction, because a function must contain some command.
/etc/cmcluster/pkgsgc_ora/oracle9i.sh start
test_return 51
}
function customer_defined_halt_cmds
{
# ADD customer defined halt commands.
: # do nothing instruction, because a function must contain some command.
/etc/cmcluster/pkgsgc_ora/oracle9i.sh halt
test_return 52
}
[/@machine01]cp /etc/cmcluster/pkg_ora/oracle9i.sh /etc/cmcluster/pkgsgc_ora/oracle9i.sh
[/@machine01]vi /etc/cmcluster/pkgsgc_ora/oracle9i.sh
SID_NAME=ora9sgc
ORACLE_HOME=/home/oracle/app/product/9.2.0
LISTENER_NAME=LISTENER1
LISTENER_PASS=
MONITOR_INTERVAL=30
PACKAGE_NAME=pkgsgc_ora
[/@machine01]#umount /data_sgc
[/@machine01]#vgchange -a n vg02
[/@machine01]vi /etc/cmcluster/clconfig.ascii
#增加一行
VOLUME_GROUP /dev/vg02
[/@machine01]#cd /etc/cmcluster
[/etc/cmcluster@machine01]#cmcheckconf -C clconfig.ascii
[/etc/cmcluster@machine01]#cmapplyconf -C clconfig.ascii
[/etc/cmcluster@machine01]#cmapplyconf -v -C clconfig.ascii
[/etc/cmcluster@machine02]#rcp -r machine01:/etc/cmcluster/pkgsgc_ora .
[/etc/cmcluster/pkgsgc_ora@machine01]#cmcheckconf -v -P pkgsgc_ora.conf
[/etc/cmcluster/pkgsgc_ora@machine01]#cmapplyconf -v -P pkgsgc_ora.conf
Y
[/@machine01]vi /etc/home/oracle/app/product/9.2.0/network/admin/listener.ora
# LISTENER.ORA Network Configuration File: /home/oracle/app/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.12)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/app/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora9)
(ORACLE_HOME = /home/oracle/app/product/9.2.0)
(SID_NAME = ora9)
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.42)(PORT = 1521))
)
)
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9sgc.world)
(ORACLE_HOME = /home/oracle/app/product/9.2.0)
(SID_NAME = ora9sgc)
)
)
[/etc/cmcluster/pkgsgc_ora@machine01]#cmmodpkg -v -e pkgsgc_ora#
启动包，成功
[/@machine02]#cd /home/oracle/app/admin
[/home/oracle/app/admin/@machine02]rcp –r machine01:/home/oracle/app/admin/ora9sgc .
[/home/oracle/app/admin@machine02]#chown -R oracle:dba ora9sgc
[/@machine02]vi /etc/home/oracle/app/product/9.2.0/network/admin/listener.ora
# LISTENER.ORA Network Configuration File: /home/oracle/app/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.12)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/app/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora9)
(ORACLE_HOME = /home/oracle/app/product/9.2.0)
(SID_NAME = ora9)
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.42)(PORT = 1521))
)
)
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9sgc.world)
(ORACLE_HOME = /home/oracle/app/product/9.2.0)
(SID_NAME = ora9sgc)
)
)
[/home/oracle/app/product/9.2.0/@machine02]rcp -r machine01:/home/oracle/app/product/9.2.0/dbs .
[/home/oracle/app/product/9.2.0/@machine02]chown oracle:dba dbs
以上整个过程群集均未停用，正常运行


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/923/showart_12153.html