New JDBC thin driver format for Oracle SCAN database URL.

New JDBC thin driver format for Oracle SCAN database URL.

book

Article ID: KB0092737

calendar_today

Updated On:

Products Versions
TIBCO Silver Fabric Engine -
Not Applicable -

Description

Resolution:

If deciding to use SCAN URL for a database URL (used for connecting to Oracle RAC), the new format for the JDBC thin driver from Oracle needs to be used for Admin Domain. Else, the Admin domain will not start.

Old Syntax: jdbc:oracle:thin:@[HOST][:PORT]:SID

New Syntax: jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE

The old syntax will only work with SID. The new format needs to be used with an Oracle service name.

Reference: http://www.orafaq.com/wiki/JDBC#Thin_driver

Issue/Introduction

New JDBC thin driver format for Oracle SCAN database URL.