Oracle TAF with DBD::Oracle???

Hello @all,

can someone help me with my Oracle TAF Problem?

I'm trying to write an DBI script, that should use Failover (Oracles TAF).
But I can't connect to the "SERVICE_NAME", when I used the "INSTANCE_NAME" the
connect works fine.

Is there a way to use DBI/DBD::Oracle with TAF?

Thanks for any hints....

Greetings from germany

Andre


Won't work:
my $dbh = DBI->connect("dbi:Oracle:LIPROD02",'user','pass',
{RaiseError => 1, AutoCommit => 1 })
or die "$DBI::errstr";

Works fine:
my $dbh = DBI->connect("dbi:Oracle:LIPROD021",'user','pass',
{RaiseError => 1, AutoCommit => 1 })
or die "$DBI::errstr";


----------------------------------tnsnames.ora-------------- ---------------------------


LIPROD02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999))
(LOAD_BALANCE = yes)
(FAILOVER=on)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = liprod02)
)
)

LIPROD021 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = liprod02)
(INSTANCE_NAME = liprod021)
)
)

LIPROD022 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = liprod02)
(INSTANCE_NAME = liprod022)
)
)

RE: Oracle TAF with DBD::Oracle???

Andre,

Can you tnsping liprod02? Can you connect to liprod02 via SQL*Plus?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Andre Heine [mailto:andre@netdynamite.de]=20
Sent: Thursday, September 07, 2006 10:09 AM
To: dbi-users@perl.org
Subject: Oracle TAF with DBD::Oracle???

Hello @all,

can someone help me with my Oracle TAF Problem?

I'm trying to write an DBI script, that should use Failover (Oracles
TAF).
But I can't connect to the "SERVICE_NAME", when I used the
"INSTANCE_NAME" the=20
connect works fine.

Is there a way to use DBI/DBD::Oracle with TAF?

Thanks for any hints....

Greetings from germany

Andre

=20
Won't work:
my $dbh =3D DBI->connect("dbi:Oracle:LIPROD02",'user','pass',
{RaiseError =3D> 1, AutoCommit =
=3D>
1 }) =20
or die "$DBI::errstr";

Works fine:
my $dbh =3D DBI->connect("dbi:Oracle:LIPROD021",'user','pass',
{RaiseError =3D> 1, AutoCommit =
=3D>
1 }) =20
or die "$DBI::errstr";


----------------------------------tnsnames.ora-------------- ------------
---------------


LIPROD02 =3D
(DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 10.16.9.60)(PORT =3D 9999))
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 10.16.9.59)(PORT =3D 9999))
(LOAD_BALANCE =3D yes)
(FAILOVER=3Don)
(CONNECT_DATA =3D
(SERVER =3D DEDICATED)
(SERVICE_NAME =3D liprod02)
)
)

LIPROD021 =3D
(DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 10.16.9.60)(PORT =3D 9999))
(CONNECT_DATA =3D
(SERVER =3D DEDICATED)
(SERVICE_NAME =3D liprod02)
(INSTANCE_NAME =3D liprod021)
)
)

LIPROD022 =3D
(DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 10.16.9.59)(PORT =3D 9999))
(CONNECT_DATA =3D
(SERVER =3D DEDICATED)
(SERVICE_NAME =3D liprod02)
(INSTANCE_NAME =3D liprod022)
)
)

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Re: Oracle TAF with DBD::Oracle???

Hi Ron,

Am Donnerstag, 7. September 2006 18:14 schrieb Reidy, Ron:
> Can you tnsping liprod02? Can you connect to liprod02 via SQL*Plus?

tnsping works:

But sqlplus won't work with "liprod02", "liprod021/liprod022" works.

Is there a mistake in my tnsnames.ora???



--------- tnsping --------------

monk@monk:~> tnsping liprod02

TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 07-SEP-2006
18:21:46

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.1.0/10gclient/network/admin/sqlnet.or a


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
10.16.9.60)(PORT = 9999)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT
= 9999)) (LOAD_BALANCE = yes) (FAILOVER=on) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = liprod02)))
OK (20 msec)

Re: Oracle TAF with DBD::Oracle???

Hi Ron,

I've some strange effects with connecting to the SERVICE_NAME.

Sometimes (every 4-5 try) I can connect with sqlplus to liprod02...

The same with DBI!!!

I don't know about it;(

Thanks for your help!

Greetings from germany...

Andre

Am Donnerstag, 7. September 2006 18:14 schrieb Reidy, Ron:
> Andre,
>
> Can you tnsping liprod02? Can you connect to liprod02 via SQL*Plus?
>
> --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
> -----Original Message-----
> From: Andre Heine [mailto:andre@netdynamite.de]
> Sent: Thursday, September 07, 2006 10:09 AM
> To: dbi-users@perl.org
> Subject: Oracle TAF with DBD::Oracle???
>
> Hello @all,
>
> can someone help me with my Oracle TAF Problem?
>
> I'm trying to write an DBI script, that should use Failover (Oracles
> TAF).
> But I can't connect to the "SERVICE_NAME", when I used the
> "INSTANCE_NAME" the
> connect works fine.
>
> Is there a way to use DBI/DBD::Oracle with TAF?
>
> Thanks for any hints....
>
> Greetings from germany
>
> Andre
>
>
> Won't work:
> my $dbh = DBI->connect("dbi:Oracle:LIPROD02",'user','pass',
> {RaiseError => 1, AutoCommit =>
> 1 })
> or die "$DBI::errstr";
>
> Works fine:
> my $dbh = DBI->connect("dbi:Oracle:LIPROD021",'user','pass',
> {RaiseError => 1, AutoCommit =>
> 1 })
> or die "$DBI::errstr";
>
>
> ----------------------------------tnsnames.ora-------------- ------------
> ---------------
>
>
> LIPROD02 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999))
> (LOAD_BALANCE = yes)
> (FAILOVER=on)
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = liprod02)
> )
> )
>
> LIPROD021 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = liprod02)
> (INSTANCE_NAME = liprod021)
> )
> )
>
> LIPROD022 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = liprod02)
> (INSTANCE_NAME = liprod022)
> )
> )
>
> This electronic message transmission is a PRIVATE communication which
> contains information which may be confidential or privileged. The
> information is intended to be for the use of the individual or entity named
> above. If you are not the intended recipient, please be aware that any
> disclosure, copying, distribution or use of the contents of this
> information is prohibited. Please notify the sender of the delivery error
> by replying to this message, or notify us by telephone (877-633-2436, ext.
> 0), and then delete it from your system.

Re: Oracle TAF with DBD::Oracle???

No I do not think there is TAF support.

It is on the wishlist of things to add after we get exeecute_array working
correctly

Main problem I see is that somthing very Oracle like TAF is outside the
scope of DBI

cheers

----- Original Message -----
From: "Andre Heine"
To:
Sent: Thursday, September 07, 2006 12:08 PM
Subject: Oracle TAF with DBD::Oracle???


> Hello @all,
>
> can someone help me with my Oracle TAF Problem?
>
> I'm trying to write an DBI script, that should use Failover (Oracles TAF).
> But I can't connect to the "SERVICE_NAME", when I used the "INSTANCE_NAME"
> the
> connect works fine.
>
> Is there a way to use DBI/DBD::Oracle with TAF?
>
> Thanks for any hints....
>
> Greetings from germany
>
> Andre
>
>
> Won't work:
> my $dbh = DBI->connect("dbi:Oracle:LIPROD02",'user','pass',
> {RaiseError => 1, AutoCommit =>
> 1 })
> or die "$DBI::errstr";
>
> Works fine:
> my $dbh = DBI->connect("dbi:Oracle:LIPROD021",'user','pass',
> {RaiseError => 1, AutoCommit =>
> 1 })
> or die "$DBI::errstr";
>
>
> ----------------------------------tnsnames.ora-------------- ---------------------------
>
>
> LIPROD02 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999))
> (LOAD_BALANCE = yes)
> (FAILOVER=on)
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = liprod02)
> )
> )
>
> LIPROD021 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = liprod02)
> (INSTANCE_NAME = liprod021)
> )
> )
>
> LIPROD022 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = liprod02)
> (INSTANCE_NAME = liprod022)
> )
> )
>