oracle10gracforrhel5linux86_64安装

更多企业学院：更多企业学院：./Shop/./Shop/ 中小企业管理全能版183 套讲座+89700 份资料 ./Shop/40.shtml 总经理、高层管理49 套讲座+16388 份资料 ./Shop/38.shtml 中层管理学院46 套讲座+6020 份资料 ./Shop/39.shtml 国学智慧、易经46 套讲座 ./Shop/41.shtml 人力资源学院56 套讲座+27123 份资料 ./Shop/44.shtml 各阶段员工培训学院77 套讲座+ 324 份资料 ./Shop/49.shtml 员工管理企业学院67 套讲座+ 8720 份资料 ./Shop/42.shtml 工厂生产管理学院52 套讲座+ 13920 份资料 ./Shop/43.shtml 财务管理学院53 套讲座+ 17945 份资料 ./Shop/45.shtml 销售经理学院56 套讲座+ 14350 份资料 ./Shop/46.shtml 销售人员培训学院72 套讲座+ 4879 份资料 ./Shop/47.shtml 文件编号：文件编号： 内部文件内部文件 Oracle 10g RAC For RHEL5 Linux86_64 （裸设备）安装手册（裸设备）安装手册 北京海量智能数据有限公司北京海量智能数据有限公司 存储事业部存储事业部 二二 O O一一一一年年十十月月 目录 第一章第一章 安装准备安装准备 .3 1.1 系统补丁包安装3 1.2 若连接存储为 IP-SAN 则需安装ISCSI包，并开启ISCSI服务3 1.3 关闭SENDMAIL.3 1.4 规划 RAC 网络及存储3 1.5 修改操作系统文件5 1.5.1 配置主机名5 1.5.2 配置网卡6 1.5.3 /etc/hosts6 1.5.4 /etc/sysctl.conf.6 1.5.5 /etc/security/limits.conf .7 1.5.6 /etc/pam.d/login.7 1.5.7 /etc/profile7 1.5.8 /etc/modprobe.conf7 1.5.9 /etc/rc.d/rc.local .8 1.5.10 加载 hangcheck 模块.8 1.5.11 修改系统版本号8 oraclesohdb1 # vi /etc/redhat-release.8 oraclesohdb2 # vi /etc/redhat-release.8 1.5.12 创建 oracle 安装用户.8 1.5.13 创建 oracle 软件的相关目录.8 1.5.14 修改 oracle 用户的环境变量.8 1.5.15 修改 root 用户环境变量9 1.5.16 创建目录9 1.5.17 时间同步9 1.5.18 配置 ssh9 1.5.19 绑定裸设备11 第二章第二章 安装安装 ORACLECRS 软件软件 11 2.1 安装的准备工作11 2.2 图形下安装12 2.2.1 CRS 安装环境检查.12 2.3 ROOT执行VIPCA.24 第三章第三章 安装安装 ORACLE 数据库软件数据库软件 28 第四章第四章 安装安装 ORACLE10.2.0.4 补丁补丁 .35 4.1 安装ORACLE CRS 补丁.35 4.2 安装 ORACLE数据库补丁.40 第五章第五章 创建数据库创建数据库 .45 5.1 DBCA创建数据库.45 本文中黄色字体是用户手工输入的内容 第一章第一章安装准备安装准备 1.1 系统补丁包安装系统补丁包安装 正式环境系统必须为 linux64 位系统，建议采用系统版本为 5，由于 64 位需要打得包较多，故建议 在系统安装时使用全安装。 另外，实验环境中若使用 32 位系统则可使用默认安装，补订包的安装如下： # 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-SAN 则需安装则需安装 iscsi 包，并开启包，并开启 iscsi 服务服务 安装 iscsi 包 cd /media/cdrom/Server rpm -Uvh iscsi-ini* /etc/init.d/iscsi start iscsiadm -m discovery -t st -p 192.168.1.10(存储地址) iscsiadm -m node -T XXX -p 192.168.1.10 -l 1.3 关闭关闭 sendmail /etc/rc.d/rc.local sendmail stop chkconfig -level 12345 sendmail off 1.4 规划规划 RAC 网络及存储网络及存储 IP 规划： Public 地址（公共网地址）： 10.1.17.2 10.1.17.3 VIP 地址（数据库服务地址）： 10.1.17.4 10.1.17.5 Privt 地址（RAC 心跳地址）： 192.168.17.6 192.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/sdc2600m /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)(MB) 实验环境实验环境 规划规划(MB)(MB) 磁盘设备磁盘设备原始设备原始设备 SYSTEM 表空间 500600800/dev/sdb1/dev/raw/raw1 SYSAUX 表空间 80012001200/dev/sdc1/dev/raw/raw2 USERS 表空间 120200500/dev/sdb2/dev/raw/raw3 UNDOTBS1 表空 间 500600600/dev/sdc2/dev/raw/raw4 UNDOTBS2 表空 间 500600600/dev/sdb3/dev/raw/raw5 SPFILE550100/dev/sdc3/dev/raw/raw6 口令文件 550100/dev/sdb5/dev/raw/raw7 TEMP 表空间 250600600/dev/sdc5/dev/raw/raw8 控制文件 1 110200200/dev/sdb6/dev/raw/raw9 控制文件 2 110200200/dev/sdc6/dev/raw/raw10 控制文件 3 110200200/dev/sdb7/dev/raw/raw11 重做日志 1_1 120200200/dev/sdc7/dev/raw/raw12 重做日志 1_2 120200200/dev/sdb8/dev/raw/raw13 重做日志 1_3 120200200/dev/sdc8/dev/raw/raw14 重做日志 2_1 120200200/dev/sdb9/dev/raw/raw15 重做日志 2_2 120200200/dev/sdc9/dev/raw/raw16 重做日志 2_3 120200200/dev/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/raw21 Oracle Cluster Registry 100200200/dev/sdc10/dev/raw/raw22 Oracle Cluster Registry 100200200/dev/sdb11/dev/raw/raw23 Oracle CRS Voting 2050100/dev/sdc11/dev/raw/raw24 Oracle CRS Voting 2050100/dev/sdb12/dev/raw/raw25 Oracle CRS Voting 2050100/dev/sdc12/dev/raw/raw26 磁盘空间总计：磁盘空间总计： 3,9003,9005,9505,950 1.4.1 fdisk 划分磁盘划分磁盘 使用 fdisk 命令按照如上方案在第一台机器上划分磁盘 格式化第一块磁盘 roothqportaldb1 # fdisk /dev/sdb Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only, until you decide to write them. After that, of course, the previous content wont be recoverable. The number of cylinders for this disk is set to 9137. There is nothing wrong with that, but this is larger 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): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-9137, default 1): 回车 Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-9137, default 9137): +800m Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 2 First cylinder (488-9137, default 488): 回车 Using default value 488 Last cylinder or +size or +sizeM or +sizeK (488-9137, default 9137): +500M Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 3 First cylinder (501-9137, default 501): 回车 Using default value 501 Last cylinder or +size or +sizeM or +sizeK (501-9137, default 9137): +600m Command (m for help): n Command action e extended p primary partition (1-4) e Selected partition 4 First cylinder (2934-9137, default 2934): 回车 Using default value 2934 Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): 回车 Using default value 9137 Command (m for help): n First cylinder (2934-9137, default 2934): 回车 Using default value 2934 Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): +100m Command (m for help): n First cylinder (5367-9137, default 5367): 回车 Using default value 5367 Last cylinder or +size or +sizeM or +sizeK (5367-9137, default 9137): +200M Command (m for help): n First cylinder (5429-9137, default 5429): 回车 Using default value 5429 Last cylinder or +size or +sizeM or +sizeK (5429-9137, default 9137): +200M Command (m for help): n First cylinder (5454-9137, default 5454): Using default value 5454 Last cylinder or +size or +sizeM or +sizeK (5454-9137, default 9137): +200M Command (m for help): n First cylinder (5479-9137, default 5479): Using default value 5479 Last cylinder or +size or +sizeM or +sizeK (5479-9137, default 9137): +200M Command (m for help): n First cylinder (5504-9137, default 5504): Using default value 5504 Last cylinder or +size or +sizeM or +sizeK (5504-9137, default 9137): +200M Command (m for help): n First cylinder (5517-9137, default 5517): Using default value 5517 Last cylinder or +size or +sizeM or +sizeK (5517-9137, default 9137): +200M Command (m for help): n First cylinder (5542-9137, default 5542): Using default value 5542 Last cylinder or +size or +sizeM or +sizeK (5542-9137, default 9137): +100M Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. 格式化第二块磁盘： roothqportaldb1 # fdisk /dev/sdc Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-9137, default 1): 回车 Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-9137, default 9137): +1200m Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 2 First cylinder (488-9137, default 488): 回车 Using default value 488 Last cylinder or +size or +sizeM or +sizeK (488-9137, default 9137): +600M Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 3 First cylinder (501-9137, default 501): 回车 Using default value 501 Last cylinder or +size or +sizeM or +sizeK (501-9137, default 9137): +100m Command (m for help): n Command action e extended p primary partition (1-4) e Selected partition 4 First cylinder (2934-9137, default 2934): 回车 Using default value 2934 Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): 回车 Using default value 9137 Command (m for help): n First cylinder (2934-9137, default 2934): 回车 Using default value 2934 Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): +600m Command (m for help): n First cylinder (5367-9137, default 5367): 回车 Using default value 5367 Last cylinder or +size or +sizeM or +sizeK (5367-9137, default 9137): +200M Command (m for help): n First cylinder (5429-9137, default 5429): 回车 Using default value 5429 Last cylinder or +size or +sizeM or +sizeK (5429-9137, default 9137): +200M Command (m for help): n First cylinder (5454-9137, default 5454): Using default value 5454 Last cylinder or +size or +sizeM or +sizeK (5454-9137, default 9137): +200M Command (m for help): n First cylinder (5479-9137, default 5479): Using default value 5479 Last cylinder or +size or +sizeM or +sizeK (5479-9137, default 9137): +200M Command (m for help): n First cylinder (5504-9137, default 5504): Using default value 5504 Last cylinder or +size or +sizeM or +sizeK (5504-9137, default 9137): +200M Command (m for help): n First cylinder (5517-9137, default 5517): Using default value 5517 Last cylinder or +size or +sizeM or +sizeK (5517-9137, default 9137): +100M Command (m for help): n First cylinder (5542-9137, default 5542): Using default value 5542 Last cylinder or +size or +sizeM or +sizeK (5542-9137, default 9137): +100M Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. 格式化第三块磁盘： roothqportaldb1 # fdisk /dev/sdd Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-9137, default 1): 回车 Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-9137, default 9137): +1024m Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 2 First cylinder (488-9137, default 488): 回车 Using default value 488 Last cylinder or +size or +sizeM or +sizeK (488-9137, default 9137): +1024m Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 3 First cylinder (501-9137, default 501): 回车 Using default value 501 Last cylinder or +size or +sizeM or +sizeK (501-9137, default 9137): +1024m Command (m for help): n Command action e extended p primary partition (1-4) e Selected partition 4 First cylinder (2934-9137, default 2934): 回车 Using default value 2934 Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): 回车 Using default value 9137 Command (m for help): n First cylinder (2934-9137, default 2934): 回车 Using default value 2934 Last cylinder or +size or +sizeM or +sizeK (2934-9137, default 9137): +1024m Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. 按照磁盘分区规划，把全部磁盘划分完成以后在第二台机器上执行 roothqportaldb2 # partprobe 同步所有的磁盘分区 1.5 修改操作系统文件修改操作系统文件 本部分内容如无特别说明，分别在两台机器分别执行。 1.5.1 配置主机名配置主机名 oraclesohdb1 # hostname sohdb1 oraclesohdb1 # vi /etc/sysconfig/network 修改文本中以下内容 HOSTNAME=sohdb1 oraclesohdb2 # hostname sohdb2 oraclesohdb2 # vi /etc/sysconfig/network 修改文本中以下内容 HOSTNAME=sohdb2 1.5.2 配置网卡配置网卡 oraclesohdb1 # vi /etc/sysconfig/network-scripts/ifcfg-eth0 需要修改一下信息： ONBOOT=yes BOOTPROTO=static IPADDR=10.1.17.2 NETMASK=255.255.255.0 GATEWAY=10.1.17.1 oraclesohdb1 # vi /etc/sysconfig/network-scripts/ifcfg-eth1 需要修改一下信息： ONBOOT=yes BOOTPROTO=static IPADDR=192.168.17.6 NETMASK=255.255.255.0 oraclesohdb1 #service network restart oraclesohdb2 # vi /etc/sysconfig/network-scripts/ifcfg-eth0 需要修改一下信息： ONBOOT=yes BOOTPROTO=static IPADDR=10.1.17.3 NETMASK=255.255.255.0 GATEWAY=10.1.17.1 oraclesohdb2 # vi /etc/sysconfig/network-scripts/ifcfg-eth1 需要修改一下信息： ONBOOT=yes BOOTPROTO=static IPADDR=192.168.17.7 NETMASK=255.255.255.0 oraclesohdb2 #service network restart 用命令查看网卡信息和状态 oraclesohdb1 #ifconfig 若有网卡未正常启用则可通过以下命令启用网卡 oraclesohdb1 #ifup eth0 1.5.3 /etc/hosts 127.0.0.1 localhost.localdomain localhost 10.1.17.2 sohdb1 10.1.17.3 sohdb2 10.1.17.4 sohdb1-vip 10.1.17.5 sohdb2-vip 192.168.17.6 sohdb1-priv 192.168.17.7 sohdb2-priv 1.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 = net.core.rmem_max = net.core.wmem_default = net.core.wmem_max = net.ipv4.tcp_wmem = net.ipv4.tcp_rmem = 然后执行如下命令，让修改的参数生效 # sysctl p net.ipv4.ip_forward = 0 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = kernel.shmall = 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 = net.core.rmem_max = net.core.wmem_default = net.core.wmem_max = net.ipv4.tcp_wmem = net.ipv4.tcp_rmem = 1.5.5 /etc/security/limits.conf 文件中加入如下内容 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 1.5.6 /etc/pam.d/login 文件中加入如下内容 session required pam_limits.so 1.5.7 /etc/profile 文件中加入如下内容 if $USER = “oracle“ ; then ulimit -u 16384 ulimit -n 65536 fi 1.5.8 /etc/modprobe.conf 文件加入 options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180 1.5.9 /etc/rc.d/rc.local 文件加入 /sbin/modprobe hangcheck_timer 1.5.10 加载加载 hangcheck 模块模块 # modprobe hangcheck_timer # grep hangcheck /var/log/messages | tail -2 Jan 9 16:12:19 sohdb1 kernel: Hangcheck: starting hangcheck timer 0.9.0 (tick is 30 seconds, margin is 180 seconds). 1.5.11 添加添加 swap dd if=/dev/zero of=/swapfile bs=1024 count= mkswap /swapfile swapon /swapfile more /proc/swaps vi /etc/fstab 添加如下一行 /swapfile swapswapdefaults0 0 1.5.12 修改系统版本号修改系统版本号 oraclesohdb1 # vi /etc/redhat-release Red Hat Enterprise Linux Server release 4 #Red Hat Enterprise Linux Server release 5 (Tikanga) oraclesohdb2 # vi /etc/redhat-release Red Hat Enterprise Linux Server release 4 #Red Hat Enterprise Linux Server release 5 (Tikanga) 1.5.13 创建创建 oracle 安装用户安装用户 # groupadd -g 300 dba # useradd -u 500 -g dba oracle # passwd oracle Changing password for user oracle. New UNIX password: oracle BAD PASSWORD: it is based on a dictionary word Retype new UNIX password: oracle passwd: all authentication tokens updated successfully. 1.5.14 创建创建 oracle 软件的相关目录软件的相关目录 # su - oracle 1.5.15 修改修改 oracle 用户的环境变量用户的环境变量 oracle 用户的环境变量文件/oracle/.bash_profile 文件加入如下内容 export ORACLE_BASE=/home/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs export ORACLE_SID=sohdb1 # export ORACLE_SID=sohdb2 #2 机器的环境变量 export PATH=$ORA_CRS_HOME/bin:$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export LC_CTYPE=en_US.UTF-8 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export TMPDIR=/tmp export TMP=/tmp 1.5.16 修改修改 root 用户环境变量用户环境变量 root 用户的环境变量文件/root/.bash_profile 文件，加入如下内容： export ORACLE_BASE=/home/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs export PATH=$ORA_CRS_HOME/bin:$ORACLE_HOME/bin:$PATH export LC_CTYPE=en_US.UTF-8 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK 1.5.17 时间同步时间同步 oraclesohdb1 # chkconfig ntpd on oraclesohdb1 # /etc/init.d/ntpd start oraclesohdb1 # vi /etc/ntp.conf (在末尾加上以下两句) server 10.1.17.2 restrict 10.1.188.0 mask 255.255.255.0 nomodify oraclesohdb1 #vi /etc/sysconfig/ntpd SYNC_HWCLOCK=yes oraclesohdb1 #/etc/init.d/ntpd restart 查看 ntp 时间服务器同步状态，需要等待 5-10 分钟，当确定 reach17 则可使用 ntp 同步： oraclesohdb1 # ntpq -p oraclesohdb2 #vi /etc/sysconfig/ntpd SYNC_HWCLOCK=yes oraclesohdb1 #ntpdate 10.1.17.2 1.5.18 配置配置 ssh 第一台机器 oracle 用户生成密钥 oraclesohdb1 $ ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/.ssh/id_rsa): Created directory /oracle/.ssh. Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /.ssh/id_rsa. Your public key has been saved in /.ssh/id_rsa.pub. The key fingerprint is: 91:e7:72:37:72:07:82:e1:53:7d:1b:3a:46:84:1b:c6 oraclesohdb1 oraclesohdb1 $ ssh-keygen -t dsa Generating public/private dsa key pair. Enter file in which to save the key (/.ssh/id_dsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /.ssh/id_dsa. Your public key has been saved in /.ssh/id_dsa.pub. The key fingerprint is: 99:61:03:9f:86:4d:4e:d4:19:c0:c6:3f:ad:e0:82:50 oraclesohdb1 第二台机器 oracle 用户生成密钥 oraclesohdb2 $ ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/.ssh/id_rsa): Created directory /oracle/.ssh. Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /.ssh/id_rsa. Your public key has been saved in /.ssh/id_rsa.pub. The key fingerprint is: ab:50:7b:f9:b0:68:35:57:96:c0:18:72:3f:6e:c1:f8 oraclesohdb2 oraclesohdb2 $ ssh-keygen -t dsa Generating public/private dsa key pair. Enter file in which to save the key (/.ssh/id_dsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /.ssh/id_dsa. Your public key has been saved in /.ssh/id_dsa.pub. The key fingerprint is: d6:d6:dc:a7:7d:04:1e:b5:89:13:07:97:9c:62:9a:a2 oraclesohdb2 第一台机器生成认证文件 oraclesohdb1 $ ssh sohdb1 cat /.ssh/id_rsa.p