中国IT动力,最新最全的IT技术教程
最新100篇 | 推荐100篇 | 专题100篇 | 排行榜 | 搜索 | 在线API文档
首 页 | 程序开发 | 操作系统 | 软件应用 | 图形图象 | 网络应用 | 精文荟萃 | 教育认证 | 硬件维护 | 未整理篇 | 站长教程
ASP JS PHP工程 ASP.NET 网站建设 UML J2EESUN .NET VC VB VFP 网络维护 数据库 DB2 SQL2000 Oracle Mysql
服务器 Win2000 Office C DreamWeaver FireWorks Flash PhotoShop 上网宝典 CorelDraw 协议大全 网络安全 微软认证
硬件维护  CPU  主板  硬盘  内存  显卡  显示器  键盘鼠标  声卡音箱  打印机  机箱电源  BIOS  网卡  C#  Java  Delphi  vs.net2005
  当前位置:> 操作系统 > HP-Unix
双机中安装第二个Oracle库并用MC/ServiceGuard配包的全程实录
作者:未知 时间:2005-09-13 22:55 出处:Blog.ChinaUnix.net 责编:chinaitpower
              摘要:双机中安装第二个Oracle库并用MC/ServiceGuard配包的全程实录
终于有时间坐下来好好整理以下这个文档了:双机中安装第二个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

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

关闭本页
 
首页 | 投资与合作 | 服务条款 | 隐私政策 | 收藏本站 | 设为首页 | 新用户注册 | 免责声明 | 使用帮助
Copyright ©2005-2008 chinaitpower.com All rights reserved. www.chinaitpower.com 版权所有