| 终于有时间坐下来好好整理以下这个文档了:双机中安装第二个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
以上整个过程群集均未停用,正常运行
|