oracle11gr2添加节点最佳实践

百度文库-让每个人平等地提升自我oracle 11gr2添加节点最佳实践OS信息:2DB信息：2（一）设置网络3（二）添加组、目录和用户 3（三）修改相关OS参数3（四）修改用户环境变量 3（五）设置存储3（六）配置节点互信 3（七）安装RPM包3（八）安装GI前检测3（九）扩展新节点到集群中（期间传文件可能会花段时间） 14（十）按说明执行脚本 18（十一）检查扩展结果 20（十二）扩展oracle数据库（期间传文件可能会花段时间） 27（十三）按提示执行脚本 31（十四）创建数据库实例 32（十五）验证3235OS信息:grid11grac1 $ uname -aLinux llgracl 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST2012 i686 i686 i386 GNU/LinuxDB信息:SQL select * from v$version where rownum5;BANNEROracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0 - Production（一）设置网络（二）添加组、目录和用户（三）修改相关OS参数（四）修改用户环境变量（五）设置存储（六）配置节点互信（七）安装RPM包注：1-7步略（其中的修改需要参照其他节点的配置 ）（八）安装GI前检测grid11grac1 bin$ pwd/u01/11.2.0/grid/bingrid11grac1 bin$ ./cluvfy stage -pre nodeadd -n 11grac2 -fixup -verbosePerforming pre-checks for node additionChecking node reachability.Check: Node reachability from node 11grac1Destination NodeReachable?11grac2yesResult: Node reachability check passed from node 11grac1Checking user equivalence.Check: User equivalence for user gridNode NameComment11grac2passedResult: User equivalence check passed for user gridChecking node connectivity.Checking hosts config file.Node Name StatusComment11grac2passed11grac1passedVerification of the hosts config file successfulInterface information for node 11grac1Name IP Address SubnetGatewayDef. Gateway HWAddressMTUeth0192.168.137.161192.168.137.00.0.0.0192.168.137.100:0C:29:31:BE:BA 1500eth0192.168.137.163192.168.137.00.0.0.0192.168.137.100:0C:29:31:BE:BA 1500eth0192.168.137.200192.168.137.00.0.0.0192.168.137.100:0C:29:31:BE:BA 1500eth1192.168.136.161192.168.136.00.0.0.0192.168.137.100:0C:29:31:BE:C4 1500Interface information for node 11grac2Name IP AddressSubnetGatewayDef. GatewayHWAddressMTUeth0192.168.137.162192.168.137.00.0.0.0192.168.137.100:0C:29:D6:B6:09 1500eth1192.168.136.162192.168.136.00.0.0.0192.168.137.100:0C:29:D6:B6:13 1500Check: Node connectivity for interface eth0SourceDestinationConnected?11grac1:eth011grac1:eth0yes11grac1:eth011grac1:eth0yes11grac1:eth011grac2:eth0yes11grac1:eth011grac1:eth0yes11grac1:eth011grac2:eth0yes11grac1:eth011grac2:eth0yesResult: Node connectivity passed for interface eth0Result: Node connectivity check passedChecking CRS integrity.The Oracle clusterware is healthy on node 11grac1CRS integrity check passedChecking shared resources.Checking CRS home location.The location /u01 /11.2.0/grid is not shared but is present/creatable on all nodesResult: Shared resources check for node addition passedChecking node connectivity.Checking hosts config file.CommentNode Name Status11grac2passed11grac1passedVerification of the hosts config file successfulInterface information for node 11grac1Name IP Address SubnetAddressMTUGatewayDef. GatewayHWeth000:0C:29:31:BE:BA 1500eth000:0C:29:31:BE:BA 1500eth000:0C:29:31:BE:BA 1500eth1192.168.137.00.0.0.0192.168.137.1192.168.137.00.0.0.0192.168.137.1192.168.137.00.0.0.0192.168.137.1192.168.136.00.0.0.0192.168.137.1192.168.137.161192.168.137.163192.168.137.200192.168.136.16100:0C:29:31:BE:C4 1500Interface information for node 11grac2Name IP AddressSubnetGatewayDef. GatewayHWeth0192.168.137.162192.168.137.00.0.0.0192.168.137.100:0C:29:D6:B6:09 1500eth1192.168.136.162192.168.136.00.0.0.0192.168.137.100:0C:29:D6:B6:13 1500Check: Node connectivity of subnet 192.168.137.0SourceDestinationConnected?11grac1:eth011grac1:eth0yes11grac1:eth011grac1:eth0yes11grac1:eth011grac2:eth0yes11grac1:eth011grac1:eth0yes11grac1:eth011grac2:eth0yes11grac1:eth011grac2:eth0yesAddressMTUResult: Node connectivity passed for subnet 192.168.137.0 with node(s) 11grac1,11grac2Check: TCP connectivity of subnet 192.168.137.0SourceDestinationConnected?11grac1:192.168.137.16111grac1:192.168.137.163passed11grac1:192.168.137.20011grac2:192.168.137.162passedpassed11grac1:192.168.137.16111grac1:192.168.137.161Result: TCP connectivity check passed for subnet 192.168.137.0Check: Node connectivity of subnet 192.168.136.0SourceDestinationConnected?11grac1:eth111grac2:eth1yesResult: Node connectivity passed for subnet ”192.168.136.0 with node(s) 11grac1,11grac2Check: TCP connectivity of subnet 192.168.136.0SourceDestinationConnected?11grac1:192.168.136.16111grac2:192.168.136.162passedResult: TCP connectivity check passed for subnet 192.168.136.0Interfaces found on subnet 192.168.137.0 that are likely candidates for VIP are:11grac1 eth0:192.168.137.161 eth0:192.168.137.163 eth0:192.168.137.20011grac2 eth0:192.168.137.162Interfaces found on subnet 192.168.136.0 that are likely candidates for a private interconnect are:11grac1 eth1:192.168.136.16111grac2 eth1:192.168.136.162Result: Node connectivity check passedCheck: Total memoryNode Name AvailableRequiredComment 11grac2 1.97GB (2061864.0KB)1.5GB (1572864.0KB) passedResult: Total memory check passedCheck: Available memoryNode Name AvailableRequiredComment11grac2 1.88GB (1970204.0KB) 50MB (51200.0KB)passedResult: Available memory check passedCheck: Swap spaceNode Name AvailableRequiredComment 11grac2 4GB (4192956.0KB)2.95GB (3092796.0KB) passedResult: Swap space check passedCheck: Free disk space for 11grac2:/tmpPathNode Name Mount point Available RequiredComment1GB/tmp11grac2/15.54GBpassedResult: Free disk space check passed for 11grac2:/tmp”Check: User existence for gridCommentNode Name Status11grac2 existspassedResult: User existence check passed for gridCheck: Run levelNode Name run levelRequiredComment11grac2 33,5passedResult: Run level check passedCheck: Hard limits for maximum open file descriptorsNode NameTypeAvailable Required Comment11grac2hard6553665536passedResult: Hard limits check passed for maximum open file descriptorsCheck: Soft limits for maximum open file descriptorsNode NameTypeAvailable Required Comment 11grac2soft10241024passedResult: Soft limits check passed for maximum open file descriptorsCheck: Hard limits for maximum user processesNode NameTypeAvailable Required Comment11grac2hard1638416384passedResult: Hard limits check passed for maximum user processesCheck: Soft limits for maximum user processesNode NameTypeAvailable Required Comment 11grac2soft20472047passedResult: Soft limits check passed for maximum user processesCheck: System architectureNode NameAvailableRequiredComment11grac2i686x86Result: System architecture check passedCheck: Kernel versionNode NameAvailableRequired11grac22632-300.10.1.el5uek2.6.18Result: Kernel version check passedCheck: Kernel parameter for semmslNode NameConfiguredRequired11grac2250250Result: Kernel parameter check passed for semmslCheck: Kernel parameter for semmnsNode NameConfiguredRequired11grac23200032000Result: Kernel parameter check passed for semmnsCheck: Kernel parameter for semopmNode NameConfiguredRequired11grac2100100Result: Kernel parameter check passed for semopmCheck: Kernel parameter for semmniNode NameConfiguredRequired11grac2128128Result: Kernel parameter check passed for semmniCheck: Kernel parameter for shmmaxNode NameConfiguredRequired11grac21073741824536870912Result: Kernel parameter check passed for shmmaxCheck: Kernel parameter for shmmniNode NameConfiguredRequired11grac240964096passedComment passedComment passedComment passedComment passedComment passedComment passedComment passedResult: Kernel parameter check passed for shmmniCheck: Kernel parameter for shmallNode NameConfiguredRequired11grac283886082097152CommentpassedResult: Kernel parameter check passed for shmallCheck: Kernel parameter for file-maxNode NameConfiguredRequired11grac268157446815744CommentpassedResult: Kernel parameter check passed for file-maxCheck: Kernel parameter for ip_local_port_rangeNode NameConfiguredRequired11grac2between 9000 & 65500between 9000 & 65500CommentpassedResult: Kernel parameter check passed for ip_local_port_rangeCheck: Kernel parameter for rmem_defaultNode NameConfiguredRequired11grac2262144262144CommentpassedResult: Kernel parameter check passed for rmem_defaultCheck: Kernel parameter for rmem_maxNode NameConfiguredRequired11grac241943044194304CommentpassedResult: Kernel parameter check passed for rmem_maxCheck: Kernel parameter for wmem_defaultNode NameConfiguredRequired11grac2262144262144CommentpassedResult: Kernel parameter check passed for wmem_defaultCheck: Kernel parameter for wmem_maxNode NameConfiguredRequired11grac210485861048576CommentpassedResult: Kernel parameter check passed for wmem_maxCheck: Kernel parameter for aio-max-nrNode Name ConfiguredRequiredComment11grac2 10485761048576passedResult: Kernel parameter check passed for aio-max-nrCheck: Package existence for make-3.81Node Name AvailableRequiredComment 11grac2 make-3.81-3.el5make-3.81passedResult: Package existence check passed for make-3.81Check: Package existence for binutils-2.17.50.0.6Node Name AvailableRequiredComment 11grac2 binutils-2.17.50.0.6-20.el5binutils-2.17.50.0.6 passedResult: Package existence check passed for binutils-2.17.50.0.6Check: Package existence for gcc-4.1.2Node Name AvailableRequiredComment11grac2 gcc-4.1.2-52.el5gcc-4.1.2passedResult: Package existence check passed for gcc-4.1.2Check: Package existence for gcc-c+-4.1.2Node Name AvailableRequiredComment11grac2 gcc-c+-4.1.2-52.el5gcc-c+-4.1.2passedResult: Package existence check passed for gcc-c+-4.1.2Check: Package existence for libgomp-4.1.2Node Name AvailableRequiredComment11grac2 libgomp-4.4.6-3.el5.1 libgomp-4.1.2passedResult: Package existence check passed for libgomp-4.1.2Check: Package existence for libaio-0.3.106Node Name AvailableRequiredComment 11grac2 libaio-0.3.106-5libaio-0.3.106passedResult: Package existence check passed for libaio-0.3.106Check: Package existence for glibc-2.5-24Node Name AvailableRequiredComment11grac2 glibc-2.5-81glibc-2.5-24passedResult: Package existence check passed for glibc-2.5-24Check: Package existence for compat-libstdc+-33-3.2.3Node Name AvailableRequiredComment 11grac2 compat-libstdc+-33-3.2.3-61 compat-libstdc+-33-3.2.3 passedResult: Package existence check passed for compat-libstdc+-33-3.2.3Check: Package existence for elfutils-libelf-0.125Node Name AvailableRequiredComment11grac2 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passedResult: Package existence check passed for elfutils-libelf-0.125Check: Package existence for elfutils-libelf-devel-0.125Node Name AvailableRequiredComment11grac2 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passedResult: Package existence check passed for elfutils-libelf-devel-0.125Check: Package existence for glibc-common-2.5Node Name AvailableRequiredComment11grac2 glibc-common-2.5-81glibc-common-2.5passedResult: Package existence check passed for glibc-common-2.5Check: Package existence for glibc-devel-2.5Node Name AvailableRequiredComment11grac2 glibc-devel-2.5-81glibc-devel-2.5passedResult: Package existence check passed for glibc-devel-2.5Check: Package existence for glibc-headers-2.5Node Name AvailableRequiredComment11grac2 glibc-headers-2.5-81 glibc-headers-2.5passedResult: Package existence check passed for glibc-headers-2.5Check: Package existence for libaio-devel-0.3.106Node Name AvailableRequiredComment11grac2 libaio-devel-0.3.106-5 libaio-devel-0.3.106 passedResult: Package existence check passed for libaio-devel-0.3.106Check: Package existence for libgcc-4.1.2Node Name AvailableRequiredComment11grac2 libgcc-4.1.2-52.el5 libgcc-4.1.2passedResult: Package existence check passed for libgcc-4.1.2Check: Package existence for libstdc+-4.1.2Node Name AvailableRequiredComment11grac2 libstdc+-4.1.2-52.el5libstdc+-4.1.2passedResult: Package existence check passed for libstdc+-4.1.2Check: Package existence for libstdc+-devel-4.1.2Node Name AvailableRequiredComment11grac2 libstdc+-devel-4.1.2-52.el5 libstdc+-devel-4.1.2 passedResult: Package existence check passed for libstdc+-devel-4.1.2Check: Package existence for sysstat-7.0.2Node Name AvailableRequiredComment11grac2 sysstat-7.0.2-11.el5 sysstat-7.0.2passedResult: Package existence check passed for sysstat-7.0.2Check: Package existence for unixODBC-2.2.11Node Name AvailableRequiredComment11grac2 unixODBC-2.2.11-10.el5 unixODBC-2.2.11passedResult: Package existence check passed for unixODBC-2.2.11Check: Package existence for unixODBC-devel-2.2.11Node Name AvailableRequiredComment11grac2 unixODBC-devel-2.2.11-10.el5 unixODBC-devel-2.2.11 passedResult: Package existence check passed for unixODBC-devel-2.2.11Check: Package existence for ksh-20060214Node Name AvailableRequiredComment11grac2 ksh-20100621-5.el5ksh-20060214passedResult: Package existence check passed for ksh-20060214Checking for multiple users with UID value 0Result: Check for multiple users with UID value 0 passedChecking to make sure user grid is not in root groupNode Name StatusComment11grac2 does not existpassedResult: User grid is not part of root group. Check passedStarting Clock synchronization checks using Network Time Protocol(NTP)NTP Configuration file check started.Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodesResult: Clock synchronization check using Network Time Protocol(NTP) passedPre-check for node addition was successful. grid11grac1 bin$(九)扩展新节点到集群中(期间传文件可能会花段时间)grid11grac1 bin$ pwd/u01 /11.2.0/grid/oui/bingrid11grac1 bin$ ./addNode.sh -silent cluster_new_nodes=11grac2cluster_new_virtual_hostnames=11grac2-vipStarting Oracle Universal Installer.Checking swap space: must be greater than 500 MB. Actual 4094 MB PassedOracle Universal Installer, Version 11.2.0.1.0 ProductionCopyright (C) 1999, 2009, Oracle. All rights reserved.Performing tests to see whether nodes 11grac2 are available 100%Done.Cluster Node Addition SummaryGlobal SettingsSource: /u01 /11.2.0/gridNew NodesSpace RequirementsNew Nodes11grac2/: Required 3.46GB : Available 14.46GBInstalled ProductsProduct NamesOracle Grid Infrastructure 11.2.0.1.0Sun JDK 1.5.0.17.0Installer SDK Component 11.2.0.1.0Oracle One-Off Patch Installer 11.2.0.0.2Oracle Universal Installer 11.2.0.1.0Oracle Configuration Manager Deconfiguration 10.3.1.0.0Enterprise Manager Common Core Files 10.2.0.4.2Oracle DBCA Deconfiguration 11.2.0.1.0Oracle RAC Deconfiguration 11.2.0.1.0Oracle Quality of Service Management (Server) 11.2.0.1.0Installation Plugin Files 11.2.0.1.0Universal Storage Manager Files 11.2.0.1.0Oracle Text Required Support Files 11.2.0.1.0Automatic Storage Management Assistant 11.2.0.1.0Oracle Database 11g Multimedia Files 11.2.0.1.0Oracle Multimedia Java Advanced Imaging 11.2.0.1.0Oracle Globalization Support 11.2.0.1.0Oracle Multimedia Locator RDBMS Files 11.2.0.1.0Oracle Core Required Support Files 11.2.0.1.0Bali Share 1.1.18.0.0Oracle Database Deconfiguration 11.2.0.1.0Oracle Quality of Service Management (Client) 11.2.0.1.0Expat libraries 2.0.1.0.1Oracle Containers for Java 11.2.0.1.0Perl Modules 5.10.0.0.1Secure Socket Layer 11.2.0.1.0Oracle JDBC/OCI Instant Client 11.2.0.1.0Oracle Multimedia Client Option 11.2.0.1.0LDAP Required Support Files 11.2.0.1.0Character Set Migration Utility 11.2.0.1.0Perl Interpreter 5.10.0.0.1PL/SQL Embedded Gateway 11.2.0.1.0OLAP SQL Scripts 11.2.0.1.0Database SQL Scripts 11.2.0.1.0Oracle Extended Windowing Toolkit 3.4.47.0.0SSL Required Support Files for InstantClient 11.2.0.1.0SQL*Plus Files for Instant Client 11.2.0.1.0Oracle Net Required Support Files 11.2.0.1.0Oracle Database User Interface 2.2.13.0.0RDBMS Required Support Files for Instant Client 11.2.0.1.0Enterprise Manager Minimal Integration 11.2.0.1.0XML Parser for Java 11.2.0.1.0Oracle Security Developer Tools 11.2.0.1.0Oracle Wallet Manager 11.2.0.1.0Enterprise Manager plugin Common Files 11.2.0.1.0Platform Required Support Files 11.2.0.1.0Oracle JFC Extended Windowing Toolkit 4.2.36.0.0RDBMS Required Support Files 11.2.0.1.0Oracle Ice Browser 5.2.3.6.0Oracle Help For Java 4.2.9.0.0Enterprise Manager Common Files 10.2.0.4.2Deinstallation Tool 11.2.0.1.0Oracle Java Client 11.2.0.1.0Cluster Verification Utility Files 11.2.0.1.0Oracle Notification Service (eONS) 11.2.0.1.0Oracle LDAP administration 11.2.0.1.0Cluster Verification Utility Common Files 11.2.0.1.0Oracle Clusterware RDBMS Files 11.2.0.1.0Oracle Locale Builder 11.2.0.1.0Oracle Globalization Support 11.2.0.1.0Buildtools Common Files 11.2.0.1.0Oracle RAC Required Support Files-HAS 11.2.0.1.0SQL*Plus Required Support Files 11.2.0.1.0XDK Required Support Files 11.2.0.1.0Agent Required Support Files 10.2.0.4.2Parser Generator Required Support Files 11.2.0.1.0Precompiler Required Support Files 11.2.0.1.0Installation Common Files 11.2.0.1.0Required Support Files 11.2.0.1.0Oracle JDBC/THIN Interfaces 11.2.0.1.0Oracle Multimedia Locator 11.2.0.1.0Oracle Multimedia 11.2.0.1.0HAS Common Files 11.2.0.1.0Assistant Common Files 11.2.0.1.0PL/SQL 11.2.0.1.0HAS Files for DB 11.2.0.1.0Oracle Recovery Manager 11.2.0.1.0Oracle Database Utilities 11.2.0.1.0Oracle Notification Service 1120.0.0SQL*Plus 11.2.0.1.0Oracle Netca Client 11.2.0.1.0Oracle Net 11.2.0.1.0Oracle JVM 11.2.0.1.0Oracle Internet Directory Client 11.2.0.1.0Oracle Net Listener 11.2.0.1.0Cluster Ready Services Files 11.2.0.1.0Oracle Database 11g 11.2.0.1.0Instantiating scripts for add node (Wednesday, August 29, 2012 1:04:40 PM CST)1% Done.Instantiation of add node scripts completeCopying to remote nodes (Wednesday, August 29, 2012 1:04:51 PM CST)96% Done.Home copied to new nodesSaving inventory on nodes (Wednesday, August 29, 2012 1:19:31 PM CST)100% Done.Save inventory completeWARNING:A new inventory has been created on one or more nodes in this session. However, it has not yet been registered as the central inventory of this system.To register the new inventory please run the script at /u01 /app/oraInventory/orainstRoot.sh with root privileges on nodes 11grac2.If you do not register the inventory, you may not be able to update or patch the products you installed.The following configuration scripts need to be executed as the root user in ea