oracle 11g jdbc connect string

Posted on 2012-08-13
Last Modified: 2012-10-23
The following is the new syntax for Oracle JDBC connection strings:


But what is the new syntax for multiple hosts (for fail over)?
Question by:rmundkowsky
    LVL 76

    Accepted Solution

    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.
    LVL 5

    Expert Comment

    "But what is the new syntax for multiple hosts (for fail over)? "

    the service defines the failover!
    LVL 76

    Expert Comment

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

    Can you show how this is done with EZConnect syntax?

    Author Comment

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

    Thanks all!

    Assisted Solution

    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

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This video shows how to recover a database from a user managed backup

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now