HP DL145 HP InfiniBand Solution for Oracle Application Server white paper - 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. # echo "/lib/libsdp.so" > /etc/ld.so.preload 5. # echo "match listen *:1521" >>/usr/local/topspin/etc/libsdp.conf 6. # echo "match destination *:1521" >> /usr/local/topspin/etc/libsdp.conf 7. Edit the listener.ora file to include the private interconnect settings. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = SDP) (HOST = dbhostname_IB) (PORT = 1521)) ) ) NET_ASYNC_IO=FALSE SDP_ASYNC_IO=FALSE 8. Edit the sqlnet.ora file to include the following lines. NET_ASYNC_IO=FALSE SDP_ASYNC_IO=FALSE 9. Start the database 10. Start the listener 11. Check /proc/topspin/sdp/conn_main (should have 3 entries) On the application server 1. Verify the existence of /lib/libsdp.so 2. # echo "/lib/libsdp.so" > /etc/ld.so.preload 3. # echo "match listen *:1521" >>/usr/local/topspin/etc/libsdp.conf 4. # echo "match destination *:1521" >> /usr/local/topspin/etc/libsdp.conf 5. Edit the tnsnames.ora file to included the private interconnect settings. INT = (DESCRIPTOIN = (ADDRESS = (PROTOCOL = TCP) (HOST = dbhostname_IB) (PORT = 1521)) (CONNECT_DATA = 7