windows下安装oracle双机,双机中安装第二个Oracle库并用MC/ServiceGuard配包的全程实录Windows系统 -电脑资料...

终于有时间坐下来好好整理以下这个文档了：双机中安装第二个Oracle库并用MC/ServiceGuard配包的全程实录 简要说明：rp5470双机，hp-ux B.11.11，oracle 9.2.0.6，磁盘阵列为7100，集群中原已有一个oracle库：ora9，文件系统已准备好， vglock、vg01、vg02中终于有时间坐下来好好整理以下这个文档了：双机中安装第二个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

以上整个过程群集均未停用，正常运行

原文转自：http://www.ltesting.net