mrao
10-16-2008, 10:12 AM
I am trying to use the jdbc thin driver to connect to oracle 10g RAC with a service name and the connection is not successful. If i used oracle sid instead of service name it works. Has anyone been successful connecting to a service name? if so , pl let me know
Here is the difference
jdbc:oracle:thin:@host1:1521:atlprd1 ---> this works. This setting means connect to only one host, database instance
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(CONNECT_DATA=(service_name=atlprod))) ------> this does not work. This setting means connect to any available node and instance
thanks
Here is the difference
jdbc:oracle:thin:@host1:1521:atlprd1 ---> this works. This setting means connect to only one host, database instance
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(CONNECT_DATA=(service_name=atlprod))) ------> this does not work. This setting means connect to any available node and instance
thanks