HP InfiniBand Solution for Oracle Application Server white paper

ManualsBrandsHP ManualsServerHP ProLiant DL580 G3 Base Model Server

HP InfiniBand solution for Oracle Application Server

Overview......................................................................................................................................2

Oracle Application Server overview...............................................................................................2

Advantages of InfiniBand in an Oracle Application Server environment ............................................2

HP InfiniBand solution for Oracle Application Server.........................................................................3

Solution overview....................................................................................................................3

Sample HP InfiniBand configuration for Oracle AS 10G and Oracle RDBMS 10G..............................4

Installation process..........................................................................................................................5

Oracle AS on InfiniBand installation process....................................................................................5

Hardware setup and configuration .............................................................................................5

Red Hat Enterprise Linux® installation .........................................................................................5

Installation of InfiniBand software components..............................................................................5

Oracle RDBMS 10G installation.................................................................................................6

Oracle Application Server 10G installation..................................................................................6

Transparent SDP configuration...................................................................................................7

Sample J2EE application installation...........................................................................................8

For more information.......................................................................................................................9

Summary of content (9 pages)

PAGE 1
HP InfiniBand solution for Oracle Application Server Overview ...................................................................................................................................... 2 Oracle Application Server overview ............................................................................................... 2 Advantages of InfiniBand in an Oracle Application Server environment ............................................ 2 HP InfiniBand solution for Oracle Application Server ..........
PAGE 2
Overview This whitepaper explains how to implement an Oracle Applications Server (AS) J2EE solution for the database connection using HP ProLiant servers, HP StorageWorks, and HP InfiniBand™ options. The whitepaper is intended for system administrators, system architects, and systems integrators who are considering the advantages of HP InfiniBand-based systems in an Oracle AS J2EE environment.
PAGE 3
passing through either device’s CPU, without needing extensive buffering, and without calling to an operating system kernel. RDMA can bring about a substantial reduction in CPU utilization on both the application and database servers. Oracle’s 10G RDBMS product supports native SDP; however, Oracle products that use an earlier version of the Oracle DB client can only utilize Transparent SDP. Both Oracle AS 9i and 10G Release 1 use the Oracle 9i DB client. Therefore, they can only use Transparent SDP.
PAGE 4
Figure 1. HP InfiniBand solution for Oracle AS high level diagram Sample HP InfiniBand configuration for Oracle AS 10G and Oracle RDBMS 10G The orderable components necessary to build a 2-node sample configuration based on the HP ProLiant DL380 server, HP StorageWorks MSA 1000 for database storage, and HP ProLiant InfiniBand options for the private interconnect is shown in Table 1. Table 1.
PAGE 5
Quantity Part Number Description 1 321835-B21 StorageWorks 2 Gb, Dual Port, 64-Bit/133 MHz PCI-X-to-Fibre Channel Host Bus Adapter for W2K, Windows Server 2003 and Linux® 1 221692-B22 5 Meter FC LC-LC Multi-Mode cable 1 201723-B22 Modular SAN Array 1000 with 256 MB cache 1 190211-001 StorageWorks Enclosure Model 4354R – Rack 14 286776-B22 36.
PAGE 6
Once the HP InfiniBand 4x HCA drivers have been installed and configured on both servers, modify one of the unused Linux Ethernet configuration files (or make a copy) for use as the private interconnect. Edit the hosts file to include both “hostname_IB” and the IP address defined in the Linux Ethernet configuration files used for private interconnect.
PAGE 7
Transparent SDP configuration The following steps are very crucial and require absolute path statements; any typing errors could render the system inoperable. The preload file, ld.so.preload points to a library, libsdp.so, to be loaded during system startup. If the path is incorrect, library name is misspelled, or library does not exist a reinstall of the operating system may be required. On the database server 1. Verify the existence of /lib/libsdp.so 2. Stop the database 3. Stop the listener 4.
PAGE 8
(SERVICE_NAME = INT) ) ) 6. Check /proc/topspin/sdp/conn_main (should have 1 entries) 7. Verify sqlplus connection with the database. Sample J2EE application installation Installation notes and scripts are generally provided with the J2EE application software. Configure the J2EE application to utilize the private InfiniBand interconnect. Modify the data sources for the sample J2EE Application as in the following example: IASDBDS JDBC URL jdbc:oracle:thin:@dbhostname_IB:1521:INT Test the connectivity 1.
PAGE 9
For more information For additional information, refer to the resources detailed below. Resource description Web address HP ProLiant InfniBand options http://h18004.www1.hp.com/products/servers/networking/indexib.html HP StorageWorks Modular Smart Arrays (MSA) http://h18006.www1.hp.com/storage/arraysystems.html HP ProLiant servers http://h18004.www1.hp.com/products/servers/platforms/ HP Parallel Database Clusters (PDC) for Oracle RAC http://h18004.www1.hp.