《最终版Oracle_10g_RAC_For_Linux86_64安装.docx》由会员分享，可在线阅读，更多相关《最终版Oracle_10g_RAC_For_Linux86_64安装.docx（62页珍藏版）》请在三一办公上搜索。
1、Oracle 10g RAC For RHEL5 Linux86_64（裸设备）安装手册目录第一章 安装准备31.1 系统补丁包安装31.2 若连接存储为IP-SAN则需安装iscsi包，并开启iscsi服务31.3 关闭sendmail31.4 规划RAC网络及存储31.5 修改操作系统文件51.5.1 配置主机名51.5.2 配置网卡61.5.3 /etc/hosts61.5.4 /etc/sysctl.conf61.5.5 /etc/security/limits.conf71.5.6 /etc/pam.d/login71.5.7 /etc/profile71.5.8 /etc/modp
2、robe.conf71.5.9 /etc/rc.d/rc.local81.5.10 加载hangcheck模块81.5.11 修改系统版本号8oraclesohdb1 # vi /etc/redhat-release8oraclesohdb2 # vi /etc/redhat-release81.5.12 创建oracle安装用户81.5.13 创建oracle软件的相关目录81.5.14 修改oracle用户的环境变量81.5.15 修改root用户环境变量91.5.16 创建目录91.5.17 时间同步91.5.18 配置ssh91.5.19 绑定裸设备11第二章 安装ORACLECRS软
3、件112.1 安装的准备工作112.2 图形下安装122.2.1 CRS安装环境检查122.3 root执行vipca24第三章 安装ORACLE数据库软件28第四章 安装ORACLE10.2.0.4补丁354.1 安装oracle CRS补丁354.2 安装Oracle数据库补丁40第五章 创建数据库455.1 Dbca创建数据库45本文中黄色字体是用户手工输入的内容第一章 安装准备1.1 系统补丁包安装正式环境系统必须为linux64位系统，建议采用系统版本为5，由于64位需要打得包较多，故建议在系统安装时使用全安装。另外，实验环境中若使用32位系统则可使用默认安装，补订包的安装如下： #
4、 Mount /dev/cd-rom /media cd /media/cdrom/Server rpm -Uvh setarch-2* rpm -Uvh make-3* rpm -Uvh glibc-2* rpm -Uvh libaio-0* rpm -Uvh compat-libstdc+-33-3* rpm -Uvh compat-gcc-34-3* rpm -Uvh compat-gcc-34-c+-3* rpm -Uvh gcc-4* rpm -Uvh libXp-1* rpm -Uvh openmotif-2* rpm -Uvh compat-db-4* 1.2 若连接存储为IP-
5、SAN则需安装iscsi包，并开启iscsi服务安装iscsi包cd /media/cdrom/Serverrpm -Uvh iscsi-ini*/etc/init.d/iscsi startiscsiadm -m discovery -t st -p 192.168.1.10(存储地址)iscsiadm -m node -T XXX -p 192.168.1.10 -l1.3 关闭sendmail/etc/rc.d/rc.local sendmail stopchkconfig -level 12345 sendmail off1.4 规划RAC网络及存储IP规划：Public地址（公共网地
6、址）：10.1.17.210.1.17.3VIP地址（数据库服务地址）：10.1.17.410.1.17.5Privt地址（RAC心跳地址）：192.168.17.6192.168.17.7需要至少三块4G左右的盘，规划如下：/dev/sdb4G /dev/sdb1800m/dev/sdb2500m/dev/sdb3600m/dev/sdb5100m/dev/sdb6200m/dev/sdb7200m/dev/sdb8200m/dev/sdb9200m/dev/sdb10200m/dev/sdb11200m/dev/sdb12100m/dev/sdc4G/dev/sdc11200m/dev/s
7、dc2600m/dev/sdc3100m/dev/sdc5600m/dev/sdc6200m/dev/sdc7200m/dev/sdc8200m/dev/sdc9200m/dev/sdc10200m/dev/sdc11100m/dev/sdc12100m/dev/sdd4G/dev/sdd11024m/dev/sdd21024m/dev/sdd31024m/dev/sdd41024m划分磁盘后续执行partprobe重读分区表目的小大小 (MB)标准化大小 (MB)实验环境规划(MB)磁盘设备原始设备SYSTEM 表空间500600800/dev/sdb1/dev/raw/raw1SYSAUX
8、 表空间80012001200/dev/sdc1/dev/raw/raw2USERS 表空间120200500/dev/sdb2/dev/raw/raw3UNDOTBS1 表空间500600600/dev/sdc2/dev/raw/raw4UNDOTBS2 表空间500600600/dev/sdb3/dev/raw/raw5SPFILE550100/dev/sdc3/dev/raw/raw6口令文件550100/dev/sdb5/dev/raw/raw7TEMP 表空间250600600/dev/sdc5/dev/raw/raw8控制文件 1110200200/dev/sdb6/dev/raw
9、/raw9控制文件 2110200200/dev/sdc6/dev/raw/raw10控制文件 3110200200/dev/sdb7/dev/raw/raw11重做日志 1_1120200200/dev/sdc7/dev/raw/raw12重做日志 1_2120200200/dev/sdb8/dev/raw/raw13重做日志 1_3120200200/dev/sdc8/dev/raw/raw14重做日志 2_1120200200/dev/sdb9/dev/raw/raw15重做日志 2_2120200200/dev/sdc9/dev/raw/raw16重做日志 2_3120200200/d
10、ev/sdb10/dev/raw/raw17数据盘（用于存放表空间的数据文件）1024/dev/sdd1/dev/raw/raw18数据盘（用于存放表空间的数据文件）1024/dev/sdd2/dev/raw/raw19数据盘（用于存放表空间的数据文件）1024/dev/sdd3/dev/raw/raw20数据盘（用于存放表空间的数据文件）1024/dev/sdd5/dev/raw/raw21Oracle Cluster Registry100200200/dev/sdc10/dev/raw/raw22Oracle Cluster Registry100200200/dev/sdb11/dev
11、/raw/raw23Oracle CRS Voting2050100/dev/sdc11/dev/raw/raw24Oracle CRS Voting2050100/dev/sdb12/dev/raw/raw25Oracle CRS Voting2050100/dev/sdc12/dev/raw/raw26磁盘空间总计：3,9005,9501.4.1 fdisk划分磁盘使用fdisk命令按照如上方案在第一台机器上划分磁盘格式化第一块磁盘roothqportaldb1 # fdisk /dev/sdbDevice contains neither a valid DOS partition ta
12、ble, nor Sun, SGI or OSF disklabelBuilding a new DOS disklabel. Changes will remain in memory only,until you decide to write them. After that, of course, the previouscontent wont be recoverable.The number of cylinders for this disk is set to 9137.There is nothing wrong with that, but this is larger
13、than 1024,and could in certain setups cause problems with:1) software that runs at boot time (e.g., old versions of LILO)2) booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK)Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)Command (m for help)
14、: nCommand action e extended p primary partition (1-4)pPartition number (1-4): 1First cylinder (1-9137, default 1): 回车Using default value 1Last cylinder or +size or +sizeM or +sizeK (1-9137, default 9137): +800mCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition numb
15、er (1-4): 2First cylinder (488-9137, default 488): 回车Using default value 488Last cylinder or +size or +sizeM or +sizeK (488-9137, default 9137): +500MCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 3First cylinder (501-9137, default 501): 回车Using de
16、fault value 501Last cylinder or +size or +sizeM or +sizeK (501-9137, default 9137): +600mCommand (m for help): nCommand action e extended p primary partition (1-4)eSelected partition 4First cylinder (2934-9137, default 2934): 回车Using default value 2934Last cylinder or +size or +sizeM or +sizeK (2934
17、-9137, default 9137): 回车Using default value 9137Command (m for help): nFirst cylinder (2934-9137, default 2934): 回车Using default value 2934Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): +100mCommand (m for help): nFirst cylinder (5367-9137, default 5367): 回车Using default value
18、 5367Last cylinder or +size or +sizeM or +sizeK (5367-9137, default 9137): +200MCommand (m for help): nFirst cylinder (5429-9137, default 5429): 回车Using default value 5429Last cylinder or +size or +sizeM or +sizeK (5429-9137, default 9137): +200MCommand (m for help): nFirst cylinder (5454-9137, defa
19、ult 5454): Using default value 5454Last cylinder or +size or +sizeM or +sizeK (5454-9137, default 9137): +200MCommand (m for help): nFirst cylinder (5479-9137, default 5479): Using default value 5479Last cylinder or +size or +sizeM or +sizeK (5479-9137, default 9137): +200MCommand (m for help): nFir
20、st cylinder (5504-9137, default 5504): Using default value 5504Last cylinder or +size or +sizeM or +sizeK (5504-9137, default 9137): +200MCommand (m for help): nFirst cylinder (5517-9137, default 5517): Using default value 5517Last cylinder or +size or +sizeM or +sizeK (5517-9137, default 9137): +20
21、0MCommand (m for help): nFirst cylinder (5542-9137, default 5542): Using default value 5542Last cylinder or +size or +sizeM or +sizeK (5542-9137, default 9137): +100MCommand (m for help): wThe partition table has been altered!Calling ioctl() to re-read partition table.Syncing disks.格式化第二块磁盘：roothqpo
22、rtaldb1 # fdisk /dev/sdcCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 1First cylinder (1-9137, default 1): 回车Using default value 1Last cylinder or +size or +sizeM or +sizeK (1-9137, default 9137): +1200mCommand (m for help): nCommand action e exte
23、nded p primary partition (1-4)pPartition number (1-4): 2First cylinder (488-9137, default 488): 回车Using default value 488Last cylinder or +size or +sizeM or +sizeK (488-9137, default 9137): +600MCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 3First
24、 cylinder (501-9137, default 501): 回车Using default value 501Last cylinder or +size or +sizeM or +sizeK (501-9137, default 9137): +100mCommand (m for help): nCommand action e extended p primary partition (1-4)eSelected partition 4First cylinder (2934-9137, default 2934): 回车Using default value 2934Las
25、t cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): 回车Using default value 9137Command (m for help): nFirst cylinder (2934-9137, default 2934): 回车Using default value 2934Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): +600mCommand (m for help): nFirst cylinder (53
26、67-9137, default 5367): 回车Using default value 5367Last cylinder or +size or +sizeM or +sizeK (5367-9137, default 9137): +200MCommand (m for help): nFirst cylinder (5429-9137, default 5429): 回车Using default value 5429Last cylinder or +size or +sizeM or +sizeK (5429-9137, default 9137): +200MCommand (
27、m for help): nFirst cylinder (5454-9137, default 5454): Using default value 5454Last cylinder or +size or +sizeM or +sizeK (5454-9137, default 9137): +200MCommand (m for help): nFirst cylinder (5479-9137, default 5479): Using default value 5479Last cylinder or +size or +sizeM or +sizeK (5479-9137, d
28、efault 9137): +200MCommand (m for help): nFirst cylinder (5504-9137, default 5504): Using default value 5504Last cylinder or +size or +sizeM or +sizeK (5504-9137, default 9137): +200MCommand (m for help): nFirst cylinder (5517-9137, default 5517): Using default value 5517Last cylinder or +size or +s
29、izeM or +sizeK (5517-9137, default 9137): +100MCommand (m for help): nFirst cylinder (5542-9137, default 5542): Using default value 5542Last cylinder or +size or +sizeM or +sizeK (5542-9137, default 9137): +100MCommand (m for help): wThe partition table has been altered!Calling ioctl() to re-read pa
30、rtition table.Syncing disks.格式化第三块磁盘：roothqportaldb1 # fdisk /dev/sddCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 1First cylinder (1-9137, default 1): 回车Using default value 1Last cylinder or +size or +sizeM or +sizeK (1-9137, default 9137): +1024
31、mCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 2First cylinder (488-9137, default 488): 回车Using default value 488Last cylinder or +size or +sizeM or +sizeK (488-9137, default 9137): +1024mCommand (m for help): nCommand action e extended p primary
32、partition (1-4)pPartition number (1-4): 3First cylinder (501-9137, default 501): 回车Using default value 501Last cylinder or +size or +sizeM or +sizeK (501-9137, default 9137): +1024mCommand (m for help): nCommand action e extended p primary partition (1-4)eSelected partition 4First cylinder (2934-913
33、7, default 2934): 回车Using default value 2934Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): 回车Using default value 9137Command (m for help): nFirst cylinder (2934-9137, default 2934): 回车Using default value 2934Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137):
34、 +1024mCommand (m for help): wThe partition table has been altered!Calling ioctl() to re-read partition table.Syncing disks.按照磁盘分区规划，把全部磁盘划分完成以后在第二台机器上执行roothqportaldb2 # partprobe同步所有的磁盘分区1.5 修改操作系统文件本部分内容如无特别说明，分别在两台机器分别执行。1.5.1 配置主机名oraclesohdb1 # hostname sohdb1oraclesohdb1 # vi /etc/sysconfig/n
35、etwork修改文本中以下内容HOSTNAME=sohdb1oraclesohdb2 # hostname sohdb2oraclesohdb2 # vi /etc/sysconfig/network修改文本中以下内容HOSTNAME=sohdb21.5.2 配置网卡oraclesohdb1 # vi /etc/sysconfig/network-scripts/ifcfg-eth0需要修改一下信息：ONBOOT=yesBOOTPROTO=staticIPADDR=10.1.17.2NETMASK=255.255.255.0GATEWAY=10.1.17.1oraclesohdb1 # vi
36、/etc/sysconfig/network-scripts/ifcfg-eth1需要修改一下信息：ONBOOT=yesBOOTPROTO=staticIPADDR=192.168.17.6NETMASK=255.255.255.0oraclesohdb1 #service network restartoraclesohdb2 # vi /etc/sysconfig/network-scripts/ifcfg-eth0需要修改一下信息：ONBOOT=yesBOOTPROTO=staticIPADDR=10.1.17.3NETMASK=255.255.255.0GATEWAY=10.1.17.
37、1oraclesohdb2 # vi /etc/sysconfig/network-scripts/ifcfg-eth1需要修改一下信息：ONBOOT=yesBOOTPROTO=staticIPADDR=192.168.17.7NETMASK=255.255.255.0oraclesohdb2 #service network restart用命令查看网卡信息和状态oraclesohdb1 #ifconfig若有网卡未正常启用则可通过以下命令启用网卡oraclesohdb1 #ifup eth01.5.3 /etc/hosts127.0.0.1 localhost.localdomain lo
38、calhost10.1.17.2 sohdb110.1.17.3 sohdb210.1.17.4 sohdb1-vip10.1.17.5 sohdb2-vip192.168.17.6 sohdb1-priv192.168.17.7 sohdb2-priv1.5.4 /etc/sysctl.conf加入如下内容kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144
39、net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 net.ipv4.tcp_wmem = 262144 262144 262144net.ipv4.tcp_rmem = 4194304 4194304 4194304然后执行如下命令，让修改的参数生效# sysctl pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0ke
40、rnel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 68719476736kernel.shmall = 4294967296kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144
41、net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144net.ipv4.tcp_wmem = 262144 262144 262144net.ipv4.tcp_rmem = 4194304 4194304 41943041.5.5 /etc/security/limits.conf文件中加入如下内容oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655361.5
42、.6 /etc/pam.d/login文件中加入如下内容session required pam_limits.so1.5.7 /etc/profile文件中加入如下内容if $USER = oracle ; then ulimit -u 16384 ulimit -n 65536fi1.5.8 /etc/modprobe.conf文件加入options hangcheck-timer hangcheck_tick=30 hangcheck_margin=1801.5.9 /etc/rc.d/rc.local文件加入/sbin/modprobe hangcheck_timer1.5.10 加载
43、hangcheck模块# modprobe hangcheck_timer# grep hangcheck /var/log/messages | tail -2Jan 9 16:12:19 sohdb1 kernel: Hangcheck: starting hangcheck timer 0.9.0 (tick is 30 seconds, margin is 180 seconds).1.5.11 添加swapdd if=/dev/zero of=/swapfile bs=1024 count=2000000mkswap /swapfileswapon /swapfilemore /proc/swapsvi /etc/fstab添加如下一行/swapfileswapswapdefaults0 01.5.12 修改系统版本号oraclesohdb1 # vi /etc/redhat-releaseRed Hat Enterprise Linux Server release 4#Red Hat Enterprise Linux Server release 5 (Tikanga)oraclesohdb2 # vi /etc/redhat-release
