Oracle_11gR2_RAC_安装报告

Oracle11gR2RAC数据库安装报告-2-文档控制修改记录日期作者版本修改记录审阅记录审阅人职位分发记录审阅人职位-3-1.概述52.系统环境62.1.硬件环境检查82.2.网络环境检查92.3.AIX系统环境优化102.4.软件环境检查153.安装前的准备173.1主机hosts配置173.2创建用户和组173.3ASM共享存储配置183.4配置SSH213.5配置NTP（可选）213.6配置用户环境变量224.安装GridInfrastructure244.1解压安装介质244.2Cluvfy检查244.3运行rootpre.sh244.4安装过程244.5安装后检查集群状态535.安装Database565.1安装前检查565.2安装过程565.3安装后检查（可选）645.4应用数据库补丁集（可选）646.创建数据库656.1创建ASM磁盘组656.2建库前检查676.3DBCA建库756.4建库后检查88-4-7.安装后配置907.1备份SPFILE907.2修改为归档模式908.日常维护命令91-5-1.概述本报告的目的是为了给出Oracle11gR2RAC数据库产品的安装示例。便于对数据库进行后期的维护管理。本次安装所涉及的系统平台为OS：AIX6.1,ORACLE数据库为11gR2RAC数据库。-6-2.系统环境硬件：IBMP630的2个LPAR，Fast900存储一套；软件：Oracle11gR2GridforAIX和Oracle11gR2DatabaseforAIX，介质列表如下：p10098816_112020_AIX64-5L_1of7.zipp10098816_112020_AIX64-5L_2of7.zipp10098816_112020_AIX64-5L_3of7.zipp10098816_112020_AIX64-5L_4of7.zipp10098816_112020_AIX64-5L_5of7.zipp10098816_112020_AIX64-5L_6of7.zipp10098816_112020_AIX64-5L_7of7.zip安装规划：-7-主机节点节点名称实例名称数据库名称处理器RAM操作系统G2DBAorcl1orcl2CPU4GBAIX6.1TL-0464bitG2DBBorcl22CPU4GBAIX6.1TL-0464bit网络配置节点名称公共IP地址专用IP地址虚拟IP地址SCAN名称SCANIP地址G2DBA11.245.2.15192.168.2.1511.245.2.16G2DB-SCANG2DBB11.245.2.17192.168.2.1711.245.2.18Oracle软件组件软件组件操作系统用户主组辅助组主目录Oracle基目录/Oracle主目录GridInfragridoinstalldba/home/oracle/grid/home/oracle/grid/home/oracle/11.2.0/gridOracleRACoracleoinstalldba/home/oracle/db/home/oracle/db/home/oracle/db/product/11.2.0/db_1存储组件存储组件文件系统容量ASM卷组名ASM冗余设备名OCR/VotingDiskASM2GcrsdgExternal/dev/rhdisk7~8数据ASM3.5TdatadgExternal/dev/rhdisk2~6/dev/rhdisk9~10未使用ASM1.5T/dev/rhdisk11~13-8-2.1.硬件环境检查1.磁盘空间RAC安装最少需要19.5G的本地磁盘空间：OracleEnterpriseEdition:7.44GBOracleDatabaseDataFiles:1.55GB/tmp空间，本环境基础配置256MB，应该变更为1GB以上：基础设置：#df-k/tmpFilesystem1024-blocksFree%UsedIused%IusedMountedon/dev/hd32621442582522%601%/tmp变更后设置：#df-k/tmpFilesystem1024-blocksFree%UsedIused%IusedMountedon/dev/hd3209715220957001%551%/tmp2.内存安装最低要求有4GB内存，本次安装环境内存为4GB#/usr/sbin/lsattr-E-lsys0-arealmemrealmem3932160AmountofusablephysicalmemoryinKbytesFalseRAMSwap空间4GB~8GB2倍RAM大小8GB~32GB1.5倍RAM大小=32GB32GB检查SWAP空间:对照上表，SWAP应该设置为内存的2倍。本环境基础配置512MB，应该变更为8GB。基础配置：#/usr/sbin/lsps-aPageSpacePhysicalVolumeVolumeGroupSize%UsedActiveAutoTypeChksumhd6hdisk6rootvg512MB2yesyeslv0变更后配置：#/usr/sbin/lsps-aPageSpacePhysicalVolumeVolumeGroupSize%UsedActiveAutoTypeChksumhd6hdisk6rootvg8192MB1yesyeslv0-9-2.2.网络环境检查1.每个节点上最少有2块网卡2.检查每个节点上IP的配置：#ifconfig-a节点1：en0:flags=5e080863,c0UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAINinet11.245.2.15netmask0xffffff00broadcast11.245.2.255en1:flags=5e080863,c0UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAINinet192.168.2.15netmask0xffffff00broadcast192.168.2.255lo0:flags=e08084b,c0UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAINinet127.0.0.1netmask0xff000000broadcast127.255.255.255inet6::1%1/0tcp_sendspace131072tcp_recvspace131072rfc13231节点2：en0:flags=5e080863,c0UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAINinet11.245.2.17netmask0xffffff00broadcast11.245.2.255en1:flags=5e080863,c0UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAINinet192.168.2.17netmask0xffffff00broadcast192.168.2.255lo0:flags=e08084b,c0UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAINinet127.0.0.1netmask0xff000000broadcast127.255.255.255inet6::1%1/0tcp_sendspace131072tcp_recvspace131072rfc132313.当前系统没有防火墙4.TCP和UDP的端口范围9000-65500#/usr/sbin/no-a|fgrepephemeraltcp_ephemeral_high=65500tcp_ephemeral_low=9000-10-udp_ephemeral_high=65500udp_ephemeral_low=90002.3.AIX系统环境优化1.调整异步IO进程数检查当前值：#ioo-oaio_maxreqsaio_maxreqs=65536如果小于65536，则：#smittyaiochange/showcharacteristicsofasynchronousI/OStatetobeconfiguredatsystemrestartDefined---availablesettingioo-oaio_maxreqs=65536调整参数ioo-poaio_maxservers=80/ioo-poaio_minservers=402.优化虚拟内存管理建议值：ParameterValueminperm%3(defaultis20)maxperm%90(defaultis80)maxclient%90(defaultis80)lru_file_repage0(defaultis1)strict_maxclient1(defaultis1)strict_maxperm0(defaultis0)本系统检查结果符合建议值：#vmo-Lminperm%NAMECURDEFBOOTMINMAXUNITTYPEDEPENDENCIES--------------------------------------------------------------------------------minperm%3331100%memoryD-11---------------------------------------------------------------------------------#vmo-Lmaxperm%NAMECURDEFBOOTMINMAXUNITTYPEDEPENDENCIES--------------------------------------------------------------------------------maxperm%9090901100%memoryDminperm%maxclient%--------------------------------------------------------------------------------#vmo-Lmaxclient%NAMECURDEFBOOTMINMAXUNITTYPEDEPENDENCIES--------------------------------------------------------------------------------maxclient%9090901100%memoryDmaxperm%minperm%--------------------------------------------------------------------------------#vmo-Llru_file_repageNAMECURDEFBOOTMINMAXUNITTYPEDEPENDENCIES-------------------------------------------------------