|
You could try specifying
the host and sid in the connect string.
That way you only need
ORACLE_HOME defined, nothing else.
Something like
this:
my $dsn =
'dbi:Oracle:host=grill-name;sid=pork-roast;port=1525';
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?
Thanks for any help.
Malka Cymbalista
Webmaster, Weizmann Institute of
Science
suppressed
08-934-3036 CONFIDENTIALITY NOTICE This e-mail and any files or attachments may contain confidential and privileged information.
If you have received this message in error, please notify the sender at the above e-mail address and delete it and
all copies from your system.
|