1、环境变量说明 操作系统:IBM AIX 版本是5.2.0.6 内存:4G HACMP版本:5.2 数据库:oracle10.1.0.2 本地磁盘空间:73G 阵列柜磁盘空间:73G*6,是RAID
2、HACMP安装
配置host
2.1 安装HACMP
1、编辑/etc/hosts文件 # Public Network 192.168.16.10 node1 192.168.16.11 node2 # Virtual IP address 192.168.16.8 node1_vip 192.168.16.9 node2_vip # Interconnect RAW 192.168.16.1 node1_raw 192.168.16.1 node2_raw 192.168.1.12 db_svr.cr-dengfeng.com db_svr 192.168.1.13 app_svr.cr-dengfeng.com app_svr 172.128.1.1 db_standby.cr-dengfeng.com db_standby 172.128.1.2 app_standby.cr-dengfeng.com app_standby 192.168.1.10 db_service.cr-dengfeng.com db_service 192.168.1.11 app_service.cr-dengfeng.com app_service 127.0.0.1 localhost.cr-dengfeng.com localhost 2、编辑/etc/hosts.equiv(№) nod1 root node2 root nod1_vip root node2_vip root nod1_raw root node2_raw root nod1 oracle node2 oracle nod1_vip oracle node2_vip oracle nod1_raw oracle node2_raw oracle 3、编辑root用户$HOME/.rhosts文件 nod1 root node2 root nod1_vip root node2_vip root nod1_raw root node2_raw root nod1 oracle node2 oracle nod1_vip oracle node2_vip oracle nod1_raw oracle node2_raw oracle 4、编辑oracle用户$HOME/.rhosts文件 nod1 root node2 root nod1_vip root node2_vip root nod1_raw root node2_raw root nod1 oracle node2 oracle nod1_vip oracle node2_vip oracle nod1_raw oracle node2_raw oracle 5、测试连接 node1:root-/> rlogin node2 (=> no password) node2:root-/> rcp /tmp/toto node2:/tmp/toto node2:oracle-/> su - oracle node2:oracle-/> rsh node1 date node2:oracle-/> sdfsvdv<sdv<vd<d 2004 2.3 配置资源组 2.4 配置HAGS sockets 1、check hagsuser group exists, else create it .place "oracle" into the "hagsuser" group 2、change the permissions on the "cldomain" executable #chmod a+x /usr/sbin/cluster/utilities/cldomain 3、change the group to "hagsuser" for the "svcsdsocket.rac92_cluster” socket # chgrp hagsuser /var/ha/soc/grpsvcsdsocket.rac92_cluster 4、change the group permissions for the "grpsvcsdsocket.rac92_cluster" socket #chmod g+w /var/ha/soc/grpsvcsdsocket.rac92_cluster 2.5 时间同步 1、Enter the following command to create required file if necessary # touch /etc/ntp.drift /etc/ntp.trace /etc/ntp.conf 2、Using any text editor, edit the /etc/ntp.config file: # vi /etc/ntp.conf 3、Add entries similar to the following to the file: # Sample NTP Configuration file # Specify the IP Addresses of three clock server systems. server ip_address1 server ip_address2 server ip_address3 # Most of the routers are broadcasting NTP time information. If your # router is broadcasting, then the following line enables xntpd # to listen for broadcasts. broadcastclient # Write clock drift parameters to a file. This enables the system # clock to quickly sychronize to the true time on restart. driftfile /etc/ntp.drift tracefile /etc/ntp.trace 4.、To start xntpd, follow these steps: a. Enter the following command: # /usr/bin/smitty xntpd b. Choose Start Using the xntpd Subsystem, then choose BOTH. 3 Oracle数据安装 3.1 AIX系统环境设置 1、修改/etc/security目录中limit文件 default: fsize = -1 core = 2097151 cpu = -1 data = -1 rss = 65536 stack = -1 nofiles = 2000 cat /etc/security/limits 2、系统内核参数设置 lsattr -El sys0 执行smit chgsys命令设置最大用户进程数为2048 或chdev -l sys0 -a maxuproc=2048 3、查看系统交换区 lsps –a 系统交换分区为4G 4、系统临时空间设置 临时空间不能小于800M 3.2 用户和组设置 1、执行smitty group创建如下组 dba Primary group for the oracle user. haguser For high availability (if not already created, and if HACMP used). 2、执行smitty user创建如下用户 oracle Owner of the database 3.3 Oracle用户环境设置 1、设置Oracle用户环境,$HOME/.profile # Oracle specific environment starts HERE HOST=`hostname -s` # This stanza selects the value of ORACLE_SID variable depending on the host the oracle # Deploying Oracle 9i RAC on IBM Eserver Cluster 1600 with GPFS # user logs in. case ${HOST} in node1) SID=1;; node2) SID=2;; esac # Variables needed during installation and normal operation export ORACLE_SID=rac${SID} export DISPLAY=.:0.0 export TEMP=/tmp export TMP=/tmp export ORACLE_BASE=/u01/app/oracle/ export AIXTHREAD_SCOPE=S umask 022 export ORACLE_CRS=$ORACLE_BASE/product/crs export ORACLE_CRS_HOME=$ORACLE_BASE/product/crs export ORACLE_HOME=$ORACLE_BASE/product/1012 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_CRS/lib: $ORACLE_HOME/lib32:$ORACLE_CRS/lib32 export PATH=$ORACLE_HOME/bin:$ORACLE_CRS/bin:$PATH 2、设置Oracle安装目录 * lsdev –Ccdisk | grep SCSI * mkvg -f -y'oraclevg' –s ‘32’ hadisk1 #crfs -v jfs2 -a bf=true -g'oraclevg' -a size='8388608' -m'/u01' -A'yes' -p'rw'-t'no'–a nbpi='8192' –a ag='64' #mount /u01 #chown oracle:dba /u01 3.4 设置裸设备(RAW)逻辑卷 1、创建逻辑卷
mklv –y 'ocr_disk' -w'n' -s'n' -r'n' oradatavg 4 hdisk2 mklv –y 'vote_disk' -w'n' -s'n' -r'n' oradatavg 4 hdisk2 mklv –y 'dfdb_control01' -w'n' -s'n' -r'n' oradatavg 4 hdisk2 mklv –y 'dfdb_control02' -w'n' -s'n' -r'n' oradatavg 4 hdisk2 mklv –y 'dfdb_control03' -w'n' -s'n' -r'n' oradatavg 4 hdisk2 mklv -y'dfdb_system' -w'n' -s'n' -r'n' oradatavg 12 hdisk2 mklv -y'dfdb_users' -w'n' -s'n' -r'n' oradatavg 4 hdisk2 mklv -y'dfdb_sysaux' -w'n' -s'n' -r'n' oradatavg 10 hdisk2 mklv -y'dfdb_tools' -w'n' -s'n' -r'n' oradatavg 2 hdisk2 mklv -y'dfdb_temp' -w'n' -s'n' -r'n' oradatavg 4 hdisk2 mklv -y'dfdb_index' -w'n' -s'n' -r'n' oradatavg 10 hdisk2 mklv -y'dfdb_lanwan' -w'n' -s'n' -r'n' oradatavg 20 hdisk2 mklv -y'dfdb_undotbs1' -w'n' -s'n' -r'n' oradatavg 10 hdisk2 mklv -y'dfdb_undotbs2' -w'n' -s'n' -r'n' oradatavg 10 hdisk2 mklv -y'dfdb_log11' -w'n' -s'n' -r'n' oradatavg 2 hdisk2 mklv -y'dfdb_log12' -w'n' -s'n' -r'n' oradatavg 2 hdisk2 mklv -y'dfdb_log21' -w'n' -s'n' -r'n' oradatavg 2 hdisk2 mklv -y'dfdb_log22' -w'n' -s'n' -r'n' oradatavg 2 hdisk2 mklv -y'dfdb_spfile' -w'n' -s'n' -r'n' oradatavg 1 hdisk2 oradatavg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT ocr_disk jfs 4 4 1 open/syncd N/A vote_disk jfs 4 4 1 open/syncd N/A dfdb_control01 jfs 4 4 1 open/syncd N/A dfdb_control02 jfs 4 4 1 open/syncd N/A dfdb_control03 jfs 4 4 1 open/syncd N/A dfdb_system jfs 12 12 1 open/syncd N/A dfdb_users jfs 4 4 1 open/syncd N/A dfdb_sysaux jfs 10 10 1 open/syncd N/A dfdb_tools jfs 2 2 1 closed/syncd N/A dfdb_temp jfs 4 4 1 open/syncd N/A dfdb_index jfs 10 10 1 closed/syncd N/A dfdb_lanwan jfs 20 20 1 closed/syncd N/A dfdb_undotbs1 jfs 10 10 1 open/syncd N/A dfdb_undotbs2 jfs 10 10 1 open/syncd N/A dfdb_log11 jfs 2 2 1 closed/syncd N/A dfdb_log12 jfs 2 2 1 closed/syncd N/A dfdb_log21 jfs 2 2 1 open/syncd N/A dfdb_log22 jfs 2 2 1 open/syncd N/A dfdb_spfile jfs 1 1 1 closed/syncd N/A # To be exectued on the secondary node (node1) chown oracle:dba /dev/dfdb* varyoffvg oradatvg # To be exectued on the secondary node (node2) importvg -y oradatvg –V80 hdisk5 varyonvg oradatvg chfs –c oradatvg chown oracle:dba /dev/dfdb* chmod go+rw /dev/dfdb* 3.5 安装Oracle Cluster Ready Service(CRS) 1、启动HACMP服务 2、Run the AIX command "/usr/sbin/slibclean" as "root" to clean all unreferenced libraries from memory. 3、Make sure to execute rootpre.sh by root on each node before you click to the next step. 4、若版本不支持 $./runInstaller –ignoreSysPrereqs 5、At the OUI Welcome screen 6、选择ORACLE_BASE路径,选择操作系统用户组dba 7、Connect as root on node 1, and run the orainstRoot.sh located in $ORACLE_BASE/oraInventory,This will change permissions, and group name to dba on the /etc/oraInst.loc file. 8、指定ORACLE_HOME路径和CRS安装路径 9、选择语言,English必须选 10、指定CRS节点名,名字为crs,同时指定公有节点名和私有节点名 11、设置私有连接 en0私有网络地址: en1公有网络地址: 12、指定RAW磁盘文件 Oracle Cluster Registry : /dev/rocr_disk Voting Disk : /dev/rvote_disk 13、在node1和node2上运行orainstRoot.sh脚本 14、摘要(Summary) 15、Installing 16、Install : Setup Privileges在所有节点上 在node1上执行root.sh,CSS最终在node1上Active. 在node2上执行root.sh,CSS最终在node1和node2上Active. 17、Configuration Assistants自动运行。 18、安装完毕 19、设置Oracle用户环境,$HOME/.profile,添加如下信息 export ORACLE_CRS=$ORACLE_BASE/crs export ORACLE_CRS_HOME=$ORACLE_BASE/crs export LD_LIBRARY_PATH=:$ORACLE_CRS/lib:ORACLE_CRS/lib32 export PATH=$ORACLE_CRS/bin:$PATH 20、启动和关闭CRS服务 /etc/init.crs start // start the CRS /etc/init.crs stop // stop the CRS 3.6 安装Oracle10g Database 1、启动HACMP服务 2、启动CRS服务 3、Make sure to execute rootpre.sh by root on each node before you click to the next step. 4、若版本不支持 $./runInstaller –ignoreSysPrereqs 5、At the OUI Welcome screen 6、指定ORACLE_HOME路径,不能和CRS安装在同一路径中 7、指定安装模式为Hardware Cluster Installation Mode,并选择安装的节点 8、选择安装类型为“Custom” 9、安装时检测系统环境(installer will check some product Prerequisite) 10、选择安装的产品组件 Make sure to select the “Oracle Real Application Clusters 10.1.0.2.0” option 11、Privileged Operating Systems Groups 输入:dba 12、是否创建数据库,选择“No” 13、摘要(Summary) 14、Installing 15、Install : Setup Privileges在所有节点上,同时配置VIP a、在node1上执行root.sh,之前要先设置DISPLAY。 b、The VIP “Welcome” graphical screen在执行root.sh之后。 c、选择一个网络接口,en1作为网络接口,en0是私有网络或RAC心跳连接(standby)。 d、输入VIP节点名和IP地址 e、VIP配置安装Summary f、VIP开始配置安装助理 g、VIP配置安装完成结果列表 h、VIP开始配置安装结束退出 在node2上执行root.sh,这个将没有显示窗体。 16、运行配置助理 运行Net Configure Assistant,选择“Perform Typical Configuration” 17、安装结束 18、设置Oracle用户环境,$HOME/.profile,添加如下信息 将以下粗体部分加入.profile export ORACLE_HOME=$ORACLE_BASE/db10g export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_CRS/lib: …. …. $ORACLE_HOME/lib32:$ORACLE_CRS/lib32 export PATH=$ORACLE_HOME/bin:$ORACLE_CRS/bin:$PATH 3.7 创建数据库 1、安装之前建立dfdb_raw_config.txt,设置oracle datafile和裸设备的对应关系,内容如下: System=/dev/dfdb_system users=/dev/dfdb_users tools=/dev/dfdb_tools temp=/dev/dfdb_temp index=/dev/dfdb_index lanwan=/dev/dfdb_lanwan sysaux=/dev/dfdb_sysaux undotbs1=/dev/dfdb_undotbs01 undotbs2=/dev/dfdb_undotbs02 log11=/dev/dfdb_log11 log12=/dev/dfdb_log12 log21=/dev/dfdb_log21 log22=/dev/dfdb_log22 spfile=/dev/dfdb_spfile control1=/dev/dfdb_control01 control2=/dev/dfdb_control02 control3=/dev/dfdb_control03 2、export DBCA_RAW_CONFIG /u01/dbca_raw_config 3、在两个节点上都启动数据库监听 $lsnrctl start 4、在Oracle用户运行以下命令 $dbca 5、DBCA Welcome Screen 6、选择操作“Create a Database” 7、选择节点 8、选择数据库模板“General Purpose” 9、指定数据库唯一实例标识 Global Database name:dfdb SID Prefix :dfdb 10、管理选项 Check “Configure the database with Enterprise Manager” if you want to use the Database Control (local administration). Don’t check if you plan to administrate the database using the Grid Control (global network administration) 11、数据库验证 指定所有用户相同的口令 12、选择数据存储模式 选择:Raw Device (HACMP) 3.8 配置listener.ora和tnsnames.ora CRS状态查看: crs_stat -t crs_stat -t gsdctl stat/start/stop crs_stat -t 数据库操作: srvctl status database -d dfdb srvctl start database -d dfdb gsdctl stat/start/stop 监听: lsnrctl stop lsnrctl start 配置数据库: Dbca 配置监听: Netmgr 查看节点: lsnodes -v |
|