Comments on Oracle DBA and RAC DBA Expert: Oracle RAC load balancing and failover

Hi Satishbabu, Thanks so much for your reply.. My...

2011-09-26T22:16:06.477-07:00

Hi Satishbabu,
Thanks so much for your reply.. My problem is I have this Makefile that has some info to make jdbc connection. It takes the -DRME_Server = db servername,-DDB_NAME which is SID and the port and db user info. Any idea how to add the syntax you mentioned to these settings in Makfile? Thanks so much.

# JDK application settings
#----------------------------------------------------------------------
JAVA_FLAGS = -classpath $(CLASSPATH) -Dorg.omg.CORBA.ORBClass=IE.Iona.OrbixWeb.CORBA.ORB -Dorg.omg.CORBA.ORBSingletonClass=IE.Iona.OrbixWeb.CORBA.singletonORB -DRME_PORT="12502" -DRME_SERVER="efkxrme11" -DDB_NAME="rme1" -DDB_USER="rm" -DDB_PASS="rm"
JAVAC_FLAGS = -d $(CLASS_DIR) -classpath $(CLASSPATH)
#-----------------------------------------------

Use below syntax when you configure connection to ...

2011-09-26T13:20:36.821-07:00

Use below syntax when you configure connection to an Oracle RAC environment.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= rac1.domain.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= rac2.domain.com)(PORT=1521))(FAILOVER=on)(LOAD_BALANCE=on)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbservice)))

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com

use jdbc:oracle:thin:@ : Getting the hostname, S...

2011-09-26T09:43:26.106-07:00

use jdbc:oracle:thin:@ :

Getting the hostname, SID,DB User, DB port
from JAVA FLAGS:
JAVA_FLAGS = -classpath $(CLASSPATH) -Dorg.omg.CORBA.ORBClass=IE.Iona.OrbixWeb.CORBA.ORB -Dorg.
omg.CORBA.ORBSingletonClass=IE.Iona.OrbixWeb.CORBA.singletonORB -DRME_PORT="14150" -DRME_SERVER="efk
xracs" -DDB_NAME="RMET1" -DDB_PORT="1526" -DDB_USER="rm" -DDB_PASS="rm"
JAVAC_FLAGS = -d $(CLASS_DIR) -classpath $(CLASSPATH)

How can I add another host and SID where load balance is turned on

If you don't mention then it will take default...

2011-07-07T11:38:03.154-07:00

If you don't mention then it will take default value.

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com

Is it mandatory to set the FAILOVER=ON in connecti...

2011-07-04T05:14:37.166-07:00

Is it mandatory to set the FAILOVER=ON in connection string even when we use FCF ? I mean while using FCF, failover is implied so it is still necessary to specify FAILOVER=ON in the connection string.

2011-07-04T05:12:19.852-07:00

This comment has been removed by the author.

Please note that your will configure TAF at client...

2011-01-20T09:43:08.259-08:00

Please note that your will configure TAF at client side.

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com

Its really nice post .. but i have few queries...

2010-09-30T10:53:35.527-07:00

Its really nice post .. but i have few queries on this above discussion .

Are we giving the TAF configuration parameters under ORACLE HOME tns file or in the client side tns file ?

Please correct me if am wrong .

Thanks ,
Senthil

This is a nice post, thanks raju

2010-04-27T14:53:37.329-07:00

This is a nice post, thanks
raju

nice post Thanks Alex

2010-02-22T16:20:33.732-08:00

nice post

Thanks
Alex