This white paper describes the methodologies and processes to effectively deploy an Oracle 10g database in a high-availability configuration using HP XP12000 storage, Integrity Servers, and HP’s management software to deliver an optimally configured and fully manageable Oracle environment. The information is ideally suited to customers that run Oracle on HP-UX, and are seeking information to achieve ultra-high performance and availability.
Highlighted is the deployment and operation of two Oracle RAC configurations, one with two server nodes and one with four. In addition, two discreet deployments were tested:
- HP ServiceGuard plus SGeRAC used with Symantec Cluster Volume Manager (CVM). The Oracle DB was deployed on a Cluster File System.
- HP ServiceGuard plus SGeRAC used with Shared Logical Volume Manager (SLVM). The Oracle DB was deployed using Oracle’s Automatic Storage Manager on raw SLVM volumes.
The white paper focuses on the following deployment and operational issues:
- Configuring the servers for performance and availability, including issues such as the physical configuration, the cluster interconnect communication, and the pathing/interconnect to the storage
- Configuring the storage for performance and availability, including cache, raid group configuration/formatting, multipathing considerations, and fiber port/array interface design
- Effective use of volume managers, such as CVM
- Effective setup of Oracle ASM, with emphasis on proper design for striping, disk groups, and data layout.
- Tuning the Oracle Environment, including proper sizing of the SGA, the XP array cache, disk striping and the ODM.
- The use of key components of HP’s Enterprise Management suite to deliver a fully manageable Oracle environment
|
Printable version
