Install Oracle 11gR2 RAC on RedHat Linux AS 5.4
- 格式:docx
- 大小:4.41 MB
- 文档页数:89
Rhel6.6_Oracle11gR2(ASM,UDEV)的RAC搭建安装本次演示是在Rhel6.6环境下Oracle11gR2的RAC搭建安装环境:VM + Rhel6.6 + GI + Oracle11gR2基本信息1)安装包Rhel6 : rhel-server-6.6-x86_64-dvd.isoOracle11gR2:p1*******_112040_Linux-x86-64_1of7.zipp1*******_112040_Linux-x86-64_2of7.zipGrid Infrastructure(GI):p1*******_112040_Linux-x86-64_3of7.zip2)服务器环境1、两台虚拟机信息:hostname:RAC1 , ip:hostname:RAC2 , ip:72、心跳IP信息:RAC1的心跳IP:192.168.1.106RAC2的心跳IP:192.168.1.1073、VIP/SCANIP信息RAC1的VIP:RAC1的VIP:7ScanIP:8附:关于以上rac的各种ip的详细介绍:3)共享磁盘设置5块2G磁盘,表决磁盘3块5G磁盘,存放数据文件附:虚拟机设置共享磁盘方式:一:安装linux1)linux安装时的选项•Base System > Base•Base System > Client management tools•Base System > Compatibility libraries•Base System > Hardware monitoring utilities•Base System > Large Systems Performance•Base System > Network file system client•Base System > Performance Tools•Base System > Perl Support•Servers > Server Platform•Servers > System administration tools•Desktops > Desktop•Desktops > Desktop Platform•Desktops > Fonts•Desktops > General Purpose Desktop•Desktops > Graphical Administration Tools•Desktops > Input Methods•Desktops > X Window System•Development > Additional Development•Development > Development Tools•Applications > Internet Browser2)linux需要安装的包需要添加以下的包,以确保Oracle的正常安装(暂时不添加也可以,在安装Oracle时会详细提示缺少哪个包的)rpm -Uvh binutils-2.*rpm -Uvh compat-libstdc++-33*rpm -Uvh elfutils-libelf-0.*rpm -Uvh elfutils-libelf-devel-*rpm -Uvh gcc-4.*rpm -Uvh gcc-c++-4.*rpm -Uvh glibc-2.*rpm -Uvh glibc-common-2.*rpm -Uvh glibc-devel-2.*rpm -Uvh glibc-headers-2.*rpm -Uvh pdksh-5*rpm -Uvh libaio-0.*rpm -Uvh libaio-devel-0.*rpm -Uvh libgcc-4.*rpm -Uvh libstdc++-4.*rpm -Uvh libstdc++-devel-4.*rpm -Uvh make-3.*rpm -Uvh sysstat-7.*rpm -Uvh unixODBC-2.*rpm -Uvh unixODBC-devel-2.*二:安装准备注:以下的安装准备都要需要在RAC1和RAC2两个服务器设置。
Oracle 11G R2 RAC实施过程图文版(本文仅限于11G R2 on redhatlinux 6.x系列)内容目录1 实施准备 (2)1.1 调研与方案制定 (2)1.2 存储划分方案(参考) (3)1.3 介质 (4)2 设置系统 (4)2.1 系统检查 (4)2.1.1 cpu信息 (4)2.1.1 确认内存大小 (5)2.1.2 检查文件系统 (5)2.1.3 检查网络设置 (6)2.2 设置操作系统 (7)2.2.1 主机正名 (7)2.2.2 配置本地主机名解析hosts文件 (7)2.2.3 修改内核参数 (7)2.2.4 关闭防火墙服务 (8)2.2.5 关闭selinux (8)2.2.6 配置时钟同步 (9)2.3 设置软件安装/运行用户 (9)2.3.1 创建用户 (9)2.3.2 设置初始密码 (10)2.3.3 设置用户进程资源配额 (10)2.4 设置存储 (10)2.4.1 多路径软件配置 (10)2.4.2 udev绑定参考 (11)3 安装软件 (12)3.1 准备安装介质 (12)3.1.1 准备目录和权限(所有节点) (12)3.1.2 上传zip包(推荐ftp方式) (12)3.1.3 使用grid用户解包 (13)3.2 安装集群软件 (13)3.2.1 运行安装程序runInstaller (13)3.2.2 设置grid用户环境变量 (37)3.2.3 验证资源和服务状态,确定成功安装 (37)3.2.4 验证缺省监听 (38)3.2.5 查看scan_listener (39)3.3 安装数据库软件 (39)3.3.1 运行交互式安装程序runInstaller (39)3.3.2 为oracle用户的添加软件环境变量 (47)4 创建数据库 (47)4.1 创建asm diskgroup (47)4.1.1 以grid用户运行asmca工具 (47)4.2 创建数据库zbwshx(在1节点操作) (49)5 应用累计补丁更新PSU (69)5.1 升级补丁工具opatch (69)5.2 补丁1节点软件 (69)5.3 补丁2节点软件 (71)5.4 升级数据库(1节点操作) (71)6 附加脚本(可选) (72)6.1 调整数据库一些缺省设置 (72)6.2 管理集群服务 (73)7 初始化业务环境(举例) (73)1 实施准备1.1 调研与方案制定1.2 存储划分方案(参考)存储要1T1T分配,超过2T会有问题1.3 介质2 设置系统2.1 系统检查2.1.1 cpu信息1 查看物理cpu数shell(root)>cat /proc/cpuinfo |grep physical\ id|sort|uniq2 查看单个cpu coresshell(root)>cat /proc/cpuinfo |grepcpu\ cores|uniq3 查看单个是否超线程shell(root)>cat /proc/cpuinfo |grepcpu\ cores|uniq4 合计cpu coresshell(root)>cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c shell(root)>mpstat 12.1.1 确认内存大小物理内存是256Gswap取值算法为物理内存的一倍,当物理内存超过64G,建议>=物理内存,这里32G符合最小2.1.2 检查文件系统/var和/tmp空间至少2G,建议10G/dev/shm共享空间设为物理内存/2 2.1.3 检查网络设置检查1节点public网卡设置检查2节点public网卡设置检查1节点private网卡地址(第一组)检查2节点private网卡设置(第一组)检查1节点 private网卡(第二组)检查2节点private网卡(第二组)2.2 设置操作系统2.1.1 主机正名1节点(全部小写最好了)2节点注意:重新登陆确认改变生效2.1.2 配置本地主机名解析hosts文件shell(root)>vi /etc/hosts#public address192.168.9.101 zbwshx01192.168.9.102 zbwshx02#public vip address192.168.9.103 zbwshx01-vip192.168.9.104 zbwshx02-vip192.168.9.105 zbwshx-cluster-scan(建议3个,用DNS解析)#private group #110.10.11.11 zbwshx01-priv110.10.11.12 zbwshx02-priv1#private group #210.10.12.11 zbwshx01-priv210.10.12.12 zbwshx02-priv2#NTP服务器192.168.5.11 ntpserver2.1.3 修改内核参数1.编辑sysctl.confshell(root)>vi /etc/sysctl.conf#ORACLE SETTINGfs.aio-max-nr = 1048576fs.file-max = 6815744#{shmall}单位pages,命令"echo $((物理内存/$(getconf PAGESIZE)))"(计算:物理内存/4096)kernel.shmall = 67108864#{shmmax},单位bytes,为物理内存一半,echo $((256*1024*1024*1024/2))kernel.shmmax = 137438953472(物理内存/2)kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586net.ipv4.ipfrag_high_thresh=524288net.ipv4.ipfrag_low_thresh=393216net.ipv4.tcp_rmem=4096 524288 16777216net.ipv4.tcp_wmem=4096 524288 16777216net.ipv4.tcp_timestamps=0net.ipv4.tcp_sack=0net.ipv4.tcp_window_scaling=1net.core.optmem_max=524287dev_max_backlog=2500sunrpc.tcp_slot_table_entries=128sunrpc.udp_slot_table_entries=128net.ipv4.tcp_mem=16384 16384 16384#多心跳网卡时需要多播技术net.ipv4.conf.default.rp_filter = 0#多播设备eth2,eth4net.ipv4.conf.eth2.rp_filter = 0net.ipv4.conf.eth4.rp_filter = 02.生效shell(root)>modprobesunrpcshell(root)>sysctl -p2.1.4 关闭防火墙服务shell(root)>chkconfig --level 2345 iptables offshell(root)>chkconfig --level 2345 ip6tables offshell(root)>service iptables stopshell(root)>service ip6tables stop2.1.5 关闭selinuxshell(root)>setenforce 0shell(root)>vi /etc/selinux/configSELINUX=disabled2.1.6 配置时钟同步∙配置NTP服务器<非数据库内容,略>∙配置ntp客户端shell(root)>vi /etc/ntp.conf注释掉其他restrict和server条目,增加如下serverntpserverrestrictntpserver mask 255.255.255.255nomodifynotrapnoquery ∙修改ntpd配置文件shell(root)>vi /etc/sysconfig/ntpdSYNC_HWCLOCK=yesOPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"∙重启ntpd进程shell(root)>chkconfig --level 2345 ntpd onshell(root)>service ntpd start∙确认握手成功shell(root)>ntpq -p(初次同步需要一定时间)∙检查状态shell(root)>ntpstat2.2 设置软件安装/运行用户2.2.1 创建用户shell(root)>groupadd -g 10501 oinstallshell(root)>groupadd -g 10502 asmadminshell(root)>groupadd -g 10503 asmdbashell(root)>groupadd -g 10504 asmopershell(root)>groupadd -g 10505 dbashell(root)>groupadd -g 10506 opershell(root)>useradd -m -u 10501 -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid -s /bin/bash -c "Grid Infrastructure Owner" gridshell(root)>useradd -m -u 10502 -g oinstall -G dba,oper,asmdba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle2.2.2 设置初始密码shell(root)>password gridshell(root)>password oracle2.2.3 设置用户进程资源配额shell(root)>vi /etc/security/limits.conf#ORACLE SETTINGroot soft nproc 2047root hard nproc 16384root soft nofile 1024root hard nofile 65536root soft stack 10240root hard stack 32768grid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid soft stack 10240grid hard stack 32768oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 327682.3 设置存储要求:✓同一个lun/vdisk在每个节点上设备名一致✓根据方案,通过scsi_id确认每一个lun/vdisk从存储上划分正确的✓共享模式要求在lun/vdisk在每个节点能同时读写✓RAC安装,lun/vdisk在操作系统上的设备名的属主是grid,组主是asmadmin,权限6602.3.1 多路径软件配置<非数据库内容,略>redhatlinux自带多路径软件multipath的参考文档官方文档:https:///documentation/zh-CN/Red_Hat_Enterprise_Linux/6/html/DM_Multipath/index.html百度搜索文档:/i6241962348353946114/绑定用户组案例:/2014/01/multipath实现设备用户组设置.html2.3.2 udev绑定参考注意:∙如果多路径软件已经实现了设备名绑定、属(组)主设置、权限设置,则不需要再配置udev∙udev不具有多路径failover能力∙本例为scsi磁盘∙∙1.shell(root)>fdisk -l|grep Disk\ /dev/sd根据系统人员告知,设备sda是本地操作系统宿主硬盘,不能使用,剩下的是共享磁盘2.查看scsi_idshell(root)>scsi_id -gvu /dev/sdN3.新建或编辑udev的rule文件shell(root)>vi /etc/udev/rules.d/99-oracle.rules(必须是99)KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk",ENV{ID_SERIAL}=="36006016010402600126dd2e653ebe511", NAME+="crs_01", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk",ENV{ID_SERIAL}=="360060160104026004eb5b3db53ebe511", NAME+="crs_02", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk",ENV{ID_SERIAL}=="360060160104026006edcb7d153ebe511", NAME+="crs_03", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk",ENV{ID_SERIAL}=="36006016010402600f0b413ee53ebe511", NAME+="fra_data_01", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk",ENV{ID_SERIAL}=="36006016010402600162f6d1254ebe511", NAME+="zbwshx_data_01", OWNER="grid", GROUP="asmadmin", MODE="0660"4.启动udevshell(root)>udevadm control reload-rulesshell(root)>start_udev3 安装软件3.1 准备安装介质(介质上传到/u01/media/oracle/linux_x64目录)3.1.1 准备目录和权限(所有节点)shell(root)>mkdir -p /u01/media/oracle/linux_x64shell(root)>chown -R grid:oinstall /u01shell(root)>chmod -R g+w /u013.1.2 上传zip包(推荐ftp方式)✓用grid用户上传✓上传grid安装包,database安装包,补丁包,补丁工具✓上传后介质属主grid,组主oinstall3.1.3 使用grid用户解包shell(grid)>cd /u01/media/oracle/linux_x64shell(grid)>unzip p1*******_112040_Linux-x86-64_1of7.zipshell(grid)>unzip p1*******_112040_Linux-x86-64_2of7.zipshell(grid)>unzip p1*******_112040_Linux-x86-64_3of7.zip3.2 安装集群软件3.2.1 运行安装程序runInstallershell(grid)>cd gridshell(grid)>./runInstaller提示:为了把x-windows程序的界面投射到windows终端上,需要执行2个步骤1.在windows上启动本地X11Forward程序,推荐x-manager中的xpassive(端口默认6000,注意firewall)2.在服务器上设定shell环境变量:export DISPLAY=YourIP:0.03.执行xclock测试在DHCP+DNS的环境,需要激活GNS,这里关闭本方案只有一个SCAN IP,使用/etc/hosts解析(也就是说需要将SCAN IP写入到/etc/hosts 下)建立主机之间ssh互信,这样可以免密码互相登陆,oracle安装过程中会把1节点的软件自动复制到2节点。
SUSE Linux Enterprise 11SP1静默安装Oracle 11gR2说明文档1准备oracle安装文件Oracle11gR2包含两个文件linux_11gR2_database_1of2.zip和linux_11gR2_database_2of2.zip,下载地址分别是:/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip下载完成后将这两个文件通过SSH上传到/usr/local/oracle中。
装程序的目录。
2准备oracle的安装目标目录安装目标目录是用户想将oracle安装到哪个位置的目录,本次我们将oracle安装到/opt/ora cle目录中,以下为目录创建命令。
3创建oracle相关用户和用户组oracle不能在root帐户下进行安装,所以需要为oracle的安装专门创建一个用户,同时需要创建dba和oinstall的用户组。
以下命令将创建dba和oinstall用户组:以下命令将创建oracle用户,并设置密码以下命令将oracle安装目录(/opt/oracle)赋予oracle用户oinstall用户组4检查安装ORACLE依赖的RPM软件包oracle的安装所依赖的软件包,有一部分linux是没有安装的。
这需要将这些尚未安装的软件包先安装后才能正常安装oracle。
这些未安装的软件包在linux安装光盘上可以取到,我们直接在linux的光盘上对这些软件包进行安装(也可将所需的软件包直接复制到linux本地磁盘中),首先我们需要挂载linux光盘,使用以下命令:安装所缺少的软件包,此处只安装本linux系统所缺少的软件包。
如oracle安装过程中,对软件包进行检查时,发现仍有所需软件包未安装时,可根据显示未安装软件包的名字,再次对所缺少的软件包进行安装。
安装文档11g R2R A C[A S M]f o r O E L6.4V1.02013年09月9日文档信息文档修订记录一环境准备31.1 操作系统41.2 解决虚拟机安装RAC的几个问题41.2.1 共享存储41.2.2 安装过程中总死机重启151.3修改/etc/hosts 文件(所有节点)151.4添加组和用户(所有节点)161.5建目录(所有节点)171.6修改系统参数(所有节点)181.7禁用防火墙和SELNUX(所有节点)221.8配置时间同步(所有节点)241.9检查安装包(所有节点)251.10配置用户环境变量(所有节点)261.10.1 Grid 用户261.10.2 Oracle用户281.11 配置用户等效性301.11.1 Grid用户:301.11.2 Oracle用户:341.12配置ASM391.12.1 安装ASM支持包(两个节点)391.12.2 配置ASM(两个节点)391.12.3 创建ASM磁盘401.13安装cvuqdisk包并验证(两个节点)411.14验证安装前的检查:41二安装CRS512.1 安装Grid infrastructure512.2 检查CRS状态622.2.1 资源组状态:622.2.2 检查集群节点:632.2.3 检查 Oracle 集群注册表 (OCR):632.2.4 检查表决磁盘:642.2.5 检查CRS状态642.3 为数据和快速恢复区创建 ASM 磁盘组:asmca65三安装Oracle 软件(不建库)65四创建数据库694.1安装数据库694.2查看数据库进程694.3连接数据库72一环境准备安装环境:本机32位VMware Workstation 。
操作系统Oracle Enterprise Linux Release 6 Update 4 for x86 (32 Bit)。
安装介质:IP分配:安装目录:1.1 操作系统本安装文档,操作系统为Oracle Enterprise Linux Release 6 Update 4 for x86 (32 Bit)。
Oracle 11g安装手册1、在linux的root用户下建立一个oracle用户//添加用户组及用户groupadd dbagroupadd oinstalluseradd oracle -g oinstall -G dbapasswd oracle//新建目录权限mkdir -p /u01chown -R oracle:dba /u01chmod -R 755 /u01安装时步骤8、9会指向此位置(建议:用户更改/opt/oracle11g)2、将Oracle11g安装文件复制到linux中的指定目录下(/home/oracle/tools)cp /光盘目录/linux.x64_11gR2_database_1of2 /home/oracle/tools3、执行目录中的runInstallsu - oracleLANG=zh_CN.gbk4、开始图像界面安装可能需要export DIAPLAY=:1.0xdpyinfo步骤1:将红框中的内容勾选去掉,点击下一步。
提示“未指定电子邮件地址”点击“是”步骤2:点选“创建和配置数据库”此选项也为默认选项,点击下一步。
步骤3:点击选中“服务器类”,点击“下一步”步骤4:点击选中“单实例数据库安装”,点击下一步。
步骤5:点击选中“高级安装”,点击“下一步”步骤6:选择需要的语言,点击“下一步”,此处客户确认是否需要增加其他语言步骤7:点击选中“企业版(4.29GB)”,点击“下一步”点击上图的“选择选项”,勾选需要的组件,此处全部勾选。
步骤8:此处为默认路径,u01的建立参考第1点orcale用户的建立,点击“下一步”步骤9:此处默认即可,点击“下一步”步骤10:点击选中“一般用途/事务处理”,点击“下一步”步骤11:此处默认,点击“下一步”vpmsdbs步骤12:此处可以设置内存、字符集、安全性、示例方案(可根据用户环境调整),点击“下一步”,内存分配建议至少50%步骤13:此处默认,点击“下一步”步骤14:此处默认处理,点击“下一步”步骤15:点击选中“不启用自动备份”,点击“下一步”步骤16:各帐号口令设定,此处统一使用相同口令,客户现场请在同客户确认口令设定规则步骤17:点击“下一步”步骤18:点击“修补并在此检查”,会产生修补文件,按照提示内容执行即可A、切换到root用户,此处为测试环境执行内容如上述步骤执行完成后依旧存在失败内容,请到linux光盘中寻找对应的rpm文件,复制到linux某一目录中,按下图命令执行步骤19:修补完成后,出现如下信息,点击“完成”步骤20:执行安装过程复制文件,创建实例过程完成后信息,点击“确定”完成后,如出现以下内容,请按照操作步骤,执行完成后,完成安装过程配置监听器1、执行su - oraclesh /u01/app/oracle/product/11.2.0/dbhome_1/bin/netca2、点击选中“监听程序配置”,点击“下一步”3、点击选中“添加”,点击“下一步”4、设定监听程序名,点击“下一步”5、选定协议所有协议,点击“下一步”6、设定标准端口号,点击“下一步”7、设定标准TCP/IP SSL端口号,点击“下一步”8、设置IPC键值,点击“下一步”9、提示是否配置另一个监听程序,点“是”,再点击“下一步”配置数据库1、执行sh /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca2、点击“下一步”3、点选“创建数据库”,点击“下一步”4、点选“一般用途或事物处理”,点击“下一步”5、设定数据库名及SID,点击“下一步”6、配置管理选项,此处暂时用7、设定口令,点击“下一步”8、网络配置,点击“下一步”9、数据库文件所在位置,点击“下一步”,按照实际的文件规划位置10、恢复配置,点击“下一步”11、数据库内容,点击“下一步”12、初始化参数,点击“下一步”13、数据库存储,点击“下一步”14、创建选项,点击“完成”15、概要显示,点击“确定”16、创建进行17、创建完成,点击“退出”环境变量设置及启动1、设置环境变量在服务器上配置环境变量,编辑vi /etc/profile,在末尾加入以下配置export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1export PATH=.:$ORACLE_HOME/bin:$PATHexport ORACLE_SID=VPMSDBS (数据库SID)保存并退出vi /etc/oratab最后的N 改成Y(否则dbstart和dbshut命令无效)lsnrctl start (启动oracle监听)提示:The listener supports no servicesThe command completed successfully这样启动后远程连接会造成oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor-----方案一-------------------------在listener.ora里面添加了一行SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = VENDB)(ORACLE_HOME = /opt/oracle11g/app/oracle/product/11.2.0/dbhome_1)(SID_NAME = VENDB)))-----方案二-------------------------linux上面:[oracle@localhost ~]$ netmgr在下图的Listeners->Database Services中配置要监听的SID及ORACLE_HOME,退出保存。
Linux环境安装oracle 11g数据库一.安装环境Linux服务器:Redhat 6.5 64位oracle服务器:oracle11g-64位二.系统配置Root用户下进行以下配置:1)修改用户的SHELL的限制,修改/etc/security/limits.conf文件输入命令:vi /etc/security/limits.conf,按i键进入编辑模式,将下列内容加入该文件oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536编辑完成后按Esc键,输入“:wq”存盘退出2)修改/etc/pam.d/login 文件,输入命令:vi /etc/pam.d/login,按i键进入编辑模式,将下列内容加入该文件。
session required /lib/security/pam_limits.sosession required pam_limits.so编辑完成后按Esc键,输入“:wq”存盘退出3)修改linux内核,修改/etc/sysctl.conf文件,输入命令: vi /etc/sysctl.conf ,按i键进入编辑模式,将下列内容加入该文件fs.file-max = 6815744 ##文件系统中最大文件个数fs.aio-max-nr = 1048576 ##文件系统最大异步IOkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096 ##最小共享内存 byteskernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500 ##端口范围net.core.rmem_default = 4194304 ## r—readnet.core.rmem_max = 4194304net.core.wmem_default = 262144 ##w--writenet.core.wmem_max = 1048576 //最大内存限制 kb编辑完成后按Esc键,输入“:wq”存盘退出4)要使 /etc/sysctl.conf 更改立即生效,执行以下命令。
Linux安装Oracle 11g服务器(图文)应该是最完整的Oracle安装教程了,全程在测试服务器上完成,软件环境:Red Hat Enterprise Linux 6;Oracle 11g (11.1.0.6)1. 从Oracle网站下载linux_11gR1_database_1013.zip,在终端输入unzip linux_11gR1_database_1013.zip进行解压,解压后得到的database文件夹即是Oracle的安装文件。
2. 修改/etc/hosts,添加IP地址和域名的映射关系:#格式如下<IP-address> <fully-qualified-machine-name> <machine-name>#比如127.0.0.1 localhost.localdomain localhost10.16.37.104 ol5-11gr1.localdomain ol5-11gr13. 修改/etc/sysctl.conf,在文件中增加以下内容:kernel.shmall = 2097152kernel.shmmax = 2147483648 # Smallest of -> (Half the size of the physical memory) or (4GB - 1 byte)kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128fs.file-max = 65536 # 512 * PROCESSESnet.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=4194304net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=2621444. 在终端运行/sbin/sysctl -p,使内核参数立即生效。
RedHat6.5安装Oracle11gR2教程2016年6月17日整理:SpotFish一、安装前准备1、复制RedHat6.5操作系统、Oracle 11g R2安装文件至服务器硬盘,以备后用(省得后面挂载光驱麻烦)命令:mkdir -p /Soft/ //创建软件存放目录命令:chmod -R 775 /Soft/ //设置文件目录权限属性让其它用户有读取和执行权限命令:mkdir /Soft/RHEL_6.5_x86_64 //创建RedHat_65目录命令:mount /dev/cdrom /mnt/ //挂载光驱命令:cp -rfv /mnt/* /Soft/ RHEL_6.5_x86_64 //将光盘所有文件复制至RHEL_6.5_x86_64目录命令:umount /mnt/ //卸载光驱命令:mkdir /soft/Oracle_11gR2_X86_64 //创建RedHat_65目录命令:mount /dev/cdrom /mnt/ 挂载光驱命令:cp -rfv /mnt/* /soft/ Oracle_11gR2_X86_64 将光盘所有文件复制至Oracle_11gR2_X86_64目录命令:umount /mnt/ //卸载光驱2、创建安装Oracle需要的系统组和用户命令:groupadd oinstall //创建Oracle Inventory 组命令:groupadd dba //创建OSDBA 组命令:useradd -g oinstall -G dba oracle //创建Oracle软件创建者-g 主组-G副组命令:passwd oracle //修改oracle用户的密码3、给oracle用户开通vnc权限(1)以oracle用户登录,运行vncserver命令开通vnc服务并设置密码命令:vncserver(2)修改vncserver的配置文件命令:vim /etc/sysconfig/vncservers多用户,可按如下设置(3)防火墙开放相应的VNC端口vi /etc/sysconfig/iptables //配置防火墙-A INPUT -m state --state NEW -m tcp -p tcp --dport 5902 -j ACCEPT //增加此规则到里面,vnc 端口号为5900+X(X为vnc时IP地址后面的数字)4、创建安装Oracle软件所需要的目录命令:mkdir -p /opt/oracle/ //创建安装目录命令:chown -R oracle:oinstall /opt/oracle/ //设置用户目录权限命令:chmod -R 775 /opt/oracle/ //设置文件目录属性命令:mkdir -p /Data/oradata/ //创建数据库文件存放目录命令:chown -R oracle:oinstall /Data/oradata //设置用户目录权限命令:chmod -R 775 /Data/oradata/ //设置文件目录属性5、配置安装Oracle安装用户(oracle)的环境命令:vim /home/oracle/.bash_profile //编辑/home/oracle/.bash_profile 在文件中添加下面内容umask 022export ORACLE_BASE=/opt/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=orcl //Oracle实例名,可修改export PATH=$PATH:HOME/bin:$ORACLE_HOME/bin命令:vim /etc/profile //编辑/etc/profile 在文件中添加下面内容if [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi6、检查机器名Hostname/etc/sysconfig/network中的hostname要与/etc/hosts中的一致[root@DBSrv ~]# vim /etc/hosts127.0.0.1 localhost XSWSSP-DB-Srv1::1 localhost XSWSSP-DB-Srv110.117.80.5 XSWSSP-DB-Srv17、开始安装Oracle软件(边安装边解决错误,便于学习)以oracle用户通过vnc登录服务器,运行安装命令。
2015-01-11 17:16 15359人阅读评论(0) 收藏举报分类:Oracle RAC(1)声明:本文为博主原创文章,未经博主允许不得。
环境如下:Linux操作系统:Centos 6.5 64bit (这个版本的redhat 6核等OS在安装grid最后执行root.sh时会出现crs-4124,是oracle11.2.0.1的bug)VMware version:Workstation 8.0.3 build-703057Oracle版本:11G R2 grid/oracle 64位11.2.0.1.0 for linux步骤规划:1,配置虚拟机、安装Linux操作系统2,配置OS3,配置ASM4,安装Oracle grid5,安装Oracle database6,创建ASM磁盘组7,建立数据库实例1,配置虚拟机、安装Linux操作系统1.1 新建虚拟机:RAC1和RAC2,并安装OS下载Centos的iso后新建虚拟机后安装即可,这里略。
注意存分配,每个虚拟机至少1.5G存比较好,我的机器8G存,给每个虚拟机分了2G,给每个虚拟机分配50GB硬盘容量,配置2个桥接网卡。
1.2 配置Share Disks新建共享硬盘,在DOS VM安装目录下执行:cd \D F:/Software/vm8/vmware-vdiskmanager.exe -c -s 1000Mb -a lsilogic -t 2 K:\VMDisk\Sharedisk\ocr.vmdk vmware-vdiskmanager.exe -c -s 1000Mb -a lsilogic -t 2 K:\VMDisk\Sharedisk\ocr2.vmdk vmware-vdiskmanager.exe -c -s 1000Mb -a lsilogic -t 2K:\VMDisk\Sharedisk\votingdisk.vmdkvmware-vdiskmanager.exe -c -s 20000Mb -a lsilogic -t 2 K:\VMDisk\Sharedisk\data.vmdkvmware-vdiskmanager.exe -c -s 10000Mb -a lsilogic -t 2K:\VMDisk\Sharedisk\backup.vmdk配置虚拟机RAC1 RAC2目录下的vmx虚拟机配置文件,在行最后添加如下:scsi1.present = "TRUE"scsi1.virtualDev = "lsilogic"scsi1.sharedBus = "virtual"scsi1:1.present = "TRUE"scsi1:1.mode = "independent-persistent"scsi1:1.filename = "K:\VMDisk\Sharedisk\ocr.vmdk"scsi1:1.deviceType = "plainDisk"scsi1:2.present = "TRUE"scsi1:2.mode = "independent-persistent"scsi1:2.filename = "K:\VMDisk\Sharedisk\votingdisk.vmdk"scsi1:2.deviceType = "plainDisk"scsi1:3.present = "TRUE"scsi1:3.mode = "independent-persistent"scsi1:3.filename = "K:\VMDisk\Sharedisk\data.vmdk"scsi1:3.deviceType = "plainDisk"scsi1:4.present = "TRUE"scsi1:4.mode = "independent-persistent"scsi1:4.filename = "K:\VMDisk\Sharedisk\backup.vmdk"scsi1:4.deviceType = "plainDisk"scsi1:5.present = "TRUE"scsi1:5.mode = "independent-persistent"scsi1:5.filename = "K:\VMDisk\Sharedisk\ocr2.vmdk"scsi1:5.deviceType = "plainDisk"disk.locking = "false"diskLib.dataCacheMaxSize = "0"diskLib.dataCacheMaxReadAheadSize = "0"diskLib.DataCacheMinReadAheadSize = "0"diskLib.dataCachePageSize = "4096"diskLib.maxUnsyncedWrites = "0"保存退出。
Oracle 11gR2 在linux(64bit)上的安装一,数据库安装前的配置(一)安装前的检查1.swap配置需求2.检查grep SwapTotal /proc/meminfofreedf -h /dev/shm/3.Disk空间要求要求/tmp大于1GBdf -h /tmp要求 /oracle需要20G要求/oradata 根据数据库数据量确定,但至少大于 20G4.操作系统要求Oracle Database 11g Release 2 (11.2)要求下列操作系统或者更新版本: (1)oracle LinuxOracle Linux 4 Update 7Oracle Linux 5 Update 2Oracle Linux 5 Update 5 (仅支持 Oracle Unbreakable Enterprise Kernel) (2)Redhat LinuxRed Hat Enterprise Linux 4 Update 7Red Hat Enterprise Linux 5 Update 2Red Hat Enterprise Linux 5 Update 5 (仅支持 Red Hat compatible kernel)(3)SUSE LinuxSUSE Linux Enterprise Server 10 SP2SUSE Linux Enterprise Server 115.内核版本要求:cat /proc/version or uname –a(1)对于 Oracle Linux 4 and Red Hat Enterprise Linux 4:2.6.9 或者以后版本(2)Oracle Linux 5 Update 2, and Red Hat Enterprise Linux 5 Update 2:2.6.18 或者以后版本(3)On Oracle Linux 5 Update 5 and Red Hat Enterprise Linux 5 Update 5:Unbreakable Enterprise Kernel based on the 2.6.32 stable kernelRed Hat compatible kernel for strict Red Hat compatibility(4)SUSE LinuxSUSE Linux Enterprise Server 10:2.6.16.21 或者以后版本SUSE Linux Enterprise Server 11:2.6.27.19 或者以后版本执行命令验证:uname -a(二)Oracle 11g所依赖软件包的检查和安装检查软件包:rpm -q package_name1.Oracle Linux 4 and Red Hat Enterprise Linux 4 应当安装以下软件包rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC unixODBC-devel numactl-develbinutils-2.15.92.0.2compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.97elfutils-libelf-devel-0.97expat-1.95.7gcc-3.4.6gcc-c++-3.4.6glibc-2.3.4-2.41glibc-2.3.4-2.41 (32 bit)glibc-common-2.3.4glibc-devel-2.3.4glibc-headers-2.3.4libaio-0.3.105libaio-0.3.105 (32 bit)libaio-devel-0.3.105libaio-devel-0.3.105 (32 bit)libgcc-3.4.6libgcc-3.4.6 (32-bit)libstdc++-3.4.6libstdc++-3.4.6 (32 bit)libstdc++-devel 3.4.6make-3.80numactl-0.6.4.x86_64pdksh-5.2.14sysstat-5.0.52. Oracle Linux 5, and Red Hat Enterprise Linux 5 应当安装以下软件包binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.125elfutils-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24 (32 bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5 (32 bit)glibc-headers-2.5ksh-20060214libaio-0.3.106libaio-0.3.106 (32 bit)libaio-devel-0.3.106libaio-devel-0.3.106 (32 bit)libgcc-4.1.2libgcc-4.1.2 (32 bit)libstdc++-4.1.2libstdc++-4.1.2 (32 bit)libstdc++-devel 4.1.2make-3.81numactl-devel-0.9.8.x86_64sysstat-7.0.23. SUSE Linux Enterprise Server 10 应当安装以下软件包binutils-2.16.91.0.5compat-libstdc++-5.0.7gcc-4.1.0gcc-c++-4.1.2glibc-2.4-31.63glibc-devel-2.4-31.63glibc-devel-32bit-2.4-31.63ksh-93r-12.9libaio-0.3.104libaio-32bit-0.3.104libaio-devel-0.3.104libaio-devel-32bit-0.3.104libelf-0.8.5libgcc-4.1.2libstdc++-4.1.2libstdc++-devel-4.1.2make-3.80numactl-0.9.6.x86_64sysstat-8.0.44. SUSE Linux Enterprise Server 11应当安装以下软件包binutils-2.19gcc-4.3gcc-32bit-4.3gcc-c++-4.3glibc-2.9glibc-32bit-2.9glibc-devel-2.9glibc-devel-32bit-2.9ksh-93tlibaio-0.3.104libaio-32bit-0.3.104libaio-devel-0.3.104libaio-devel-32bit-0.3.104libstdc++33-3.3.3libstdc++33-32bit-3.3.3libstdc++43-4.3.3_20081022libstdc++43-32bit-4.3.3_20081022libstdc++43-devel-4.3.3_20081022libstdc++43-devel-32bit-4.3.3_20081022libgcc43-4.3.3_20081022libstdc++-devel-4.3make-3.81sysstat-8.1.5(三)系统环境配置1.配置hosts文件确认hosts文件如下127.0.0.1 ora11g localhost.localdomain localhost 192.168.138.5 ora11g注:ora11g是hostname2.配置系统参数vi /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912 ###根据服务器实际情况设置kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586使用如下命令验证/sbin/sysctl -p/sbin/sysctl –a #系统下次启动时自动加载/etc/sysctl.conf在SUSE Linux上:/sbin/chkconfig boot.sysctl on #让suse启动时加载/etc/sysctl.confecho 501 > /proc/sys/vm/hugetlb_shm_group# /sbin/chkconfig boot.sysctl on3.配置limits文件/etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 102404. 配置oracle用户环境(1)用户和组/usr/sbin/groupadd oinstall/usr/sbin/groupadd gid=500 dbagroupadd –g 500 dba/usr/sbin/groupadd oper/usr/sbin/useradd –u 500 -g dba oracle注:Suse Linux中使用添加用户用下面命令useradd –g oinstall –G dba –m oracleid oracleuid=500(oracle) gid=500(dba) groups=500(dba)(2)数据库相关目录和权限mkdir -p /oraclechown -R oracle:dba /oracle数据库软件存放目录mkdir –p /pkg/oraclechown -R oracle:dba /pkg/oracle(3)配置oracle环境变量:su - oraclevi .bash_pfileexport ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0 export ORACLE_SID=xxxx #需根据实际设置export PATH=$ORACLE_HOME/bin:$PATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/libexport LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib二,数据库软件安装1.数据库软件上传至/pkg/oracleunzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_1of2.zip2.使用xmanager、VNC或者其他软件,连接到服务器oracle用户的图形化界面执行环境变量脚本进入安装目录,运行“runInstaller”启动安装界面中在弹出的界面中,按照如下图选择“I wish receive security updates via my oracle support”,然后下一步点击“Yes”进入下一步这里仅按照数据库软件,选择“Install database software only“,然后下一步:选择“Single Instance database installation”,默认即可,点击下一步继续:添加语言“Simplified Chinese”,然后选定“English”,然后点击下一步:选择oracle按照路径和位置,严格按照oracle环境变量配置,确认完成后,下一步:选择Inventory目录:/oracle/oraInventory和组,如图下一步在弹出的窗口中,点击yes确认操作系统的组用户:dba,如图,下一步进行预按照检查:确认检查结果,必须无任何失败项,然后下一步检查如果通过,下一步如下图,点击“Finish”进行安装安装过程中安装到最后弹出如下窗口,要求执行两个脚本另开一个窗口,使用ROOT用户登录后执行脚本强调:必须是在root用户下执行脚本[root@ora11g ~]# /oracle/oraInventory/orainstRoot.sh Changing permissions of /oracle/oraInventory. Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/oraInventory to dba. The execution of the script is complete.[root@ora11g ~]# /oracle/product/11.2/root.sh Running Oracle 11g root.sh script...The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /oracle/product/11.2Enter the full pathname of the local bin directory: [/usr/local/bin]:Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: yCopying oraenv to /usr/local/bin ...Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.回到图形界面,如下图,点击“OK“。
Install Oracle 11gR2 RAC on RedHat Linux AS5.4作者:何晓彬2012年2月QQ:429018MSN:unable_he@目录Install Oracle 11gR2 RAC on RedHat Linux AS 5.4 (1)一.主机系统配置及软件规划 (4)1.1 硬件 (4)1.2 软件规划 (4)二.安装操作系统 (5)2.1 操作系统安装步骤 (5)2.2RDAC 安装步骤 (5)三.安装ORACLE (6)3.1 创建用户组和用户 (6)3.2 创建目录 (7)3.3 修改hosts文件 (7)3.4 修改limits.conf 文件 (7)3.5 添加pam_limits.so 模块 (8)3.6 修改linux 内核参数 (8)3.7 修改profile (8)3.8 停ntp 时间同步(11G 新增检查选项) (9)3.9 查看tmpfs 大小是否大于1G (9)3.10 磁盘划分 (9)3.12 安装ASM (11)3.13 配置ASM (11)3.14 创建ASM (11)3.15 为用户等效性配置SSH (12)3.16 修改gird、oracle 用户的.bash_profile 文件 (14)3.17 校验能否安装grid (16)3.18 安装grid (36)3.19 安装Oracle 软件 (51)3.20 创建ASM 磁盘组 (63)3.21 创建数据库 (67)四.维护ORACLE RAC (79)4.1 查看RAC 运行状态 (79)4.2 启动oracle rac (80)4.3 关闭oracle rac (80)4.4 查看各资源状态 (80)4.5 启用各资源 (80)五.建立RAC的DataGuard (81)5.1 RAC +DataGuard组合 (81)5.2 Standby配置 (81)5.3 配置说明 (81)5.4 Standby数据库配置 (82)5.4.1 备库建立相关目录 (82)5.4.2配置主备库的监听 (82)5.5 在主库上创建密码文件和控制文件 (84)5.6 参数文件 (84)5.7 主库RMAN备份并传输到standby (86)5.8 启动备库到nomount状态 (87)5.9 RMAN还原备库 (87)5.10 检查Standby数据库 (87)5.11 添加standby redo log 日志 (88)5.12 检查主备库的日志同步情况 (89)一.主机系统配置及软件规划1.1 硬件1.2 软件规划二.安装操作系统2.1 操作系统安装步骤具体可以操作可以参考文件安装/chs/support/guide/redhat-as5-install-guide.pdf 注意安装软件选择定制要安装的软件包,选择全部安装安装完成后需要补安装oracle11g rac 必要的操作系统包rpm –ivh libaio-devel-0.3.106-5.i386.rpmrpm –ivh libaio-devel-0.3.106-5.x86_64.rpmrpm –ivh unixODBC-devel-2.2.11-7.1.i386.rpmrpm –ivh unixODBC-devel-2.2.11-7.1.x86_64.rpmrpm -ivh sysstat-7.0.22.2RDAC 安装步骤如果是双HBA 卡,还需要安装RDAC 多路径的软件rdac-LINUX-09.03.0C05.0504-source.tar.gztar zxvf rdac-LINUX-09.03.0C05.0439-source.tar.gzcd linuxrdac-09.03.0C05.0504/makemake installvi /etc/grub.conf修改default=1添加title Red Hat Enterprise Linux Server (2.6.18-164.el5)root (hd0,0)kernel /vmlinuz-2.6.18-164.el5 ro root=/dev/VolGroup00/LogVol00 rhgb quietinitrd /mpp-2.6.18-164.el5.img三.安装ORACLE3.1 创建用户组和用户注意(11G 需要多建一个用户grid 原来的CRS 软件安装在这个用户下)/usr/sbin/groupadd -g 501 oinstall/usr/sbin/groupadd -g 502 dba/usr/sbin/groupadd -g 503 oper/usr/sbin/groupadd -g 504 asmadmin/usr/sbin/groupadd -g 505 asmoper/usr/sbin/groupadd -g 506 asmdba/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid[root@HISDB1 ~]# /usr/sbin/groupadd -g 501 oinstall[root@HISDB1 ~]# /usr/sbin/groupadd -g 502 dba[root@HISDB1 ~]# /usr/sbin/groupadd -g 503 oper[root@HISDB1 ~]# /usr/sbin/groupadd -g 504 asmadmin[root@HISDB1 ~]# /usr/sbin/groupadd -g 505 asmoper[root@HISDB1 ~]# /usr/sbin/groupadd -g 506 asmdba[root@HISDB1 ~]# /usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle [root@HISDB1 ~]# /usr/sbin/useradd -g oinstall -Gasmadmin,asmdba,asmoper,oper,dba grid[root@HISDB1 ~]## id oracleuid=500(oracle) gid=501(oinstall)groups=501(oinstall),502(dba),503(oper),506(asmdba)[root@HISDB1 ~]# passwd oracleChanging password for user oracle.New UNIX password:BAD PASSWORD: it is based on a dictionary wordRetype new UNIX password:passwd: all authentication tokens updated successfully.[root@HISDB1 ~]# id griduid=501(grid) gid=501(oinstall)groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),50 6(asmdba)[root@HISDB1 ~]# passwd gridChanging password for user grid.New UNIX password:BAD PASSWORD: it is too shortRetype new UNIX password:passwd: all authentication tokens updated successfully.[root@HISDB1 ~]#3.2 创建目录mkdir -p /home/oraclemkdir -p /home/gridmkdir -p /oracle/product/11.2.0.3/dbmkdir -p /oracle/product/11.2.0.3/gridmkdir -p /oracle/app/oraclechown -R grid:oinstall /home/gridchown -R oracle:oinstall /home/oraclechown -R grid:oinstall /oracle/product/11.2.0.3/grid chown -R oracle:oinstall /oracle/app/oraclechown -R oracle:oinstall /oracle/product/11.2.0.3/db在两个节点上均执行这些操作。
3.3 修改hosts文件# Do not remove the following line, or various programs # that require network functionality will fail.127.0.0.1 localhost.localdomain localhost::1 localhost6.localdomain6 localhost6 192.168.0.11 HISDB1192.168.0.12 HISDB210.10.10.11 HISDB1-priv10.10.10.12 HISDB2-priv192.168.0.13 HISDB1-vip192.168.0.14 HISDB2-vip192.168.0.15 HISDB-SCAN192.168.0.16 HISDB-SCAN192.168.0.17 HISDB-SCAN192.168.0.41 HISDBDG3.4 修改limits.conf 文件vi /etc/security/limits.conforacle soft nproc 16384oracle hard nproc 16384oracle soft nofile 65536oracle hard nofile 65536grid soft nproc 16384grid hard nproc 16384grid soft nofile 65536grid hard nofile 655363.5 添加pam_limits.so 模块vi /etc/pam.d/login#ORACLE SETTINGsession required pam_limits.so3.6 修改linux 内核参数vi /etc/sysctl.conf#ORACLE SETTINGfs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 8388608kernel.shmmax = 536870912kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586#/sbin/sysctl –p3.7 修改profilevi /etc/profile#ORACLE SETTINGif [ $USER = "oracle" ] || [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fiumask 022fi3.8 停ntp 时间同步(11G 新增检查选项)/etc/init.d/ntpd stopchkconfig ntpd offmv /etc/ntp.conf /etc/rm /etc/ntp.conf3.9 查看tmpfs 大小是否大于1Gdf -h /dev/shmFilesystem Size Used Avail Use% Mounted ontmpfs 32G 15G 17G 48% /dev/shm3.10 磁盘划分+OCR_VOTE 1个1.5G 盘+DATA01 1个300G 盘+INDEX01 1个310G 盘+ARCH01 1个320G 盘[root@HISDB1 ~]# fdisk -lDisk /dev/sda: 896.9 GB, 896998047744 bytes255 heads, 63 sectors/track, 109053 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System/dev/sda1 * 1 13 104391 83 Linux/dev/sda2 14 8368 67111537+ 82 Linux swap / Solaris/dev/sda3 8369 109053 808752262+ 8e Linux LVMDisk /dev/sdb: 1073 MB, 1073741824 bytes34 heads, 61 sectors/track, 1011 cylindersUnits = cylinders of 2074 * 512 = 1061888 bytesDevice Boot Start End Blocks Id System /dev/sdb1 1 1011 1048376+ 83 LinuxDisk /dev/sdc: 1610 MB, 1610612736 bytes50 heads, 62 sectors/track, 1014 cylindersUnits = cylinders of 3100 * 512 = 1587200 bytesDevice Boot Start End Blocks Id System /dev/sdc1 1 1014 1571669 83 LinuxDisk /dev/sdd: 1610 MB, 1610612736 bytes50 heads, 62 sectors/track, 1014 cylindersUnits = cylinders of 3100 * 512 = 1587200 bytesDevice Boot Start End Blocks Id System /dev/sdd1 1 1014 1571669 83 LinuxDisk /dev/sde: 322.1 GB, 322122547200 bytes255 heads, 63 sectors/track, 39162 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System /dev/sde1 1 39162 314568733+ 83 LinuxDisk /dev/sdf: 332.8 GB, 332859965440 bytes255 heads, 63 sectors/track, 40467 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System /dev/sdf1 1 40467 325051146 83 LinuxDisk /dev/sdg: 343.5 GB, 343597383680 bytes255 heads, 63 sectors/track, 41773 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System /dev/sdg1 1 41773 335541591 83 LinuxDisk /dev/sdh: 1610 MB, 1610612736 bytes50 heads, 62 sectors/track, 1014 cylindersUnits = cylinders of 3100 * 512 = 1587200 bytesDevice Boot Start End Blocks Id System/dev/sdh1 1 1014 1571669 83 Linux3.12 安装ASMrpm -ivh oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm oracleasmlib-2.0.4-1.el5.x86_64.rpmoracleasm-support-2.1.7-1.el5.x86_64.rpm3.13 配置ASM/etc/init.d/oracleasm configure[root@HISDB1 oracle]# /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.Default user to own the driver interface []: gridDefault group to own the driver interface []: asmadminStart Oracle ASM library driver on boot (y/n) [n]: yScan for Oracle ASM disks on boot (y/n) [y]: yWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: [ OK ]Scanning the system for Oracle ASMLib disks: [ OK ]3.14 创建ASM/etc/init.d/oracleasm createdisk OCRVOTE01 /dev/sdc1/etc/init.d/oracleasm createdisk OCRVOTE02 /dev/sdd1/etc/init.d/oracleasm createdisk OCRVOTE03 /dev/sdh1/etc/init.d/oracleasm createdisk DATA01 /dev/sde1/etc/init.d/oracleasm createdisk INDEX01 /dev/sdf1/etc/init.d/oracleasm createdisk ARCH01 /dev/sdg1/etc/init.d/oracleasm scandisks[root@HISDB1 oracle]# /etc/init.d/oracleasm scandisksScanning the system for Oracle ASMLib disks: [ OK ]/etc/init.d/oracleasm listdisks[root@HISDB1 oracle]# /etc/init.d/oracleasm listdisksARCH01DATA01INDEX01OCRVOTE01OCRVOTE02OCRVOTE033.15 为用户等效性配置SSH两个节点su - oraclemkdir ~/.sshchmod 755 ~/.sshssh-keygen -t rsassh-keygen -t dsa在一个节点1 上cat ~/.ssh/id_rsa.pub >> ./.ssh/authorized_keyscat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys在传到另一个节点ssh HISDB2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys ssh HISDB2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys scp ~/.ssh/authorized_keys HISDB2:~/.ssh/authorized_keys 在一个节点2 上cat ~/.ssh/id_rsa.pub >> ./.ssh/authorized_keyscat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys在传到另一个节点ssh HISDB1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys ssh HISDB1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys scp ~/.ssh/authorized_keys HISDB1:~/.ssh/authorized_keys 验证等效性exec /usr/bin/ssh-agent $SHELL/usr/bin/ssh-addssh HISDB1 datessh HISDB2 datessh HISDB1-priv datessh HISDB2-priv date[root@HISDB1 ~]# su - oracle[oracle@HISDB1 ~]$ mkdir ~/.ssh[oracle@HISDB1 ~]$ chmod 755 ~/.ssh[oracle@HISDB1 ~]$ ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/home/oracle/.ssh/id_rsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/oracle/.ssh/id_rsa.Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.The key fingerprint is:c1:bb:a9:28:7c:ec:98:17:93:00:f7:89:5c:f9:c5:0c oracle@HISDB1 [oracle@HISDB1 ~]$ ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/oracle/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/oracle/.ssh/id_dsa.Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.The key fingerprint is:5d:42:b0:d0:f4:0e:26:73:a6:b5:81:5c:e7:76:64:cb oracle@HISDB1 [oracle@HISDB1 ~]$ cat ~/.ssh/id_rsa.pub >> ./.ssh/authorized_keys [oracle@HISDB1 ~]$ cat ~/.ssh/id_dsa.pub >> ./.ssh/authorized_keys [oracle@HISDB1 ~]$ ssh HISDB2 cat ~/.ssh/id_rsa.pub >>~/.ssh/authorized_keysThe authenticity of host 'HISDB2 (192.168.0.12)' can't be established. RSA key fingerprint is 78:b1:fc:a7:a2:58:0f:ef:14:75:b2:f9:3f:ad:4f:e5. Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'HISDB2,192.168.0.12' (RSA) to the list of known hosts.oracle@HISDB2's password:[oracle@HISDB1 ~]$ ssh HISDB2 cat ~/.ssh/id_dsa.pub >>~/.ssh/authorized_keysoracle@HISDB2's password:[oracle@HISDB1 ~]$ scp ~/.ssh/authorized_keysHISDB2:~/.ssh/authorized_keysoracle@HISDB2's password:authorized_keys100% 2004 2.0KB/s00:00[oracle@HISDB1 ~]$ ssh HISDB2 dateThu Dec 30 17:18:20 CST 2011[oracle@HISDB1 ~]$ ssh HISDB1 dateThe authenticity of host 'HISDB1 (127.0.0.1)' can't be established. RSA key fingerprint is 16:83:72:3b:f0:fe:ca:73:26:f0:3b:6c:a5:47:43:ce. Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'HISDB1' (RSA) to the list of known hosts.Thu Dec 30 17:18:45 CST 2011[oracle@HISDB1 ~]$ ssh HISDB1 dateThu Dec 30 17:18:49 CST 2011[oracle@HISDB1 ~]$ ssh HISDB1-priv dateThu Dec 30 17:19:36 CST 2011[oracle@HISDB1 ~]$ ssh HISDB2-priv dateThe authenticity of host 'HISDB2-priv (10.10.10.12)' can't be established.RSA key fingerprint is 78:b1:fc:a7:a2:58:0f:ef:14:75:b2:f9:3f:ad:4f:e5. Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'HISDB2-priv,10.10.10.12' (RSA) to the list of knownhosts.Thu Dec 30 17:19:28 CST 2011[oracle@HISDB1 ~]$ ssh HISDB2-priv dateThu Dec 30 17:19:31 CST 2011[oracle@HISDB1 ~]$grid 用户同oracle 用户一样设置3.16 修改gird、oracle 用户的.bash_profile 文件su – gridvi ~/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHTMP=/tmp;export TMPTMPDIR=$TMP; export TMPDIRORACLE_SID=+ASM1; export ORACLE_SIDORACLE_BASE=/oracle/app/oracle; export ORACLE_BASEORACLE_HOME=/oracle/product/11.2.0.3/grid; export ORACLE_HOME GRID_HOME=/oracle/product/11.2.0.3/grid; export GRID_HOME NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS";export NLS_DATE_FORMAT THREADS_FLAG=native;export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH;export PATH THREADS_FLAG=native;export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH;export PATH#if [ $USER = "oracle" ] || [ $USER = "grid" ]; then# if [ $SHELL = "/bin/ksh" ];# then# ulimit -p 16384# ulimit -n 65536# else# ulimit -u 16384 -n 65536# fi# umask 022#fisu – oraclevi ~/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_BASE=/home/oracleexport ORACLE_HOME=/oracle/product/11.2.0.3/dbexport ORA_CRS_HOME=/oracle/product/11.2.0.3/gridORACLE_SID=BJCHORA1export ORACLE_BASE ORACLE_HOME ORACLE_SIDexport PATH=$PATH:$ORACLE_HOME/binexport JAVA_HOME=$ORACLE_HOME/jdk/binexport CLASSPATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBK#export NLS_LANG=="Simplified Chinese_china".ZHS16GBKexport TNS_ADMIN=$ORACLE_HOME/network/adminexport ORA_NLS10=$ORACLE_HOME/nls/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib export CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmp3.17 校验能否安装grid./runcluvfy.sh stage -pre crsinst -n HISDB1,HISDB2 -fixup –verbosePerforming pre-checks for cluster services setupChecking node reachability...Check: Node reachability from node "HISDB1"Destination Node Reachable?------------------------------------ ------------------------HISDB2 yesHISDB1 yes Result: Node reachability check passed from node "HISDB1"Checking user equivalence...Check: User equivalence for user "oracle"Node Name Comment------------------------------------ ------------------------HISDB2 passedHISDB1 passedResult: User equivalence check passed for user "oracle"Checking node connectivity...Checking hosts config file...Node Name Status Comment------------ ------------------------ ------------------------HISDB2 passedHISDB1 passed Verification of the hosts config file successfulInterface information for node "HISDB2"Name IP Address Subnet Gateway Def. Gateway HW Address MTU------ --------------- --------------- --------------- -------------------------------- ------usb0 169.254.95.120 169.254.95.0 0.0.0.0 192.168.0.1 5E:F3:FD:35:6E:3B 1500eth0 10.10.10.12 10.10.10.0 0.0.0.0 192.168.0.1 5C:F3:FC:DA:6E:88 1500eth2 192.168.0.12 192.168.0.0 0.0.0.0 192.168.0.1 00:10:18:A5:B1:AC 1500eth2 192.168.0.14 192.168.0.0 0.0.0.0 192.168.0.1 00:10:18:A5:B1:AC 1500Interface information for node "HISDB1"Name IP Address Subnet Gateway Def. Gateway HW Address MTU------ --------------- --------------- --------------- -------------------------------- ------eth0 10.10.10.11 10.10.10.0 0.0.0.0 192.168.0.1 5C:F3:FC:DA:AC:98 1500eth2 192.168.0.11 192.168.0.0 0.0.0.0 192.168.0.1 00:10:18:B7:EB:38 1500eth2 192.168.0.13 192.168.0.0 0.0.0.0 192.168.0.1 00:10:18:B7:EB:38 1500eth2 192.168.0.15 192.168.0.0 0.0.0.0 192.168.0.1 00:10:18:B7:EB:38 1500usb0 169.254.95.120 169.254.95.0 0.0.0.0 192.168.0.15E:F3:FD:35:AC:4B 1500Check: Node connectivity of subnet "169.254.95.0"Source Destination Connected?------------------------------ ----------------------------------------------HISDB2:usb0 HISDB1:usb0 yes Result: Node connectivity passed for subnet "169.254.95.0" with node(s)HISDB2,HISDB1Check: TCP connectivity of subnet "169.254.95.0"Result: TCP connectivity check failed for subnet "169.254.95.0"Check: Node connectivity of subnet "10.10.10.0"Source Destination Connected?------------------------------ ----------------------------------------------HISDB2:eth0 HISDB1:eth0 yes Result: Node connectivity passed for subnet "10.10.10.0" with node(s)HISDB2,HISDB1Check: TCP connectivity of subnet "10.10.10.0"Source Destination Connected?------------------------------ ----------------------------------------------HISDB1:10.10.10.11 HISDB2:10.10.10.12 passedResult: TCP connectivity check passed for subnet "10.10.10.0"Check: Node connectivity of subnet "192.168.0.0"Source Destination Connected?------------------------------ ----------------------------------------------HISDB2:eth2 HISDB2:eth2 yes HISDB2:eth2 HISDB1:eth2 yesHISDB2:eth2 HISDB1:eth2 yes HISDB2:eth2 HISDB1:eth2 yes HISDB2:eth2 HISDB1:eth2 yes HISDB2:eth2 HISDB1:eth2 yes HISDB2:eth2 HISDB1:eth2 yes HISDB1:eth2 HISDB1:eth2 yes HISDB1:eth2 HISDB1:eth2 yes HISDB1:eth2 HISDB1:eth2 yes Result: Node connectivity passed for subnet "192.168.0.0" with node(s)HISDB2,HISDB1Check: TCP connectivity of subnet "192.168.0.0"Source Destination Connected?------------------------------ ----------------------------------------------HISDB1:192.168.0.11 HISDB2:192.168.0.12 passedHISDB1:192.168.0.11 HISDB2:192.168.0.14 passedHISDB1:192.168.0.11 HISDB1:192.168.0.13 passedHISDB1:192.168.0.11 HISDB1:192.168.0.15 passedResult: TCP connectivity check passed for subnet "192.168.0.0"Interfaces found on subnet "169.254.95.0" that are likely candidates forVIP are:HISDB2 usb0:169.254.95.120HISDB1 usb0:169.254.95.120Interfaces found on subnet "192.168.0.0" that are likely candidates forVIP are:HISDB2 eth2:192.168.0.12 eth2:192.168.0.14HISDB1 eth2:192.168.0.11 eth2:192.168.0.13 eth2:192.168.0.15Interfaces found on subnet "10.10.10.0" that are likely candidates fora private interconnect are:HISDB2 eth0:10.10.10.12HISDB1 eth0:10.10.10.11Result: Node connectivity check passedCheck: Total memoryNode Name Available Required Comment------------ ------------------------ ----------------------------------HISDB2 62.91GB (6.596802E7KB) 1.5GB (1572864.0KB)passedHISDB1 62.91GB (6.596802E7KB) 1.5GB (1572864.0KB)passedResult: Total memory check passedCheck: Available memoryNode Name Available Required Comment------------ ------------------------ ----------------------------------HISDB2 58.73GB (6.158702E7KB) 50MB (51200.0KB) passedHISDB1 56.62GB (5.936586E7KB) 50MB (51200.0KB) passedResult: Available memory check passedCheck: Swap spaceNode Name Available Required Comment------------ ------------------------ ----------------------------------HISDB2 64GB (6.7111528E7KB) 16GB (1.6777216E7KB)passedHISDB1 64GB (6.7111528E7KB) 16GB (1.6777216E7KB)passedResult: Swap space check passedCheck: Free disk space for "HISDB2:/tmp"Path Node Name Mount point Available RequiredComment---------------- ------------ ------------ ------------------------ ------------/tmp HISDB2 / 88.45GB 1GB passedResult: Free disk space check passed for "HISDB2:/tmp"Check: Free disk space for "HISDB1:/tmp"Path Node Name Mount point Available Required Comment---------------- ------------ ------------ ------------------------ ------------/tmp HISDB1 / 75.74GB 1GB passedResult: Free disk space check passed for "HISDB1:/tmp"Check: User existence for "oracle"Node Name Status Comment------------ ------------------------ ------------------------HISDB2 exists passedHISDB1 exists passedResult: User existence check passed for "oracle"Check: Group existence for "oinstall"Node Name Status Comment------------ ------------------------ ------------------------HISDB2 exists passedHISDB1 exists passedResult: Group existence check passed for "oinstall"Check: Group existence for "dba"Node Name Status Comment------------ ------------------------ ------------------------HISDB2 exists passedHISDB1 exists passedResult: Group existence check passed for "dba"Check: Membership of user "oracle" in group "oinstall" [as Primary]Node Name User Exists Group Exists User in Group Primary Comment---------------- ------------ ------------ ------------------------ ------------HISDB2 yes yes yes yes passedHISDB1 yes yes yes yes passedResult: Membership check for user "oracle" in group "oinstall" [as Primary]passedCheck: Membership of user "oracle" in group "dba"Node Name User Exists Group Exists User in Group Comment---------------- ------------ ------------ ----------------------------HISDB2 yes yes yes passedHISDB1 yes yes yes passed Result: Membership check for user "oracle" in group "dba" passedCheck: Run levelNode Name run level Required Comment------------ ------------------------ ----------------------------------HISDB2 5 3,5 passedHISDB1 5 3,5 passedResult: Run level check passedCheck: Hard limits for "maximum open file descriptors"Node Name Type Available Required Comment---------------- ------------ ------------ ----------------------------HISDB2 hard 65536 65536 passedHISDB1 hard 65536 65536 passed Result: Hard limits check passed for "maximum open file descriptors"Check: Soft limits for "maximum open file descriptors"Node Name Type Available Required Comment---------------- ------------ ------------ ----------------------------HISDB2 soft 65536 1024 passedHISDB1 soft 65536 1024 passed Result: Soft limits check passed for "maximum open file descriptors"Check: Hard limits for "maximum user processes"Node Name Type Available Required Comment---------------- ------------ ------------ ----------------------------HISDB2 hard 16384 16384 passedHISDB1 hard 16384 16384 passed Result: Hard limits check passed for "maximum user processes"Check: Soft limits for "maximum user processes"Node Name Type Available Required Comment---------------- ------------ ------------ ----------------------------HISDB2 soft 16384 2047 passedHISDB1 soft 16384 2047 passed Result: Soft limits check passed for "maximum user processes"Check: System architectureNode Name Available Required Comment------------ ------------------------ ----------------------------------HISDB2 x86_64 x86_64 passedHISDB1 x86_64 x86_64 passedResult: System architecture check passedCheck: Kernel versionNode Name Available Required Comment------------ ------------------------ ----------------------------------HISDB2 2.6.18-164.el5 2.6.18 passedHISDB1 2.6.18-164.el5 2.6.18 passedResult: Kernel version check passedCheck: Kernel parameter for "semmsl"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 250 250 passedHISDB1 250 250 passedResult: Kernel parameter check passed for "semmsl"Check: Kernel parameter for "semmns"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 32000 32000HISDB1 32000 32000 passedResult: Kernel parameter check passed for "semmns"Check: Kernel parameter for "semopm"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 100 100 passedHISDB1 100 100 passedResult: Kernel parameter check passed for "semopm"Check: Kernel parameter for "semmni"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 128 128 passedHISDB1 128 128 passedResult: Kernel parameter check passed for "semmni"Check: Kernel parameter for "shmmax"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 68719476736 536870912 passedHISDB1 68719476736 536870912 passedResult: Kernel parameter check passed for "shmmax"Check: Kernel parameter for "shmmni"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 4096 4096HISDB1 4096 4096 passedResult: Kernel parameter check passed for "shmmni"Check: Kernel parameter for "shmall"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 4294967296 2097152 passedHISDB1 4294967296 2097152 passedResult: Kernel parameter check passed for "shmall"Check: Kernel parameter for "file-max"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 6815744 6815744 passedHISDB1 6815744 6815744 passedResult: Kernel parameter check passed for "file-max"Check: Kernel parameter for "ip_local_port_range"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 between 9000 & 65500 between 9000 & 65500passedHISDB1 between 9000 & 65500 between 9000 & 65500passedResult: Kernel parameter check passed for "ip_local_port_range"Check: Kernel parameter for "rmem_default"Node Name Configured Required Comment------------ ------------------------ ----------------------------------HISDB2 4194304 262144。