1、#./hacon三、 配置Rose HA1、管理界面的启动# ./hacon2、连接: 进入Tools-Connect,输入Server:localhostUser:rootPassword:3、license号输入:进入 Tools-License,输入HostName:左边为本机主机名,右边为远程主机名。(把左边主机名输入后,按Tab键可把光标移动到右边,输入远程主机名,点击ok)4、创建RS232私网:进入PrivateNet-Create RS232,把两台主机的DeviceName改成/dev/ttys0。该操作在两台主机上都要做5、创建socket 私网进入PrivateNet-C
2、reate Socket, 选择主机用于私网的地址,输入远程主机用于私网的地址。说明:这是两台机器通讯用的IP地址(心跳IP),6、获取对方主机信息: 进入 Tools-Network,直接选中AutoGet ,OK。这样就会得到对方主机信息。7、创建服务:进入Services-Create,Type:ORACLE IP Holding NIC:分别选择两台主机所提供外界服务的网卡设备名(如:eth0),不能与心跳网卡在同一个设备上。Active IP Address:这是为外界数据库服务的IP(虚拟IP)地址。此地址必须与公网的实际IP在同一网段上(也就是与在IP Holding NIC中所
3、选择的网卡实际IP在同一网段上)。Active SubnetMask:虚拟IP的子网掩码。Agent Script:相应的监控脚本,如:ha_ag_oracle.x。Start Script:相应的启动脚本,如: ora_start.sh。Stop Script:相应的停止脚本,如:ora_stop.sh。Active Volume:磁盘阵列两台主机共用的文件系统的设备名。如:/dev/sdb1Backup Volume:Active Volume应与Backup Volume的值相同。Mount Point:与Active Volume,Backup Volume 值所对应的mount 点。
4、/oracleSwitchBack:NO8、Oracle9.2.0的启动脚本(1)ora_start.sh#!/bin/sh# This file: ora_start.sh# Version: 4.0.1HAHOME=cat /etc/init.d/HAHOMEexport HAHOMEout=$HAHOME/bin/APIOUT.xJOBNAME=$2# When Another Server are Down, You MUST sleep awhile.# You can change this value to meet your requirement if need.if $1
5、= anotherdown then /bin/sleep 30fi# DISKDEV=/dev/sda5# MOUNTPOINT=/oracle# $HAHOME/bin/dflush $DISKDEV# fsck -a $DISKDEV# if test $? -ne 0# then# $out INFO fsck $DISKDEV.# fsck -yf $DISKDEV# fi# mount $DISKDEV $MOUNTPOINT# mount | grep $DISKDEV on $MOUNTPOINT /dev/null 2&1INFO Cannot mount $DISKDEV.
6、# exit$HAHOME/bin/ha_ag_oracle.x $JOBNAME 0if test $? -eq 0 $out INFO The service has started. exitelseINFO Start Oracle server. su - oracle -c $HAHOME/bin/ora_dbshut_ab.sh$HAHOME/bin/ora_dbstart.sh$out INFO Start shell finished.(2) ora_dbstart ora_dbstart.shif test ! -o !$2 echo ora_dbstart.sh: Mes
7、sage: ORACLE_SID LISTENER not specified. ORACLE_SID=$1 LISTENER=$2 export ORACLE_SID# start Oracle Instance # You MUST choose a Oracle setup mode to meet your requirement.# The nether lines for Oracle Version 9 or Latersqlplus / as sysdba !startupexit# The nether lines for Oracle Version 8 or Older#
8、 svrmgrl # connect internal # startup# exit# !# start Oracle listenerlsnrctl start $29、Oracle9.2.0的停止脚本(1)ora_stop.sh ora_stop.shERRORNUMBER=$3 stop because of $ERRORNUMBER.INFO Stop Oracle server immediate.$HAHOME/bin/ora_dbshut_im.shINFO Stop Oracle server.sync# $HAHOME/bin/UMOUNT $DISKDEV $MOUNTP
9、OINTWARNING Cannot umount $DISKDEV.# /sbin/rebootINFO Stop shell (2) ora_dbshut_ab ora_dbshut_ab.shCOLUMNS=1024export COLUMNSora_dbshut_ab.sh: ORACLE_SID or LISTENER not specified. LSNR_PID=ps -ef | grep tnslsnr | grep -v grep | awk -F print $2 ORACLE_SID=$ORACLE_SID, LISTENER=$LISTENER. LSNR_PID=ps
10、 -ef | grep tnslsnr | grep $LISTENER | grep -v grep | awk -F# Kill Oracle Listenerif EMPTY$LSNR_PID = EMPTY Not found listener process Kill oracle listener process . kill -9 $LSNR_PID# Stop Oracle Instance # You MUST choose a Oracle stop mode to meet your requirement. shutdown abort !# The nether li
11、nes for Oracle Version 8 or older# shutdown abort四、卸载Rose HA#./uninstall.sh五、Rose HA常用的命令、工具及故障处理方法1、相关命令:查询Roseha进程的命令: #ps ef | grep ha hamond、hasysd、hachkd、hasvrd停止Roseha进程的命令:#ha_kill ha手工启动Roseha进程的命令:#hamond进入Roseha软件的命令:#hacon2、双机软件的开关机顺序开机:先后依次开磁盘阵列,主机,备机。关机:先后依次关备机,主机,磁盘阵列。3、双机软件中的术语:Bring
12、in: 把服务带入双机,受双机软件管理。Bring out: 把服务带出双机,不受双机软件管理。Take over:手工切换服务。在备机动作,来接管主机服务。Fail over: 手工切换服务。在主机动作,来提交主机服务给备机。六、RedHat9.0操作系统安装简要介绍1、注意事项分区的时候,swap分区为2047,native分区为剩余硬盘的容量。2、加挂磁盘阵列(1)分区fdisk /dev/sdb Command (m for help) : ma. toggle a bootable flag.b. edit bsd disklabel.c. toggle the dos compat
13、ibility flag.d. delete a partition.l. list known partition types.m. Print this menu.n. Add a new partition.o. Add a new empty Dos partition table.p. Print the partition table.q. Quit without saving changes.s. create a new empty Sun disklabel.t. change a partitions system id.u. Change display/entry u
14、nits.v. Verify the partition table.w. Write table to disk and exit.x. Extra functionality (experts only).Command (m for help) : nCommand actione extended p primary partition(1-4) pPartition number(1-4) : 1First cylinder (1-554,default 1) :Last cylinder or +size or +sizeM or +sizeK (1-554,default 554
15、) :w(2)制作文件系统mkfs /dev/sdb13、在安装CD中安装以下补丁包compat-gcc-7.3-2.96.118.i386.rpmcompat-libgcj-7.3-2.96.118.i386.rpmcompat-libgcj-devel-7.3-2.96.118.i386.rpmnss_db-compat-2.2-20.i386.rpm七、Oracle9.2.0数据库安装介绍1、 解压:gunzip lnx_920_disk1.cpio.gz解压9i数据库:cpio idmv sem #cat shmmax 返回值(33-) #echo 4294967295 shmmax
16、(该值为内存) #echo 4096 shmmni #echo 2097152 shmall在文件中:/etc/sysctl.conf添加: kernel.shmmax=4294967295 kernel.sem=100 32000 100 100 #echo 65536 /proc/sys/fs/file-max #ulimit n 65536 #echo 1024 65000 /proc/sys/net/ipv4/ip_local_port_range #ulimit u 163842、安装Jdk1.1.8_v3到/usr/localbunzip2 jdk118_v3.tar.bz2tar
17、 xvf jdk118_v3.tarmv jdk118_v3 javachown R oracle:dba /usr/local/java3、RACLE的配置文件.bash_profile.bash_profile内容如下:# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then . /.bashrc# User specific environment and startup programsPATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport PATHunset USERNAME
18、LANG=En_cn; export LANGORACLE_HOME=/home/oracle/9.2.0; export ORACLE_HOMEORACLE_BASE=/home/oracle; export ORACLE_BASEORACLE_SID=ora;NLS_LANG=american_america.zhs16cgb231280; export NLS_LANGORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBR
19、ARY_PATHCLASSPATH=.:$ORACLE_HOME/jdbc/lib/classes12.zip; export CLASSPATH$ORACLE_HOME/bin:$ORACLE_HOME/dba:/etc; export PATHDISPLAY=:0.0; export DISPLAYTMPDIR=/tmp; export TMPDIRJAVA_HOME=/usr/local/java; export JAVA_HOMEORACLE_TERM=xtermexport LD_ASSUME_KERNEL=2.4.1umask=022 (二)安装ORACLE数据库在图形界面下进入终
20、端:#export DISPLAY=主机名:0.0#xhost +hostname#su oracle$./runInstaller安装过程中可能会报错:Error in invoking taget install of makefile /opt/oracle/product/9i/ctx/lib/ins_oemagent错误,选择ignore,安装完后修复当link进行到84%时出现一个关于ins_ctx错误,编辑$ORACLE_HOME/ctx/lib/env_ctx.mk文件,在“INSO_LINK=”后面加入:$(LDLIBFLAG)dl即可安装完成修复第一个错误在shell下,o
21、racle用户编辑$ORACLE_HOME/ctx/lib/ins_ctx.mk文件在1314行处把$(LINK)$(CTXHXOBJ)$(INSO_LINK) 改为$(LINK)ldl$(INSO_LINK)cd$ORACLE_HOME/network/libmakefins_net_client.mkinstall蓝色部分可以不做。make f $ORACLE_HOME/ctx/lib/ins_ctx.mk install在安装Oracle数据库时,把应用程序安装在本地,把库建在盘阵上。具体步骤如下:4、在SERVER1和SERVER2上安装Oracle应用程序。5、用dbca命令在SER
22、VER1上建库。6、把主机SERVER1上/home/oracle/9.2.0/network/admin下的listener.ora和tnsnames.ora文件中的主机名改为虚拟IP。把SERVER1上/home/oracle/o9.2.0/dbs/下的orapw和/home/oracle/9.2.0/network/admin下的listener.ora和tnsnames.ora复制到主机B上相应位置。/home/oracle/oracle8i/dbs/orapwconn sys/oracle as sysdba 注: oracle为sys的密码archive log listselect * from tab;SVRMGR shutdown immediate二、 故障解决1、先建库的机器数据库启动不了,这可能是两台机器上的ORACLE用户的ID号不同(看ORACLE用户的ID号用如下命令:id oracl
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1