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......
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.
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.
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.
Quantity Part Number Description 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® 221692-B22 5 Meter FC LC-LC Multi-Mode cable 201723-B22 Modular SAN Array 1000 with 256 MB cache 190211-001 StorageWorks Enclosure Model 4354R –...
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.
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.
(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...