Users Guide

Oracle Failover | Oracle Database Management
OMNM 6.5.3 Installation Guide 175
Oracle RAC installation.properties File
The following differs slightly for each Oracle versions. For example, 10G RAC uses VIP; 11G RAC
uses Scan (and can also use VIP). Therefore, the
installation.properties file needs to be
like one of the following options:
Option 1
com.dorado.oracle.rac.connect.url=@(DESCRIPTION=(ADDRESS_LIST=\
(ADDRESS=(PROTOCOL=TCP)(HOST=vip1)(PORT=1521))\
(ADDRESS=(PROTOCOL=TCP)(HOST=vip2)(PORT=1521))\
)\
(FAILOVER=on)(LOAD_BALANCE=on)(CONNECT_DATA=(SERVER=DEDICATED)\
(SERVICE_NAME=orcl)))
Option 2
com.dorado.oracle.rac.connect.url=@(DESCRIPTION=(ADDRESS_LIST=\
(ADDRESS=(PROTOCOL=TCP)(HOST=orascan)(PORT=1521))\
)\
(CONNECT_DATA=(SERVER=DEDICATED)\
(SERVICE_NAME=orcl)))
NOTE:
Check the DNS server to make sure it is configured correctly.
Installation also needs the following to install OpenManage Network Manager device drivers:
com.dorado.jdbc.database_name.oracle=@ServerIP:1521:Service_Name
Enable Oracle RAC on all OpenManage Network Manager Application Servers by adding the
following property to the /owareapps/installprops/lib/installed.properties file:
Add com.dorado.oracle.rac.connect.url=@(DESCRIPTION=(ADDRESS_LIST=\
(ADDRESS=(PROTOCOL=TCP)(HOST=[hostname1])(PORT=1521))\
(ADDRESS=(PROTOCOL=TCP)(HOST=[hostname2])(PORT=1521)))\
(FAILOVER=on)(LOAD_BALANCE=on)(CONNECT_DATA=(SERVER=DEDICATED)\
(S
ERVICE_NAME=[Oracle service name])))
Performance Tuning RAC
If you experience performance issues with your Oracle system, the following are some performance
changes and reports you might try:
• Increase portion of SGA (System Global Area) memory dedicated to the data buffer rather
than shared buffer pool.
• Change
cluster_interconnects parameter used in RAC interconnection from the
default MTU of 1500 bytes to 9000 bytes (jumbo frames).
• Investigate and analyze AWR & RDA reports against RAC Nodes.
Setting the MTU to Jumbo Frames may reveal issues with any switch (or switches) between hosts.
You often must set older switches to accept them. You can also adjust the properties on the physical
NICs, but if the switch is not configured to accept them CRS will not start. Most newer switches do
this automatically, but some may not.