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';
________________________________ From: Malka Cymbalista [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 2:28 AM To: modperl@perl.apache.org; dbi-users@perl.org Subject: Connecting to more than one oracle database 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 [EMAIL PROTECTED] 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.