Hi Mats,
I'm using ojdbc14.jar, connecting to a dual node 11gr2 RAC setup using
SCAN and I haven't had any issues (except for the maxconnections which
is fixed in the latest nightly build). We have a dataguard failover
setup as well, here is my connection string:
<cfset ds = {
username : "myapp",
password : "xxxxxxxxxx",
databasename : "prod_db",
logintimeout : "5",
connectiontimeout : "5",
connectionretries : "2",
maxconnections : "20",
drivername : "oracle.jdbc.OracleDriver",
hoststring : "jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=prodscan.local)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=dataguard.local)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=myrac)))"}>
<cfset DataSourceCreate( "prod_db", ds )>
This is currently in a production environment under VERY extreme load.
Hope that helps,
-chris
On Jun 4, 2:50 am, Mats Stromberg <[email protected]> wrote:
> Has anyone run into a problem connecting to an Oracle RAC with the new
> ojdbc6.jar and connect using Single Client Access Name (SCAN) on a 11gR2 ?
> I'm running into a strange problem that I'm getting an ORA-17002 error " Io
> exception: The Network Adapter could not establish the connection".
> I'm using this feature now in OTR which connects every 5 minutes to the
> Target DB's and for the RAC's I connect using SCAN and the service_name.
>
> The weird thing is that I only get this 17002 error every now and then...
> like once an Hour or so.
>
> Been searching Metalink, (Yes still using the term Metalink!!! :) hate the
> screwed up My Oracle Support eventhough they finally removed the Flash
> rubbish), but can't find any notes regarding this behaviour.
>
> In my test setup I have a 3 Node Cluster running an 11.2.0.3 Cluster.
>
> So, just wanted to make sure it's not an OpenBD Issue before I will open an
> SR at Oracle...
>
> /Mats/
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
