oracle数据库安装 - 图文(10)

? 修改oracle参数

? 关闭数据库和监听。

? 将/oracle下的所有文件tar个包。

$ cd /oracle

$ tar –cvf oracle.tar *

? ftp到B机器上的/oracle目录下，释放。tar –xvf *.tar ? import vg 过程

A机过程： # cd /

# varyoffvg oradata B机过程 # smit

选择存储管理->逻辑卷管理->卷组管理->import vg ->填写oradata和hdisk2 # varyonvg oradata ? 启动B机数据库，看是否能启动，如果可以，安装结束。

HACMP配置

在配置HA之前要能保证手工切换没有问题。在切换没有问题的前提下，我们就可以进行HA的配置了。

关闭两台机器上关于数据库和NC的所有应用。 理解HA中的概念和工作方式很重要。 资源： 资源包括应用程序，虚拟IP，卷组等等 资源组：

资源组就是将资源组织成一个整体。资源组中的节点的顺序就决定了谁是主谁是备。一旦主的出现问题，那么备机就要接管这个资源组的资源。

在本项目中要实现互备，那么我们怎么定义我们的资源呢？

首先我们有两个应用，一个是NC，一个是数据库。那么我们需要定义两个应用程序，并规划好应用程序的启停脚本。 其次我们有两个虚拟IP资源，因为一个应用需要一个。 最后我们需要两个资源组，一个NC，一个数据库的。 配置如下：

Cluster Name: erpcluster

Cluster Connection Authentication Mode: Standard Cluster Message Authentication Mode: None Cluster Message Encryption: None

Use Persistent Labels for Communication: No There are 2 node(s) and 1 network(s) defined

NODE ibmerpa: Network net_ether_01 ibmerpa_svc 128.128.1.14 ibmerpa_boot 128.128.1.13

ibmerpa_standby 192.168.200.2

NODE ibmerpb: Network net_ether_01 ibmerpb_svc 128.128.1.18 ibmerpb_boot 128.128.1.19 ibmerpb_standby 192.168.200.1

Resource Group orarg Startup Policy Online On Home Node Only Fallover Policy Fallover To Next Priority Node In The List Fallback Policy Fallback To Higher Priority Node In The List Participating Nodes ibmerpa ibmerpb Service IP Label ibmerpa_svc Volume group oradata

Resource Group ncrg Startup Policy Online On Home Node Only Fallover Policy Fallover To Next Priority Node In The List Fallback Policy Fallback To Higher Priority Node In The List Participating Nodes ibmerpb ibmerpa Service IP Label ibmerpb_svc

附录

/etc/hosts: 127.0.0.1 loopback localhost ibmerpb 128.128.1.13 ibmerpa_boot ibmerpa 128.128.1.14 ibmerpa_svc ibmerpa 192.168.200.2 ibmerpa_standby ibmerpa 128.128.1.19 ibmerpb_boot ibmerpb 128.128.1.18 ibmerpb_svc ibmerpb 192.168.200.1 ibmerpb_standby ibmerpb Oracle启动停止脚本： /usr/hascript/dbstart.sh:[给HA用的，root用户有权限] su - oracle -c \ /usr/hascipt/dbstop.sh:[给HA用的，root用户有权限] su - oracle -c \ /oracle/hascript/dbstartup.sh: [给oracle用的，oracle用户有权限] lsnrctl start sqlplus /nolog <

/oracle/hascript/dbstop.sh: [给oracle用的，oracle用户有权限 lsnrctl stop sqlplus /nolog <

export LANG=Zh_CN

/ncapp/IBM/WebSphere/AppServer/profiles/dmgr/bin/startManager.sh /ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startNode.sh

/ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startServer.sh master /ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startServer.sh ncMem01 /ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startServer.sh ncMem02 /ncapp/IBM/HTTPServer/bin/apachectl start /ncstop.sh

/ncapp/IBM/HTTPServer/bin/apachectl stop

/ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/stopServer.sh ncMem02 /ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/stopServer.sh ncMem01 /ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/stopServer.sh master /ncapp/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/stopNode.sh /ncapp/IBM/WebSphere/AppServer/profiles/dmgr/bin/stopManager.sh Oracle的.profile文件内容

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

if [ -s \ # This is at Shell startup. In normal then echo \ # operation, the Shell checks fi # periodically. export umask=022

export ORACLE_BASE=/oracle

export ORACLE_HOME=$ORACLE_BASE/app/9.2.0 export ORACLE_SID=ncerp

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export ORACLE_TERM=vt100

export NLS_LANG=american_america.zhs16gbk export

LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/network/lib

export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib

export PATH=$ORACLE_HOME/bin:.:$PATH:/usr/local/bin

建裸设备脚本[10g有所不同]

mklv -y'ora_system' -w'n' -s'n' -r'n' -t'jfs2' oradata 4 hdisk2 mklv -y'ora_drsys01' -w'n' -s'n' -r'n' -t'jfs2' oradata 4 hdisk2 mklv -y'ora_odm01' -w'n' -s'n' -r'n' -t'jfs2' oradata 4 hdisk2 mklv -y'ora_cwmlite01' -w'n' -s'n' -r'n' -t'jfs2' oradata 4 hdisk2 mklv -y'ora_examp01' -w'n' -s'n' -r'n' -t'jfs2' oradata 4 hdisk2 mklv -y'ora_index01' -w'n' -s'n' -r'n' -t'jfs2' oradata 4 hdisk2 mklv -y'ora_xdb01' -w'n' -s'n' -r'n' -t'jfs2' oradata 8 hdisk2 mklv -y'ora_tools01' -w'n' -s'n' -r'n' -t'jfs2' oradata 4 hdisk2 mklv -y'ora_undo' -w'n' -s'n' -r'n' -t'jfs2' oradata 16 hdisk2 mklv -y'ora_tmp' -w'n' -s'n' -r'n' -t'jfs2' oradata 16 hdisk2 mklv -y'ora_users' -w'n' -s'n' -r'n' -t'jfs2' oradata 8 hdisk2 mklv -y'ora_redo11' -w'n' -s'n' -r'n' -t'jfs2' oradata 1 hdisk2 mklv -y'ora_redo21' -w'n' -s'n' -r'n' -t'jfs2' oradata 1 hdisk2 mklv -y'ora_redo31' -w'n' -s'n' -r'n' -t'jfs2' oradata 1 hdisk2 mklv -y'ora_ctl1' -w'n' -s'n' -r'n' -t'jfs2' oradata 1 hdisk2 mklv -y'ora_ctl2' -w'n' -s'n' -r'n' -t'jfs2' oradata 1 hdisk2 mklv -y'ora_ctl3' -w'n' -s'n' -r'n' -t'jfs2' oradata 1 hdisk2

mklv -y'nnc_data0101' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0102' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0103' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0104' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0105' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0106' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0107' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0201' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0202' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0301' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0302' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0303' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0304' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0305' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_data0306' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0101' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0102' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0103' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0104' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0105' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0106' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0201' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0202' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0301' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0302' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0303' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0304' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2

mklv -y'nnc_index0305' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_index0306' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_iufo01' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2 mklv -y'nnc_iufo02' -w'n' -s'n' -r'n' -t'jfs2' oradata 20 hdisk2