Malka Cymbalista wrote:
> I am running Apache 2.0.55 with mod_perl 2.0.1 and Perl 5.8.1 on a Sun
> Solaris machine. I am using DBI/DBD to connect to an Oracle database.
> I am running DBI 1.39 and DBD-Oracle 1.16.
>
> In order to connect to an oracle database on a different machine I
> have a tnsnames.ora file with the appropriate definition. I also have
> a file startup.pl with the following information:
> $ENV{ORACLE_HOME} = '/usr/local/ora9i/9.2.0';
> $ENV{ORACLE_SID} = 'asdb';
> $ENV{TWO_TASK} = 'asdb';
> $ENV{TNS_ADMIN} = '/usr/local/ora9i/9.2.0/network/admin/DEV_wiccdb';
> In httpd.conf I have the line
> PerlRequire "/www/httpd/conf/startup.pl"
>
> I am currently connecting to an oracle database on a different machine
> and everything is working fine. I would now like to connect to
> another oracle database on another machine. My problem is how to
> define my environment variables. ORACLE_HOME and TNS_ADMIN do not
> seem to be a problem since I assume they can be the same. However,
> how do I define ORACLE_SID and TWO_TASK so that they allow connecting
> to 2 different databases on 2 different machines?
TWO_TASK and ORACLE_SID are defaults, and are not necessary if you can
specify the database name when you connect. Since you're using TNS, you
can just reference the TNS names in your connect string, e.g.:
my ($db,$user,$pass);
($db,$user,$pass) = ('asdb','user','pass');
my $dbh_1 = DBI->connect("dbi:Oracle:$db",$user,$pass)
|| die "can't connect: $DBI::errstr";
($db,$user,$pass) = ('other_db','user','pass');
my $dbh_2 = DBI->connect("dbi:Oracle:$db",$user,$pass)
|| die "can't connect: $DBI::errstr";
Regards,
Philip
