Re: Oracle connection issue with perl DBI
- From: jdg117@xxxxxxxxxxxxxxxxxxx (John D Groenveld)
- Date: Wed, 19 Dec 2007 14:02:02 -0500
In message <ff34489d0712190700r4a387567y6e61f4f61bfaac3@xxxxxxxxxxxxxx>, "Kumar
Ranjan" writes:
I am facing a funny but troubling issue with Perl DBI & Oracle.
When my shell environment does not have ORACLE_HOME path set, my script
works fine. I am connecting
to Oracle DB like this:
#!/usr/bin/perl -w
use strict;
use DBI;
my $dbh = DBI->connect("dbi:Oracle:host=xx.gold.com;port=1522;sid=sid",
$eusr, $epas,{RaiseError => 1, AutoCommit => 1})
die "Can not connect : $DBI->errstr ";
Now,
set the ORACLE_PATH to /opt/bin/oracle/9.2.0.8
and I do try to connect but it complains that it can not connect.
Is /opt/bin/oracle/9.2.0.8 the same ORACLE_HOME you used to build
DBD::Oracle?
It must be.
Do these commands work from the shell?
$ env ORACLE_HOME=/opt/bin/oracle/9.2.0.8 /opt/bin/oracle/9.2.0.8/bin/tnsping
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.gold.com)(PORT=1522))(CONNECT_DATA=(SID=sid)))'
$ env ORACLE_HOME=/opt/bin/oracle/9.2.0.8 /opt/bin/oracle/9.2.0.8/bin/sqlplus euser/epas@'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.gold.com)(PORT=1522))(CONNECT_DATA=(SID=sid)))'
If not, contact your DBA.
John
groenveld@xxxxxxx
.
- References:
- Oracle connection issue with perl DBI
- From: Kumar Ranjan
- Oracle connection issue with perl DBI
- Prev by Date: Re: ORA-01406 from a perl script using DBI package
- Next by Date: Can't locate DBD/Oracle.pm after DBD Oracle 1.19 installation
- Previous by thread: Oracle connection issue with perl DBI
- Next by thread: Can't locate DBD/Oracle.pm after DBD Oracle 1.19 installation
- Index(es):
Relevant Pages
|
