Well you DBI is about 55+ updates behind and your DBD::Oracle is about 13
behind.
I would say update both.
The error below is telling my you are still using a very old way to connect to
Oracle which I think has been dropped in 11+ and dropped from DBD::Oracle in I
think 1.11
hope this
It would help if you could include os type. But to answer your question
1) no, but it helps when troubleshooting. Usually if sqlplus works, then
you know that the client libraries/software and connnectivity is good.
2) depends on the os of choice.
Date: Fri, 7 Jul 2006
15:50:41 +0100
[EMAIL PROTECTED] wrote:
Guys,
Can anyone answer following questions please
1) Do I have to install sqlplus to connect to Oracle database from
Perl
No, but it typically comes with the files that you DO need (the Oracle
client). Google oracle instantclient
2) What , how and where can I
SQL*Plus is not required to connect from Perl, unless you would like to
run SQL*Plus as a piped process or with expect from within Perl.
You will need to (at a minimum) install an Oracle client on the machine
running the Perl scripts, along with the DBI and DBD::Oracle modules.
The README files
On Thu, Mar 18, 2004 at 11:37:52AM +0200, John wrote:
How to get connected to an oracle server with not listener?
These should work.
$dbh = DBI-connect('dbi:Oracle:SID', ...)
$dbh = DBI-connect('dbi:Oracle:', ...); # uses ORACLE_SID env var
Tim.
Which one is the correct?
Subject: RE: Connecting to Oracle 9i with no listener
Just out of curiosity why do you not want to use the listener?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Friday, March 19, 2004 7:44 AM
To: John
Cc: DBI-Users
Subject: Re: Connecting to Oracle 9i
But beware that setting ORACLE_HOME to a different version to the one
that's supplying the Oracle client library (via LD_LIBRARY_PATH etc)
is likely to cause problems, like not being able to get the text of an
error message, or worse.
Tim.
On Wed, Sep 18, 2002 at 01:28:20PM -0400, [EMAIL
I am pretty sure this is supposed to reside in /etc. I know that on
our HP-UX boxes the tnsnames.ora is in /etc and we use Perl for some
database access.
-Original Message-
From: Sridhar Saragu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:24 AM
To: [EMAIL
on the Tru64 unix box we are using it is found at :
/usr/app/oracle/product/7.3.4/network/admin/tnsnames.ora
hope this helps
cheers
Edd
Sridhar Saragu [EMAIL PROTECTED] 09/18/02 14:21 PM
Hi,
Can somebody tell me where the Perl exactly look for tnsnames.ora while
connecting to Oracle ?
The Oracle client looks for tnsnames.ora in the
$ORACLE_HOME/network/admin directory. We typically set the Perl
variable $ENV{ORACLE_HOME} to the location of the Oracle installation in
our database connection modules prior to any attempt to open a database
connection.
-dpf-
On Wed, Sep 18, 2002 at 06:54:13PM +0530, Sridhar Saragu wrote:
Hi,
Can somebody tell me where the Perl exactly look for tnsnames.ora while
connecting to Oracle ? (like home, oracle_home, tns_admin etc ...). I want
to
know the order in which it looks the directories ?
To quote
What error did the DBI give you ($DBI::errstr that you are outputting to
STDOUT)? Also use DBI-trace(2, "filename") and then look in the "filename"
file for the trace of the process. Send that file in if you can't see the
problem.
Ilya Sterin
-Original Message-
From: Mitch Clarvit
To:
12 matches
Mail list logo
