Hi Sanjay
You should be able to change your host ip to the vip ip for
the service associate with the database you are connecting to
and the sid the that service. You would in theory have then failover for
your script, it wont matter which instance of your cluster is
up.
Cheers
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 on your site using
Yahoo!
Search Marketing.
