private DBD::Oracle?
From: Christian Merz (christian.merz_at_muenchen.de)
Date: 03/23/05
- Next message: Chris Masters: "Re: hang with mysql in execute"
- Previous message: Graeme St. Clair: "RE: DBI->Connect returning UNDEF in cgi but not in standalone pro g"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: <dbi-users@perl.org> Date: Wed, 23 Mar 2005 08:09:15 +0100
Hello all,
I am still having problems to 'connect internal' when there are different
$ORACLE_HOMEs owned by different $ORACLE_OWNERs.
For example (SunOS sap09 5.7 Generic_106541-32 sun4us sparc FJSV,GPUSK):
user1: /oracle/elearn/app/oracle/product/9.2.0_32
user2: /oracle/S13/817_64
(On another host I managed to 'connect sys/pass as sysdba' when there is only
one $ORACLE_OWNER. But this is a 'sub optimal' solution as I do not want to hard
code user/pass in my scripts and this does not work with different
$ORACLE_OWNERs. So...)
Now I am planning to install a 'private DBD::Oracle' but I do not know how to
perform this.
I need somthing like:
installation:
$DEST1='/oracle/DBD_SID1';
$DEST2='/oracle/DBD_SID2';
as owner1: ...; make install $DEST1
as owner2: ...; make install $DEST2
usage:
...
use DBI;
unshift @INC, $DEST1;
my $connect_mode = 2; # 2=SYSDBA
my $dbh = DBI->connect( 'dbi:Oracle:','', '',
{ ora_session_mode => $connect_mode,
PrintError => 0, AutoCommit => 0 } )
or die "cannot connect.\n$DBI::errstr";
Can anybody help me? Hint to doc?
TIA,
Christian
- Next message: Chris Masters: "Re: hang with mysql in execute"
- Previous message: Graeme St. Clair: "RE: DBI->Connect returning UNDEF in cgi but not in standalone pro g"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
