Re: Perl DBI connection with RAC environment

  • From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Wed, 4 Apr 2007 21:37:21 -0400

Sanjay

You should use the vip address and associated service name.

Rajeev


On 4/4/07, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:

Hi

I had single instance Oracle 8i Database earlier and now new environment
is created with Oracle 10g RAC. There are several perl program been used to
perform some application and I appreciate if somebody can guide as how to
make changes in string

Existing String is like
 unless ($san_db = DBI->connect("dbi:Oracle:host=192.168.111.111
;sid=sandb",
        "scott", "tiger", {LongReadLen => 8000, AutoCommit => 0})) {
...
I have two RAC node sandb1 and sandb2

Thanks
Sanjay



 ------------------------------
The fish are biting.
Get more 
visitors<http://us.rd.yahoo.com/evt=49679/*http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php?o=US2140&cmp=Yahoo&ctv=Q107Tagline&s=Y&s2=EM&b=50>on
 your site using Yahoo!
Search Marketing.


Other related posts: