Installing Oracle RAC 10g Release 2 on Linux x86.docx

1、Installing Oracle RAC 10g Release 2 on Linux x86Installing Oracle RAC 10g Release 2 on Linux x86by John Smiley Learn the basics of installing Oracle RAC 10g Release 2 on Red Hat Enterprise Linux or Novell SUSE Enterprise Linux, from the bare metal up (for evaluation purposes only) ContentsOverviewBa

2、ckgroundPart I: Install LinuxPart II: Configure Linux for OraclePart III: Prepare the Shared DisksPart IV: Install Oracle RAC SoftwareConclusion Overview This guide provides a walkthrough of installingan Oracle Database 10g Release 2 RAC databaseon commodity hardware for the purpose of evaluation. I

3、f you are new to Linux and/or Oracle, this guide is for you. It starts with the basics and walks you through an installation of Oracle Database 10g Release 2 RAC from the bare metal up. This guide will take the approach of offering the easiest paths, with the fewest number of steps, for accomplishin

4、g a task. This approach often means making configuration choices that would be inappropriate for anything other than an evaluation. For that reason, this guide is not appropriate for building production-quality environments, nor does it reflect best practices. The three Linux distributions certified

5、 for Oracle10g Release 2 RAC are: Red Hat Enterprise Linux 4 (RHEL4) Red Hat Enterprise Linux 3 (RHEL3) Novell SUSE Linux Enterprise Server 9 We will cover both of the Linux 2.6 kernel-based distributions: RHEL4 and SLES9. RHEL3 is not covered here. This guide is divided into four parts: Part I cove

6、rs the installation of the Linux operating system, Part II covers configuring Linux for Oracle, Part III discusses the essentials of partitioning shared disk, and Part IV covers installation of the Oracle software. A Release 1 version of this guide is also available.Background The illustration below

7、 shows the major components of an Oracle RAC 10g Release 2 configuration. Nodes in the cluster are typically separate servers (hosts). HardwareAt the hardware level, each node in a RAC cluster shares three things: 1. Access to shared disk storage 2. Connection to a private network 3. Access to a pub

8、lic network. Shared Disk StorageOracle RAC relies on a shared disk architecture. The database files, online redo logs, and control files for the database must be accessible to each node in the cluster. The shared disks also store the Oracle Cluster Registry and Voting Disk (discussed later). There a

9、re a variety of ways to configure shared storage including direct attached disks (typically SCSI over copper or fiber), Storage Area Networks (SAN), and Network Attached Storage (NAS). Private NetworkEach cluster node is connected to all other nodes via a private high-speed network, also known as th

10、e cluster interconnect or high-speed interconnect (HSI). This network is used by Oracles Cache Fusion technology to effectively combine the physical memory (RAM) in each host into a single cache. Oracle Cache Fusion allows data stored in the cache of one Oracle instance to be accessed by any other i

11、nstance by transferring it across the private network. It also preserves data integrity and cache coherency by transmitting locking and other synchronization information across cluster nodes. The private network is typically built with Gigabit Ethernet, but for high-volume environments, many vendors

12、 offer proprietary low-latency, high-bandwidth solutions specifically designed for Oracle RAC. Linux also offers a means of bonding multiple physical NICs into a single virtual NIC (not covered here) to provide increased bandwidth and availability. Public NetworkTo maintain high availability, each c

13、luster node is assigned a virtual IP address (VIP). In the event of node failure, the failed nodes IP address can be reassigned to a surviving node to allow applications to continue accessing the database through the same IP address. Configuring the Cluster HardwareThere are many different ways to c

14、onfigure the hardware for an Oracle RAC cluster. Our configuration here uses two servers with two CPUs, 1GB RAM, two Gigabit Ethernet NICs, a dual channel SCSI host bus adapter (HBA), and eight SCSI disks connected via copper to each host (four disks per channel). The disks were configured as Just a

15、 Bunch Of Disks (JBOD)that is, with no hardware RAID controller. SoftwareAt the software level, each node in a RAC cluster needs: 1. An operating system 2. Oracle Clusterware 3. Oracle RAC software 4. An Oracle Automatic Storage Management (ASM) instance (optional). Operating SystemOracle RAC is sup

16、ported on many different operating systems. This guide focuses on Linux. The operating system must be properly configured for the OS-including installing the necessary software packages, setting kernel parameters, configuring the network, establishing an account with the proper security, configuring

17、 disk devices, and creating directory structures. Allthese tasks are described in this guide. Oracle Cluster Ready Services becomes Oracle ClusterwareOracle RAC 10g Release 1 introduced Oracle Cluster Ready Services (CRS), a platform-independent set of system services for cluster environments. In Re

18、lease 2, Oracle has renamed this product to Oracle Clusterware. Clusterware maintains two files: the Oracle Cluster Registry (OCR) and the Voting Disk. The OCR and the Voting Disk must reside on shared disks as either raw partitions or files in a cluster filesystem. This guide describes creating the

19、 OCR and Voting Disks using a cluster filesystem (OCFS2) and walks through the CRS installation. Oracle RAC SoftwareOracle RAC 10g Release 2 software is the heart of the RAC database and must be installed on each cluster node. Fortunately, the Oracle Universal Installer (OUI) does most of the work o

20、f installing the RAC software on each node. You only have to install RAC on one nodeOUI does the rest. Oracle Automatic Storage Management (ASM)ASM is a new feature in Oracle Database 10g that provides the services of a filesystem, logical volume manager, and software RAID in a platform-independent

21、manner. Oracle ASM can stripe and mirror your disks, allow disks to be added or removed while the database is under load, and automatically balance I/O to remove hot spots. It also supports direct and asynchronous I/O and implements the Oracle Data Manager API (simplified I/O system call interface)

22、introduced in Oracle9i. Oracle ASM is not a general-purpose filesystem and can be used only for Oracle data files, redo logs, control files, and the RMAN Flash Recovery Area. Files in ASM can be created and named automatically by the database (by use of the Oracle Managed Files feature) or manually

23、by the DBA. Because the files stored in ASM are not accessible to the operating system, the only way to perform backup and recovery operations on databases that use ASM files is through Recovery Manager (RMAN). ASM is implemented as a separate Oracle instance that must be up if other databases are t

24、o be able to access it. Memory requirements for ASM are light: only 64MB for most systems. In Oracle RAC environments, an ASM instance must be running on each cluster node. Part I: Installing Linux Install and Configure Linux as described in the first guide in this series. You will need three IP add

25、resses for each server: one for the private network, one for the public network, and one for the virtual IP address. Use the operating systems network configuration tools to assign the private and public network addresses. Do not assign the virtual IP address using the operating systems network conf

26、iguration tools; this will be done by the Oracle Virtual IP Configuration Assistant (VIPCA) during Oracle RAC software installation. Red Hat Enterprise Linux 4 (RHEL4) Required Kernel:2.6.9-11.ELor higher Verify kernel version: # uname -r2.6.9-22.ELsmpOther required package versions (or higher):binu

27、tils-2.15.92.0.2-10.EL4compat-db-4.1.25-9control-center-2.8.0-12gcc-3.4.3-9.EL4gcc-c+-3.4.3-9.EL4glibc-2.3.4-2glibc-common-2.3.4-2gnome-libs-1.4.1.2.90-44.1libstdc+-3.4.3-9.EL4libstdc+-devel-3.4.3-9.EL4make-3.80-5pdksh-5.2.14-30sysstat-5.0.5-1xscreensaver-4.18-5.rhel4.2Verify installed packages: # r

28、pm -q binutils compat-db control-center gcc gcc-c+ glibc glibc-common gnome-libs libstdc+ libstdc+-devel make pdksh sysstat xscreensaverbinutils-2.15.92.0.2-15compat-db-4.1.25-9control-center-2.8.0-12.rhel4.2gcc-3.4.4-2gcc-c+-3.4.4-2glibc-2.3.4-2.13glibc-common-2.3.4-2.13gnome-libs-1.4.1.2.90-44.1li

29、bstdc+-3.4.4-2libstdc+-devel-3.4.4-2make-3.80-5pdksh-5.2.14-30.3sysstat-5.0.5-1xscreensaver-4.18-5.rhel4.9SUSE Linux Enterprise Server 9 (SLES9) Required Package Sets:Basis Runtime SystemYaSTGraphical Base SystemLinux ToolsKDE Desktop EnvironmentC/C+ Compiler and Tools (not selected by default) Do n

30、ot install:Authentication Server (NIS, LDAP, Kerberos)Required Kernel:2.6.5-7.97or higher Verify kernel version: # uname -r2.6.5-7.97-smpOther required package versions (or higher):gcc-3.3gcc-c+-3.3.3-43glibc-2.3.3-98.28libaio-0.3.98-18libaio-devel-0.3.98-18make-3.80openmotif-libs-2.2.2-519.1Verify

31、installed packages: # rpm -q gcc gcc-c+ glibc libaio libaio-devel make openmotif-libsgcc-3.3.3-43.24gcc-c+-3.3.3-43.24libaio-0.3.98-18.3libaio-devel-0.3.98-18.3make-3.80-184.1openmotif-libs-2.2.2-519.1Part II: Configure Linux for Oracle Create the Oracle Groups and User AccountNext well create the L

32、inux groups and user account that will be used to install and maintain the Oracle 10g Release 2 software. The user account will be called oracle and the groups will be oinstall and dba. Execute the following commands as root on one cluster node only: /usr/sbin/groupadd oinstall/usr/sbin/groupadd dba/usr/sbin/useradd -m -g oinstall -G dba oracleid oracleEx: # /usr/sbin/