Connecting to more than one oracle database
- From: Malki.Cymbalista@xxxxxxxxxxxxxx (Malka Cymbalista)
- Date: Wed, 29 Nov 2006 10:28:05 +0200
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
malki.cymbalista@xxxxxxxxxxxxxx
08-934-3036
- Follow-Ups:
- Test Message
- From: Will Rutherdale
- RE: Connecting to more than one oracle database
- From: Ray Barksdale
- Test Message
- Prev by Date: Re: DBD Oracle: multiple statements in a single execute?
- Next by Date: MySQL do() memory leak?
- Previous by thread: Not receiving any errors back from DBD::ODBC::VERSION 1.13
- Next by thread: RE: Connecting to more than one oracle database
- Index(es):
Relevant Pages
|
|
