Hi,
This is not dbi related error or issue. But if you look at the error
given:
Could not find gdlib-config in the search path. Please install libgd
2.0.28 or higher.
It tells you that you need to install this package/library. It can't find
the gdlib-config file that is part of the libgd
is oracle libraries and installation really in /app/oracle/client/jdk/jre?
oracle library is needed for DBD-Oracle. Oracle binary is not the same as
the Java from oracle. Just making sure you were not confusing the 2.
Michael
On Thu, 12 Sep 2013, Manimegalai Visvanathan wrote:
Date: Thu,
wrote:
Date: Fri, 13 Sep 2013 12:34:53 -0700
From: Manimegalai Visvanathan
To: 'Michael Nhan'
Cc: "'dbi-users@perl.org'"
Subject: RE: DBD::Oracle installation on AIX
Hi Michael,
Thanks for your reply :)
Can you please let me know, which path I have to export t
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database
A simple "select database();" returns the current active database.
Does that not do what you want?
michael
On Mon, 22 Oct 2012, Meir Guttman wrote:
Date: Mon, 22 Oct 2012 19:19:24 +0200
From: Meir Guttman
On Fri, 3 Aug 2012, Don Walters wrote:
Date: Fri, 3 Aug 2012 10:34:42 -0500
From: Don Walters
To: dbi-users@perl.org
Subject: Re: Problems installing DBI on AIX5
I don't have an AIX box turned on right now but xlc must support -c (it
means compile but do not link). What does perl -V output? D
Can you run make and post the result of that?
Michael
kiran,
Sounds like a permission issue with the oracle library. Make sure the
library is accessible by the user running the script. Make sure the
directory where the library resides and the library itself is accessible
by the user. make sure the LD_LIRARY_PATH contains the path the library
Get a new version of DBI from cpan, then compile it and install. it
should overwrite and update the version that is installed.
On Mon, 10 Oct 2011, Zhao, Yanhong wrote:
Date: Mon, 10 Oct 2011 09:32:54 -0400
From: "Zhao, Yanhong"
To: dbi-users@perl.org
Subject: How to uninstall DBI
Hi, All
Hi,
You are trying to build 32bit application on a 64bit osx. You will need
to tell both the compiler and the linker that you want to build 32bit
apps. Gcc is easy enough with the -m32 flag. ld is a little trickier.
On linux, I have to link using "ld -melf_i386" instead of plain ld. Run
Hi,
Yes. Its in the DBI docs.
Michael
On Thu, 6 May 2010, Bruce Johnson wrote:
Date: Thu, 6 May 2010 11:30:59 -0700
From: Bruce Johnson
To: DBI Users Mailing List
Subject: Stupid Oracle question
If $dbh is my database handle, to roll back the current transaction I do:
$dbh->rollback(); r
Hi,
DBI-1.605 was the last version not to require perl 5.8. Even though the
Readme doesn't state it, version 1.606 and newer requires 5.8.10 in the
Makefile.PL and will not let you create a makefile without some editing of
the Makefile.PL to ignore that requirement.
Regards,
Michael
Hi,
The ORA-03113 is most likely not cause by dbi/dbd-oracle directly. But
what is causing the ORA-03113 needs to be tracked down and that will need
you to do some tests. First lets see if this error occurs for all clob
columns in the oracle-11 rac database. Create a simple table with a
si
Hi,
What version of the client are you using and what version of DBD::Oracle
are you using? What is the version of your oracle rac db? I've no problem
inserting your text string into a simple table with a clob field in my 2
node rac instance.
Michael
On Wed, 3 Feb 2010, Lopez Mariz, Luis F
Hi,
Try setting your LD_LIBRARY_PATH to include the OH/lib or add the OH/lib
to the ld.so.conf of your machine.
Can't load
'/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/O
ra cle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot
open shared object file: No suc
Hi,
What did you set as ORACLE_HOME and LD_LIBRARY_PATH during your
compilation? Did you not do a make test? Where did you install the full
oracle client (oracle_home setting)? Is the
ORACLE_HOME/lib/libclntsh.so.10.1 read-able by the user running the
script?
Michael
On Tue, 22 Sep 20
Hi,
Could you be running into bug 5254759 slated to be fixed in 11i?
Regards,
Michael
Date: Wed, 31 Jan 2007 15:45:43 -0700
From: "Reidy, Ron" <[EMAIL PROTECTED]>
To: Andrew McFarlane <[EMAIL PROTECTED]>, dbi-users@perl.org
Subject: RE: :Oracle, cursor_sharing, and ORA-01008
Well, first o
Tri" <[EMAIL PROTECTED]>
To: Michael Nhan <[EMAIL PROTECTED]>
Cc: dbi-users@perl.org, "Rahrig, Robert" <[EMAIL PROTECTED]>,
Unix Sys Admin <[EMAIL PROTECTED]>
Subject: RE: DBD::Oracle-1.19 installation errors
Michael,
Thank you for your respond. My DBA
Hi,
Speak with your dba and ask to he/she to grant the user you are using in
the db permission to select on v$session.
Regards,
Michael
Date: Mon, 29 Jan 2007 16:13:04 -0500
From: "Pham, Tri" <[EMAIL PROTECTED]>
To: dbi-users@perl.org
Cc: "Rahrig, Robert" <[EMAIL PROTECTED]>,
Unix Sys A
Date: Tue, 23 Jan 2007 02:10:30 -
From: Nancy Ni <[EMAIL PROTECTED]>
To: Michael Nhan <[EMAIL PROTECTED]>
Cc: dbi-users@perl.org
Subject: RE: about dbi building error.
If my unix system currently uses gcc to compile c program,then what
should I do without installing a new sun compil
Hi,
If you choose to use the sun compilers to compile DBI, you must
install the sun compilers. Sun does not come with the compilers
preinstalled. That's why you are getting "/usr/ucb/cc: language
optional software package not installed". Have your sys-admin install the
Forte CC compilers
Hi,
Connecting to rac is the same as connecting to any normal oracle database.
It still uses the tnanames aliases. With the tnsnames.ora file for a rac
database, you can specify if the alias is to connect to specific node or
use the service and allow for the listener to connect you to a rando
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
From
Hi,
Note:340091.1 may be of interest to you concerning listener hanging on
10g.
Regards,
Michael
Date: Tue, 25 Apr 2006 15:19:27 -0600
From: "Reidy, Ron" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], dbi-users@perl.org
Subject: RE: Oracle connect hangs forever
Get a 10046 trace of the proces
print $DBI::VERSION,"\n";
Date: Wed, 05 Apr 2006 13:43:30 -0700
From: Jie Zhang <[EMAIL PROTECTED]>
To: dbi-users@perl.org
Subject: DBI versiion
Hi,
We're using oracle 8 and 9. I have code running on different machines. One
machine comes out different warnings as the other. I want to che
Hi,
Look into Toad by quest software. It has a schema comparison tool.
Regards,
Michael
Date: Thu, 16 Jun 2005 11:11:12 -0400
From: Steve Sapovits <[EMAIL PROTECTED]>
To: dbi-users@perl.org
Subject: Oracle schema comparison
Does anybody know of any good tools (free or otherwise) for compari
No issues. We are using oracle 9i and 10g rac with dbi on sparc solaris
and linux respectively.
Date: Thu, 26 May 2005 12:09:36 -0400
From: Steve Sapovits <[EMAIL PROTECTED]>
To: dbi-users@perl.org
Subject: Oracle 9i RAC on Linux
Has anyone used DBI in an Oracle 9i RAC configuration on Linu
Divya,
Here are some of the statistics :
a) We are using Oracle 8i DB. The query (or the DBMS) takes only 6 seconds
to return data to Perl.
So the query execution takes 6 seconds... How long does it take to get
all the rows back in sqlplus (I mean how long does it take for sqlplus to get
all 20K
Lalitha,
My problem is:
To install perl it is asking cc
The perl source requires a compiler not necessarily cc. Install gcc. Put
the path to gcc before the path to /usr/ucb/cc. When you run configure
within in the perl source, it should detect you have gcc and use it.
I downloaded gcc from fr
own perl using gcc.
Regards,
Michael
Date: Wed, 27 Apr 2005 16:06:18 -0400
From: "Chekuri, Lalitha" <[EMAIL PROTECTED]>
To: "Reidy, Ron" <[EMAIL PROTECTED]>,
Michael Nhan <[EMAIL PROTECTED]>
Cc: dbi-users@perl.org
Subject: RE: Can't locate DBI.pm
Hi r
Are you sure this is the perl where DBI is installed. If you reinstall
solaris 9, the prebuilt perl on the box from the install will not have the
DBI and DBD-Oracle installed. You will need to compile these yourself.
Date: Tue, 26 Apr
2005 12:10:21 -0400
From: "Chekuri, Lalitha" <[EMAIL PROT
Okay, does your oracle client work? Can you connect to the oracle server
using the sqlplus with your present client install?
Date: Tue, 19 Apr 2005 16:40:43 -0500
From: Hemanth Kumar <[EMAIL PROTECTED]>
To: Michael Nhan <[EMAIL PROTECTED]>
Cc: dbi-users@perl.org
Subject: RE: :Or
just make a link from libclntsh.so.9.0 to libclntsh.so (ln -s
libclntsh.so.9.0 libclntsh.so)
Date: Tue, 19 Apr 2005 16:36:16 -0500
From: Hemanth Kumar <[EMAIL PROTECTED]>
To: Michael Nhan <[EMAIL PROTECTED]>
Cc: dbi-users@perl.org, [EMAIL PROTECTED]
Subject: RE: :Oracle instal
include oracle_home/lib in your ld_library_path
Date: Tue, 19 Apr 2005 13:14:34 -0500
From: Hemanth Kumar <[EMAIL PROTECTED]>
To: Hemanth Kumar <[EMAIL PROTECTED]>, dbi-users@perl.org
Subject: RE: :Oracle install problem On Solaris 8
I was able to remove those errors by installing OCI libraries bu
escape the @,
my $r=system("exp file=users.dmp transport_tablespace=y tablespace=users
userid=\'sys/[EMAIL PROTECTED] as sysdba\'");
> Date: Mon, 28 Feb 2005 18:05:59 -0500
> From: Tiffany Thang <[EMAIL PROTECTED]>
> To: dbi-users@perl.org
> Subject: running Oracle export in perl
>
> Hi,
> The f
Hi,
Does the webuser have these configure (apache.conf with env?)? If
not then the web account(nobody) may not have these env setup.
Michael
> Date: Mon, 7 Feb 2005 10:55:12 -0800
> From: Juan Jose Natera <[EMAIL PROTECTED]>
> To: "Reidy, Ron" <[EMAIL PROTECTED]>
> Cc: DBI Users
> Subj
Are you closing your cursor once they are no longer needed? What do you
have set in terms of cursor sharing?
Michael
> Date: Wed, 17 Nov 2004 15:38:59 -0700
> From: "Reidy, Ron" <[EMAIL PROTECTED]>
> To: Giovanni Borri <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: :Oracle question
>
> W
Hi,
You may need to set the timezone as its not set on Winnt by
default. Open the properties of "My Computer" and set a SYSTEM variable
TZ to your timezone. Use the form "EST5EDT" so you don't have to change
it every 6 months when going to or from daylight saving. Its in the
perldoc of
Hi,
Its the mydoom virus. Its running rampant all over the net. Best not to
open and spread it.
Cheers,
Michael
> Date: Thu, 29 Jan 2004 11:17:20 -0500
> From: Hardy Merrill <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: Hello
>
> Just checking - is everyone els
Hi,
>
> I have two versions of Oracle, 8i and 9i, on one UNIX server. How do I get DBI to
> use both?
DBD-Oracle links against which ever version of oracle was set at compile
time. It needs those libraries to function. You should be able to
connect to both your oracle 8 and oracle 9 instances
> Date: Fri, 2 Jan 2004 12:22:19 -0500
> From: Hariharan <[EMAIL PROTECTED]>
> To: Michael Nhan <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: RE: Help Needed: DBI (no error string)
>
> Hi,
> Thanks for reply. Swap space of the machine that i am runnin
Hi,
> string), when i enable DBI->trace i get that it is majorly due to 3113
> error.
When you get the ORA-3113 error, can you connect via sqlplus or any other
client programs? Check to see if you have enough swap space, sometime
when you run out of swap you will get ORA-3113 and will not be able
Hi,
--->Snip<
>
> -L/appora/oracle/product/9.2/rdbms/lib32/ -L/appora/oracle/produ
> ct/9.2/lib32/ /appora/oracle/product/9.2/lib32 -lclntsh -lnbeq9
^
|
Appears you left out a parameter of -R here. Thus the error
that is reported about this being unknown.
>
What about exp/imp?
> Date: Wed, 17 Dec 2003 09:07:01 +1100
> From: Steve Baldwin <[EMAIL PROTECTED]>
> To: 'Ian Harisay' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: Refreshing a database from another
>
> Would standard Oracle replication not do it for you ?
>
> -Original Message---
Hi,
Are you sure the the oracle client library is readable/accessible
by the web user or by user nobody? The error you were getting seems to
suggest that it could not load the shared library libclnt... Two things
can cause this, 1) ld_library_path does not include $oracle_home/lib
(locati
> In fact Tim
> Bunce suggested setting LD_LIBRARY_PATH in the apache
> configuration - I don't know how to do that.
>
in the httpd.conf
SetEnv LD_LIBRARY_PATH blah:blah
Cheers,
Michael
Hi,
Can you post how you used to connect and the error you are getting?
Michael
> Date: Sun, 21 Sep 2003 18:54:54 +0300
> From: John <[EMAIL PROTECTED]>
> To: DBI-Users <[EMAIL PROTECTED]>
> Subject: Reinstallation problems (Oracle 9.2.0.1)
>
> I uninstalled the Oracle 9i and partitioned my hard
I don't think you should be calling finish before fetching. I think
that is the problem here.
Michael
> Date: Wed, 3 Sep 2003 12:01:03 -0500
> From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: fetch( ) without execute( ) Error...
>
>
Hi,
Try this:
my $dbuser="sys/change_on_install\@tnsalias";
my $dbh=DBI->connect('',$dbuser,'','Oracle',{AutoCommit => 0,RaiseError
=>0,ora_session_mode =>2});
see perldoc of DBD::Oracle for ora_session_modes.
Regards,
Michael
> Date: Wed, 12 Feb 2003 10:24:49 -0800
> From: Eddie Bradford <[E
Hi,
Is $Table defined before the prepare is executed? I've used group
by in perl without issues. The error returned is complaining about a
missing table name, so I can only conclude that $Table is either blank or
undef when the prepare statement is executed by perl.
Regards,
Mi
Hi,
http://www.rosat.mpe-garching.mpg.de/mailing-lists/dbi/
has a nice searchable archive for the DBI mailing list. Can you also post
the errors you are getting from the web page and from the error logs of
the webserver, they will allow people to assist you better on the list.
Cheers,
Michael
Perl and DBI are open source. Its free, if you don't like it don't use
it. With that said. Its not difficulty to build your own perl. If
you're going to use sun's precompiled perl then you are going to need
sun's CC unless you know how to edit Makefiles to accomodate gcc (which is
free and the
Hi,
I believe the syntax is:
set transaction use rollback segment ;
>
> The statement for assigning a rollback segment (ALTER SESSION, I think) is
> Oracle SQL. You can execute it with prepare()/execute() or do() just like
> any other non-SELECT statement.
>
> Be aware that COMMIT rel
Hi,
> I am having the same problem when I tried to run "make" on DBI-1.21
>
>
> DBI_NO_THREADS Perl.c
> sh: cc: not found
You need a c compiler (gcc or cc) or put path to the compiler into your
path. It can't locate your compiler.
> *** Error code 1
> make: Fatal error: Command failed for t
Hi,
This looks like bug#1112313. See oracle for a patch. If you
search metalink you will find others who've encounter this bug. You may
need to get a patch.
Michael
bug#1112313 WHEN PROC APLICATION IS EXCUTED ,ORA-1801 OCCURS.
> The important variables are set:
> $dbh->{LongRea
Hi,
Install the oracle client on machine B and compile/install the
DBD-Oracle module. You don't need to have a database or all the software
on Machine B but you do need the client software to talk to Oracle. If
you search the list archive, you can find out a list of files you need to
ha
Hi,
Please read the documentation on DBD-Oracle. To execute a stored
procedure do the following:
$sth=$dbh->prepare(q{
BEGIN
syn_act_uso;
END;
});
Michael
On Tue, 12 Jun 2001, Xiaoping Gu wrote:
> Date: Tue, 12 Jun 2001 09:55:42 -0400
> From: Xiaoping Gu <[EMAIL PRO
Is that the
> problem?
>
> Regards,
> Prem
>
>
>
>
> -Original Message-
> From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2001 9:29 AM
> To: Michael Nhan; [EMAIL PROTECTED]
> Subject: Re: Slow execution
>
>
> Actually th
Hi,
Okay, I've attempted to debug this to no-avail on my own so I'm would
really appreciate some help. Here is my setup..
Oracle-client: 8.1.6 (full install minus database)
Perl: 5.6.1 with threading
OS: Solaris 2.7 sparc
DBI: 1.16
DBD: Oracle 1.06
perl -V:
Summary of my perl5 (revision 5.0 v
58 matches
Mail list logo