Re: JDBC connectivity to Oracle RAC
Date: Wed, 02 Jul 2014 22:05:01 +0200
Message-ID: <53B465ED.9070302_at_gmail.com>
You may find additional useful information in the following MOS notes:
Using SCAN With Oracle JDBC 11g Thin Driver (Doc ID 1290193.1)
Which JDBC Driver Versions Support SCAN? (Doc ID 1150835.1)
How to Implement Load Balancing With RAC Configured System Using JDBC
(Doc ID 247135.1)
How to Set JDBC Thin 10g Connection String to RAC Without Referencing
Every Node in the Cluster (Doc ID 414465.1)
Regards
Dimitre
On 02/07/2014 21:59, Radoulov, Dimitre wrote:
> Hi,
> the default SCAN configuration works with Oracle client 11.2 or higher.
> Pre-11.2 clients need a different configuration,
> check Version and Backward Compatibility in the following document:
>
> http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf
>
> Regards
> Dimitre
>
>
> On 02/07/2014 20:13, Chris King wrote:
>> I've got RAC 11gR2 set up in the lab, and am running the scan
>> listener. I've had a number of applications already connecting to the
>> database without issue. And I've reviewed my listener and
>> tnsnames.ora set up with Oracle tech support, and they've found it is
>> properly configured.
>>
>> However, all of the BMC applications trying to connect are having
>> issue. Remedy, which uses a sqlplus client, and Bladelogic, which
>> uses a JDBC driver both will only connect if they specify the
>> instance name instead of the database name (i.e. racdb1 instead of
>> racdb.mydomain). They throw tns errors for everything else.
>>
>> We know that the proper ports, etc. are open, because the BMC
>> applications will connect to the database if we specify an instance
>> name. So it's not an issue of network flow or firewalls, etc. And
>> we've verified that these applications run with RAC.
>>
>> Has anyone used BMC and experienced the same issues? know of the
>> workarounds?
>>
>> Thanks in advance all!
>> -ck
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 02 2014 - 22:05:01 CEST