• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

oracle 11g jdbc connect string

The following is the new syntax for Oracle JDBC connection strings:

jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE

But what is the new syntax for multiple hosts (for fail over)?
0
rmundkowsky
Asked:
rmundkowsky
  • 3
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
That is just a new method called EZCONNECT.  It is just that 'EASY'.

For more complex setups, use the old standard: tnsanmes.ora or one of the others.

http://docs.oracle.com/cd/E11882_01/network.112/e10836/naming.htm
0
 
BajwaCommented:
"But what is the new syntax for multiple hosts (for fail over)? "

the service defines the failover!
0
 
slightwv (䄆 Netminder) Commented:
>>the service defines the failover!

Can you show how this is done with EZConnect syntax?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
rmundkowskyAuthor Commented:
I have not been able to find any info on complex EZConnect strings, so I think slightwv is right.

Thanks all!
0
 
rmundkowskyAuthor Commented:
Well, after quite a bit of playing around it seems:
1) If you are using 11g client you can use easy connect string and old syntax
2) If you are using older client (e.g. 10g) you can only use the scan host name if you use the easy connect string (this worked in tests, but using different hosts and IPs is official way), otherwise you need to use the actual different hostname names of IPs that are associated with the scan.  See page 5 of
http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now