Oracle+RAC10g+R2+on+HP+new.docx

1、Oracle+RAC10g+R2+on+HP+newOracle RAC10g R2 on HP-UX 1. Aim of this documentAll described scenarios are based on a 2 node cluster, node1 referred to as ksc and node2 as schalke. In this paper, we use the following logic: ksc# = command needs to be issued as root from node ksc schalke$ = command needs

2、 to be issued as oracle from node schalke ksc/schalke# = command needs to be issued as root from both nodes ksc + schalkeThis document should be used in conjunction with the following Oracle documentation: B25292-02 Oracle Database Release Notes 10g Release 2 (10.2) for HP-UX ItaniumB19067-04 Oracle

3、 Database Release Notes 10g Release 2 (10.2) for HP-UX PA-RISC (64-Bit)B14202-04 Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for hp HP-UXIt also includes material from HP Serviceguard + RAC10g papers written by ACSL labs which are available HP interna

4、lly at 2. Key New Features for RAC10g on HP-UX 2.1. Oracle Clusterware New with RAC 10g, Oracle includes its own Clusterware and package management solution with the database product. The Oracle Clusterware consists of Oracle Cluster Synchronization Services (CSS) to provide cluster management funct

5、ionality Oracle Cluster Ready Services (CRS) support services and workload management and help to maintain the continuous availability of the services. CRS also manages resources such as the virtual IP (VIP) address for the node and the global services daemon. Event Management (EVM) publishes events

6、 generated by CRS This Oracle Clusterware is available on all various Oracle RAC platforms and based on the HP TruCluster product which Oracle licensed a couple of years ago. Customers can now deploy Oracle RAC clusters without any additional 3rd party clusterware products such as SG/SGeRAC. However

7、, customers might want to continue to use SG/SGeRAC for the cluster management (e.g. to make your complete cluster high available including 3rd party application, interconnect, etc.). In this case Oracle Clusterware interacts with the SG/SGeRAC to coordinate cluster membership information. New Featu

8、res for Oracle Clusterware with RAC 10g R2: Oracle 10g R2 comes with new Cluster Verification Utility that you can use to check whether or not your cluster is properly configured, to avoid installation failures, and to avoid database creation failures. With 10g R2, Oracle Clusterware provides the po

9、ssibility to mirror the Oracle Cluster Registry (OCR) file, enhancing cluster reliability. With 10g R2, CSS has been modified to allow you to configure multiple voting disks. In RAC10g R1, you could configure only one voting disk. By enabling multiple voting disk configuration, the redundant voting

10、disks allow you to configure a RAC database with multiple voting disks on independent shared physical disks. With Oracle 10g R2, in addition, while continuing to be required for RAC databases, Oracle Clusterware is also available for use with single-instance databases and applications that you deplo

11、y on clusters. The API libraries required for use with single-instance databases are provided with the Oracle Client installation media. 2.2. Oracle Automatic Storage Management Oracle Automatic Storage Management (ASM) is a new feature that has be introduced in Oracle Database 10g to simplify the s

12、torage of Oracle data. ASM virtualizes the database storage into disk groups. The DBA is able to manage a small set of disk groups and ASM automates the placement of the database files within those disk groups. In summary ASM does provide the following functionality: Manages groups of disks, called

13、disk groups. Provides three mirroring options for protection against disk failure: none, two-way, and three-way mirroring. Spreads data evenly across all available storage resources to optimize performance and utilization. Enables the DBA to change the storage configuration without having to take th

14、e database offline. Automatically rebalances files across the disk group after disks have been added or dropped. New Features for Oracle ASM with 10g R2: ASM Command-Line Utility for ASM file administration: $ asmcmd help Oracle 10g R2 supports installation of Automatic Storage Management in a separ

15、ate ASM home directory. Supports interoperability for all versions of ASM and Database instances starting with RAC10g R1. This allows the ASM instance and DB instance to be upgraded independently: ASM migration utility with Enterprise Manager Grid Control GUI2.3. HP Serviceguard Cluster File System

16、for Oracle RAC In September 2005, HP announced the availability of the new HP Serviceguard Storage Management Suite that offers enhanced database, cluster, and performance management capabilities for HP-UX 11i environments by integrating HP Serviceguard and Symantec VERITAS Storage Foundation. This

17、new product suite is ideally suited to customers who need the highest levels of availability and superior Oracle database performance or who have an application that would benefit from a clustered file system. The HP Serviceguard Cluster File System for Oracle RAC Suite includes the following techno

18、logies from Symantec VERITAS Storage Foundation: Cluster File System (CFS)provides excellent I/O performance and simplifies the installation and ongoing management of a RAC database Advanced volume management and file system (AVMFS) capabilitiesoffers dynamic multipathing, database tablespace growth

19、, and hot relocation of failed redundant storage. It also provides a variety of online options, including storage reconfiguration and volume and file system creation and resizing. Oracle Disk Manager (ODM)delivers almost raw performance running direct I/O by caching frequently accessed data Quality

20、of storage service (QoSS)enables administrators to set policies that segment company data based on various characteristics and assign the data to appropriate classes of storage over time FlashSnaphelps database administrators easily establish a database clone, a duplicate database on a secondary hos

21、t for off-host processing This HP Serviceguard Storage Management Suite is offered and supported directly from HP for a single point of contact for all your support needs. HP Product Number: T2777BA (HP Serviceguard CFS for RAC LTU). 3. Supported Configurations with RAC10g on HP-UX Customers do have

22、 a variety of choices with regards to the installation and set-up of Oracle Real Application Clusters 10g on the HP-UX platform. First customers need to make a decision with regards to the underlying cluster software. Customers have the possibility to deploy their RAC cluster only with Oracle Cluste

23、rware. Alternatively, customers might want to continue to use HP Serviceguard & HP Serviceguard Extension for RAC (SGeRAC) for the cluster management. In this case Oracles CSS interacts with HP SG/SGeRAC to coordinate cluster membership information. For storage management, customers have the choice

24、to use Oracle ASM, HPs Cluster File Systems or RAW Devices. Please note, for RAC with Standard Edition installations, Oracle mandates that the Oracle data must be placed under ASM control.The figure below illustrates the supported configurations with Oracle RAC10gR2 on HP-UX.The following table show

25、s the storage options supported for storing Oracle Clusterware files, Oracle database files, and Oracle database recovery files. Oracle database files include data files, control files, redo log files, the server parameter file, and the password file. Oracle Clusterware files include Oracle Cluster

26、Registry (OCR) and Voting disk. Oracle Recovery files include archive log files. 4. General System Installation Requirements 4.1. Hardware Requirements at least 1GB of physical RAM. Use the following command to verify the amount of memory installed on your system: # /usr/contrib/bin/machinfo | grep

27、-i Memory or # /usr/sbin/dmesg | grepPhysical: Swap space equivalent to the multiple of the available RAM, as indicated here: If RAM between 1GB and 2GB, then swap space required is 1.5 times the size of RAM If RAM 2GB, then swap space required is equal to the size of RAM Use the following command t

28、o determine the amount of swap space installed on your system:# /usr/sbin/swapinfo a 400 MB of disk space in the /tmp directory. To determine the amount of disk space available in the /tmp directory, enter the following command: # bdf /tmp If there is less than 400 MB of disk space available in the

29、/tmp directory extend the file system or set the TEMP and TMPDIR environment variables when setting the oracle users environment. This environment variables can be used to override /tmp.: $ export TEMP=/directory$ export TMPDIR=/directory 4 GB of disk space for the Oracle software. You can determine

30、 the amount of free disk space on the system using # bdf k 1.2 GB of disk space for a preconfigured database that uses file system storage (optional) Operating System: HP-UX 11.23 (Itanium2), 11.23 (PA-RISC), 11.11 (PA-RISC). To determine if you have a 64-bit configuration enter the following comman

31、d: # /bin/getconf KERNEL_BITS To determine which version of HP-UX is installed, enter the following command: # uname a Asnyc I/O is required for Oracle on RAW devices and configured on HP-UX 11.23 by default. You can check if you have the following file: # ll /dev/async# crw-rw-rw-1 bin bin 101 0x00

32、0000 Jun 9 09:38 /dev/async If you want to use Oracle on RAW devices and Async I/O is not configured, then Create the /dev/async character device # /sbin/mknod /dev/async c 101 0x0# chown oracle:dba /dev/async# chmod 660 /dev/async Configure the async driver in the kernel using SAM = Kernel Configuration= Kernel= the driver