RE: Migration from Oracle 9i to Oracle 11g

2010-02-24 Thread John Scoles
ibc.ca > Subject: Migration from Oracle 9i to Oracle 11g > Date: Tue, 23 Feb 2010 10:38:17 -0800 > > Dear Experts, > I have a Perl application which works fine at Solaris UNIX box with > Perl 5.6.1 and the Oracle 9i database. Now our team is moving to the > Oracle 11g database and

Re: Migration from Oracle 9i to Oracle 11g

2010-02-24 Thread listmail
Serguei wrote: Dear Experts, I have a Perl application which works fine at Solaris UNIX box with Perl 5.6.1 and the Oracle 9i database. Now our team is moving to the Oracle 11g database and I have a problem. I changed $PATH, $ORACLE_HOME and $LD_LIBRARY_PATH variables to point to new Oracle

Migration from Oracle 9i to Oracle 11g

2010-02-24 Thread Serguei
Dear Experts, I have a Perl application which works fine at Solaris UNIX box with Perl 5.6.1 and the Oracle 9i database. Now our team is moving to the Oracle 11g database and I have a problem. I changed $PATH, $ORACLE_HOME and $LD_LIBRARY_PATH variables to point to new Oracle 11g client

Re: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]

2006-10-13 Thread John Scoles
ubject: Re: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home] Generated command from make: cc -G -L/usr/lib -L/usr/ccs/lib -L/opt/SUNWspro/WS6U2/lib Oracle.odbdimp.o oci8.o cc -Xa -xstrconst -xF-xarch=v8 -xchip=ultra -W2,-AKNR_S -W2,-Rglobal_hoist -Wc,-Qdelay-speculate -Wc,

Re: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]

2006-10-13 Thread listmail
t generated the Oracle.so file... John Scoles wrote: What exactly did you remove? - Original Message - From: "listmail" <[EMAIL PROTECTED]> To: Sent: Friday, October 13, 2006 1:41 PM Subject: [Fwd: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home] I simply

Re: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]

2006-10-13 Thread John Scoles
What exactly did you remove? - Original Message - From: "listmail" <[EMAIL PROTECTED]> To: Sent: Friday, October 13, 2006 1:41 PM Subject: [Fwd: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home] I simply removed the extra cc reference and ran it manual

[Fwd: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]

2006-10-13 Thread listmail
flags` `cat /u01/oracle/qadb/9.2.0/lib32/sysliblist` -R/u01/oracle/qadb/9.2.0/lib32 -laio -lposix4 -lkstat -lm -lthread -o blib/arch/auto/DBD/Oracle/Oracle.so Original Message Subject:compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home Date: Fri, 13 Oct 20

compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home

2006-10-13 Thread listmail
I'm trying to compile DBD-Oracle 1.16 against an Oracle 9i 64-bit home and got a little further this time when I set LD_LIBRARY_PATH to include $ORACLE_HOME/lib32. I'm not seeing what file it cannot find and the three .0 files were created. The following is the output of env vars,

Re: Oracle 9i - Install problems on Win XP?

2005-09-06 Thread Chris Charley
Please, in the future, keep your questions DBI/DBD related on this list... HTH, amonotod Yes, I don't know why I didn't realize this Thank you for the information Chris

Re: Oracle 9i - Install problems on Win XP?

2005-09-05 Thread amonotod
> From: "Chris Charley" <[EMAIL PROTECTED]> > Date: 2005/09/04 Sun PM 06:27:52 CDT > Hello list, > > Wondering if anyone may know of problems on install of Oracle. Technically, this is off-topic. But, to answer your question, no, I've not had any issues. My work network has two network insta

Re: Oracle 9i RAC on Linux

2005-05-26 Thread Bruce Nelson
I use it -- no problems -- the libclntsh is basically the same. Your only difference is really your tnsnames.ora -- you may want to load balance and use TAF against your RAC servers. BN Steve Sapovits wrote: Has anyone used DBI in an Oracle 9i RAC configuration on Linux? If so, were

Re: Oracle 9i RAC on Linux

2005-05-26 Thread Michael Nhan
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 configurat

Oracle 9i RAC on Linux

2005-05-26 Thread Steve Sapovits
Has anyone used DBI in an Oracle 9i RAC configuration on Linux? If so, were there any issues moving to RAC? -- Steve Sapovits[EMAIL PROTECTED]

Re: Problem (and Solution) Installing DBD::Oracle-1.16 on 64-bit Perl 5.8.5 running on Solaris 9 with Oracle 9i

2005-04-20 Thread Tim
Thanks James. Tim. On Tue, Apr 19, 2005 at 04:31:39PM -0500, James D. White wrote: > I had a slight problem while installing DBD::Oracle 1.16 on a 64-bit Perl > 5.8.5 running > on a Solaris 9 system with Oracle 9i. "perl Makefile.PL" tried to use the > 32-bit Oracle >

Problem (and Solution) Installing DBD::Oracle-1.16 on 64-bit Perl 5.8.5 running on Solaris 9 with Oracle 9i

2005-04-19 Thread James D. White
I had a slight problem while installing DBD::Oracle 1.16 on a 64-bit Perl 5.8.5 running on a Solaris 9 system with Oracle 9i. "perl Makefile.PL" tried to use the 32-bit Oracle libraries. The Oracle 9 (and 8 IIRC) client uses "*/lib" for the 64-bit libraries and &quo

Re: Can't connect to Oracle 9i when connected to DB2

2004-11-01 Thread Tim Bunce
On Mon, Nov 01, 2004 at 12:55:18PM -0600, Mullen, David A wrote: > > If I first do DBI->connect() to the Oracle 9i database, and then to DB2 > (without retrieving data from either, but having prepared some > statements), it works fine. However, if I set up the DB2 $dbh and > s

Can't connect to Oracle 9i when connected to DB2

2004-11-01 Thread Mullen, David A
.0.5), DBD::DB2 is 0.78 (client version 7.2 (version 7 fixpack 12)). If I first do DBI->connect() to the Oracle 9i database, and then to DB2 (without retrieving data from either, but having prepared some statements), it works fine. However, if I set up the DB2 $dbh and statements first, I get a c

RE: Slow connection to Oracle 9i

2004-10-23 Thread Jared Still
On Mon, 2004-10-18 at 10:16, BAXTER, LINCOLN A wrote: > Most people with experience with Oracle know that opening oracle connections > is SLOW! > Really? I've never noticed. Unless I'm connecting to a database over a slow WAN. Here's a connection time to a database on a laptop through an 811

Re: Slow connection to Oracle 9i

2004-10-22 Thread Peter J. Holzer
On 2004-10-21 12:01:11 -0600, Reidy, Ron wrote: > The statement was "Call commit (even if you have done only selects) > ...". This was what I was referring to. Ah, ok. I missed that remark in parentheses - sorry. hp -- _ | Peter J. Holzer | Shooting the users in the foot is ba

Re: Slow connection to Oracle 9i

2004-10-21 Thread Paul Appleby
Thank you to all. Your responsiveness was amazing and the responses very helpful. If anyone has any other comments or ideas, please email them to me directly. If I come across any new developments or solutions, I will forward them to Tim, unless he prefers otherwise. I may post to the Oracle-L ma

Re: Slow connection to Oracle 9i

2004-10-21 Thread Tim Bunce
It's time to end this thread now - or take it to an Oracle specific mailing list like oracle-l. Thanks. Tim.

RE: Slow connection to Oracle 9i

2004-10-21 Thread Reidy, Ron
To: [EMAIL PROTECTED] Subject: Re: Slow connection to Oracle 9i On 2004-10-21 08:51:04 -0600, Reidy, Ron wrote: > My comments are below ... > > - > Ron Reidy > Lead DBA > Array BioPharma, Inc. > > > -Original Message- > From: Peter J.

Re: Slow connection to Oracle 9i

2004-10-21 Thread Peter J. Holzer
04 9:10 AM > To: [EMAIL PROTECTED] > Subject: Re: Slow connection to Oracle 9i > > > [Rearranged quotes for better readability] > > On 2004-10-19 08:23:53 -0600, Reidy, Ron wrote: > > BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]: > >> Ok, then if you use Apache

RE: Slow connection to Oracle 9i

2004-10-21 Thread Reidy, Ron
My comments are below ... - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Peter J. Holzer [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 9:10 AM To: [EMAIL PROTECTED] Subject: Re: Slow connection to Oracle 9i [Rearranged quotes for

Re: (Fwd) Problems installing DBD1.15 with Oracle 9i client

2004-10-21 Thread Thomas Chiverton
On Thursday 21 Oct 2004 00:39 am, you said: > While trying to install DBD1.15 with the Oracle 9i client in a Linux > machine, we are facing some issues. > Unable to locate an oracle.mk, proc.mk or other suitable *.mk > file in your Oracle installation. (I looked

Re: Slow connection to Oracle 9i

2004-10-21 Thread Peter J. Holzer
[Rearranged quotes for better readability] On 2004-10-19 08:23:53 -0600, Reidy, Ron wrote: > BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]: >> Ok, then if you use Apache and mod_perl this should be easy... just open >> connection if you don't have it (or you get and error on it), and keep it >> arou

(Fwd) Problems installing DBD1.15 with Oracle 9i client

2004-10-20 Thread Tim Bunce
- Forwarded message from "Selvam, Shanmugapriya" <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] to mail through 192.6.86.210) Subject: Problems installing DBD1.15 with Oracle 9i client Date: Wed, 20 Oct 200

RE: Slow connection to Oracle 9i

2004-10-19 Thread Bong Tumanut
Commit is not to improve the performance of a single thread. It is to complete a transaction (i.e. set of SQL either is comitted or rolled back, no partial). Doing so also minimizes contention with other threads. Bong Tumanut DBA --- "Reidy, Ron" <[EMAIL PROTECTED]> wrote: > Hmm... > > I strong

Re: Slow connection to Oracle 9i

2004-10-19 Thread Henri Asseily
riginal Message- From: Henri Asseily [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 5:12 PM To: '[EMAIL PROTECTED]'; Jesse, Rich Subject: Re: Slow connection to Oracle 9i I have a DBIx::HA (High Availability) module on CPAN, but I'm readying a next version real soon now t

RE: Slow connection to Oracle 9i

2004-10-19 Thread BAXTER, LINCOLN A
] Sent: Tuesday, October 19, 2004 10:39 AM To: BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i Hmm... I strongly disagree. To quote from Steve Adam's website (http://www.ixora.com.au/newsletter/2001_09.htm)... Over committed Many applications commit

RE: Slow connection to Oracle 9i

2004-10-19 Thread BAXTER, LINCOLN A
-Original Message- From: BAXTER, LINCOLN A Sent: Tuesday, October 19, 2004 10:27 AM To: 'Reidy, Ron' Subject: RE: Slow connection to Oracle 9i Actually it is CHEAP compared to a rollback, you have to reset your transaction state. Commit is the cheapest thing you can do in O

RE: Slow connection to Oracle 9i

2004-10-19 Thread Reidy, Ron
9, 2004 8:27 AM To: Reidy, Ron Subject: RE: Slow connection to Oracle 9i Actually it is CHEAP compared to a rollback, you have to reset your transaction state. Commit is the cheapest thing you can do in Oracle. The MOST expensive thing to do is Rollback. Believe me we know, from empirical experie

RE: Slow connection to Oracle 9i

2004-10-19 Thread Reidy, Ron
Message- From: BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 3:05 PM To: 'Paul Appleby' Cc: '[EMAIL PROTECTED]' Subject: RE: Slow connection to Oracle 9i Ok, then if you use Apache and mod_perl this should be easy... just open connection if you d

Re: Slow connection to Oracle 9i

2004-10-19 Thread Peter J. Holzer
On 2004-10-18 11:48:11 -0600, Reidy, Ron wrote: > Maybe Oracle does not think it is a problem, but I (and lots of > others) would disagree. These issues are correctable. > > In the case of slow logins, it depends on what is being done when the > connection is made. When making connections that a

Re: Slow connection to Oracle 9i

2004-10-19 Thread Peter J. Holzer
On 2004-10-18 19:57:07 -0400, Paul Appleby wrote: > My CGI application will be called by different visitors to the web > site at different times, but they all connect to the same database > using the same connection variables, i.e. the same user/password. > Are you saying the first visitor to t

RE: Slow connection to Oracle 9i

2004-10-19 Thread BAXTER, LINCOLN A
: Paul Appleby; BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i H...one thing I thought of is to check the validity of the handle, in case the Oracle instance bounces (i.e. The Oracle instance is available, but the persistent connection no longer exists). Does

RE: Slow connection to Oracle 9i

2004-10-19 Thread BAXTER, LINCOLN A
OH... Col! -Original Message- From: Henri Asseily [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 5:12 PM To: '[EMAIL PROTECTED]'; Jesse, Rich Subject: Re: Slow connection to Oracle 9i I have a DBIx::HA (High Availability) module on CPAN, but I'm readying

RE: Slow connection to Oracle 9i

2004-10-19 Thread BAXTER, LINCOLN A
PROTECTED] Sent: Monday, October 18, 2004 4:39 PM To: BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i My CGI application will be called by different users at different times. Are you saying the first user's connection can be left open for all the other us

RE: Slow connection to Oracle 9i

2004-10-19 Thread BAXTER, LINCOLN A
s not a recreational drug. Lincoln -Original Message- From: Paul Appleby [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 4:54 PM To: BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i No. Each user will be using the same application that logs in to the

Re: Slow connection to Oracle 9i

2004-10-19 Thread Steffen Goeldner
Paul Appleby wrote: Try measuring the time it takes to connect with SqlPlus by using You mean DBI? (I already sent the result for sqlplus.) "Time::HiRes" with the variables $time1 and $time2 both set to gettimeofday() and the the length of time set to $time2-$time1, as follows: $time1=gettimeofd

Re: Slow connection to Oracle 9i

2004-10-18 Thread Henri Asseily
Lincoln -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 12:06 PM To: Paul Appleby Cc: [EMAIL PROTECTED] Subject: Re: Slow connection to Oracle 9i On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote: DBD::Oracle::dr::load_dbnames is only cal

Re: Slow connection to Oracle 9i

2004-10-18 Thread Chuck Fox
n the client side. That is why, > >> >for instance, Websphere caches pooled connections in the java world. > >> > > >> >Lincoln > >> > > >> > > >> >-Original Message- > >> >From: Tim Bunce [mailt

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
world. > >Lincoln > > >-Original Message- >From: Tim Bunce [mailto:[EMAIL PROTECTED] >Sent: Monday, October 18, 2004 12:06 PM >To: Paul Appleby >Cc: [EMAIL PROTECTED] >Subject: Re: Slow connection to Oracle 9i > > >On Mon, Oct 18, 2

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
, October 18, 2004 12:06 PM >To: Paul Appleby >Cc: [EMAIL PROTECTED] >Subject: Re: Slow connection to Oracle 9i > > >On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote: >> >> >DBD::Oracle::dr::load_dbnames is only called by data_sources() >> >s

Re: Slow connection to Oracle 9i

2004-10-18 Thread Tim Bunce
ROTECTED] > >Sent: Monday, October 18, 2004 12:06 PM > >To: Paul Appleby > >Cc: [EMAIL PROTECTED] > >Subject: Re: Slow connection to Oracle 9i > > > > > >On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote: > >> > >> >DBD::

Re: Slow connection to Oracle 9i

2004-10-18 Thread Henri Asseily
istrator [EMAIL PROTECTED] QuadTech, Sussex, WI USA -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 3:51 PM To: Paul Appleby; BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i Perhaps this'll help: http://

RE: Slow connection to Oracle 9i

2004-10-18 Thread Jesse, Rich
Appleby; BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i Perhaps this'll help: http://perl.apache.org/docs/1.0/guide/performance.html#Persistent_DB_Connections There's a link on that site to "Tim Bunce's Advanced DBI talk", but it retu

RE: Slow connection to Oracle 9i

2004-10-18 Thread Reidy, Ron
connection to Oracle 9i My CGI application will be called by different users at different times. Are you saying the first user's connection can be left open for all the other users? How? Paul >Most people with experience with Oracle know that opening oracle connections >is SLOW! > &g

RE: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
n the database can make a BIG difference ... talk to your dba's) Lincoln -Original Message- From: Paul Appleby [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 4:39 PM To: BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i My CGI application will

RE: Slow connection to Oracle 9i

2004-10-18 Thread Jesse, Rich
istrator [EMAIL PROTECTED] QuadTech, Sussex, WI USA -Original Message- From: Paul Appleby [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 3:39 PM To: BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i My CGI application will be called by different users

RE: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
, for instance, Websphere caches pooled connections in the java world. Lincoln -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 12:06 PM To: Paul Appleby Cc: [EMAIL PROTECTED] Subject: Re: Slow connection to Oracle 9i On Mon, Oct 18, 2004 at 10:38

Re: Slow connection to Oracle 9i

2004-10-18 Thread Tim Bunce
tisfied, open a TAR with Oracle support. > > - > Ron Reidy > Lead DBA > Array BioPharma, Inc. > > > -Original Message- > From: BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED] > Sent: Monday, October 18, 2004 11:17 AM > To: [EMAIL PROTECTED]

RE: Slow connection to Oracle 9i

2004-10-18 Thread Reidy, Ron
a TAR with Oracle support. - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 11:17 AM To: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i Most people with experience

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
int $time2-$time1; Paul Paul Appleby wrote: I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to connect to a local Oracle 9i database [...] Why is the connection time so long and how can I shorten it? [...] It takes 2.9342188835144 seconds to connect to the database. How long do

RE: Slow connection to Oracle 9i

2004-10-18 Thread BAXTER, LINCOLN A
, 2004 12:06 PM To: Paul Appleby Cc: [EMAIL PROTECTED] Subject: Re: Slow connection to Oracle 9i On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote: > > >DBD::Oracle::dr::load_dbnames is only called by data_sources() > >so don't call data_sources() unless you re

Re: Slow connection to Oracle 9i

2004-10-18 Thread Tim Bunce
On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote: > > >DBD::Oracle::dr::load_dbnames is only called by data_sources() > >so don't call data_sources() unless you really need to. > > I really do need to call data_sources() but the time it takes to > retrieve data, as shown above, usin

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
Tim, It is 3 to 4 times longer than retrieving data from a MySQL database. Only 3 to 4 times longer than retrieving data from a MySQL? You're lucky, it's often longer! :) That was 3 to 4 times longer using the data from "d:DProf". But it's 20 times longer using "Time::HiRes" to measure the time

Re: Slow connection to Oracle 9i

2004-10-18 Thread John
:34 AM Subject: Re: Slow connection to Oracle 9i > Paul Appleby wrote: > > > I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to > > connect to a local Oracle 9i database > [...] > > Why is the connection time so long and how can I shorten it? > [

Re: Slow connection to Oracle 9i

2004-10-18 Thread Steffen Goeldner
Paul Appleby wrote: > I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to > connect to a local Oracle 9i database [...] > Why is the connection time so long and how can I shorten it? [...] > It takes 2.9342188835144 seconds to connect to the database. How long does

Re: Slow connection to Oracle 9i

2004-10-18 Thread Tim Bunce
On Sun, Oct 17, 2004 at 09:06:56PM -0400, Paul Appleby wrote: > I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to connect to a > local Oracle 9i database table and retrieve the data in the three small fields of > its only two records. > > Why is the connecti

Slow connection to Oracle 9i

2004-10-17 Thread Paul Appleby
I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to connect to a local Oracle 9i database table and retrieve the data in the three small fields of its only two records. Why is the connection time so long and how can I shorten it? It is 3 to 4 times longer than retrieving data

Re: DBD::Oracle for Oracle 9i versoin 9.2.0 (64 bit Oracle)

2004-07-22 Thread Tim Bunce
On Thu, Jul 22, 2004 at 05:14:03PM -0400, [EMAIL PROTECTED] wrote: > > I am unable to compile/build DBD::Oracle with Oracle 9i (64-bit Oracle RDBMS) > library. Could someone please help? Thanks. http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc5-20040715.tar.gz http://www

DBD::Oracle for Oracle 9i versoin 9.2.0 (64 bit Oracle)

2004-07-22 Thread Surjit . Sahoo
I am unable to compile/build DBD::Oracle with Oracle 9i (64-bit Oracle RDBMS) library. Could someone please help? Thanks. regards surjit This message contains information from Equifax Inc. which may be confidential and privileged. If you are not an intended recipient, please refrain from

Re: Connecting to Oracle 9i with no listener

2004-03-19 Thread John
; Sent: Friday, March 19, 2004 2:49 PM 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:

Re: Connecting to Oracle 9i with no listener

2004-03-19 Thread Tim Bunce
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? > > >

Connecting to Oracle 9i with no listener

2004-03-18 Thread John
How to get connected to an oracle server with not listener? Which one is the correct? $dbh = DBI->connect('dbi:Oracle:T:Machine:SID','username','password') $dbh = DBI->connect('dbi:Oracle:','[EMAIL PROTECTED]:Machine:SID','password') $dbh = DBI->connect('dbi:Oracle:'

RE: How to connect Oracle 9i (Windows )

2004-03-11 Thread Hardy Merrill
acle server on Windoze using Perl. HTH. Hardy Merrill -Original Message- From: Mahi.G [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:50 AM To: [EMAIL PROTECTED] Subject: How to connect Oracle 9i (Windows ) Hai I am working on Redhat Linux system with Perl. But I want t

RE: How to connect Oracle 9i (Windows )

2004-03-11 Thread Zhang, George
:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:50 AM To: [EMAIL PROTECTED] Subject: How to connect Oracle 9i (Windows ) Hai I am working on Redhat Linux system with Perl. But I want to connect with Oracle 9i database in my Network. But The Oracle is installed in Windows System. Is it

RE: How to connect Oracle 9i (Windows )

2004-03-11 Thread Zhang, George
:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:50 AM To: [EMAIL PROTECTED] Subject: How to connect Oracle 9i (Windows ) Hai I am working on Redhat Linux system with Perl. But I want to connect with Oracle 9i database in my Network. But The Oracle is installed in Windows System. Is it

How to connect Oracle 9i (Windows )

2004-03-11 Thread Mahi.G
Hai I am working on Redhat Linux system with Perl. But I want to connect with Oracle 9i database in my Network. But The Oracle is installed in Windows System. Is it possible to connect the Oracle 9i by using Perl script. If possible pls guide me ( I am new for database connection ). If u

Problems Installing DBD::Oracle 1.15 on FreeBSD 5.1 with Oracle 9i

2004-02-17 Thread Scot Greisch
I've got Oracle9i successfully installed and am able to connect via sqlplus to databases on the local server and remote servers. I've installed DBI 1.40 and am trying to install DBD::Oracle 1.15. It gives the following warnings during perl Makefile.PL: Note (probably harmless): No library found f

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-29 Thread Tim Bunce
On Thu, Jan 29, 2004 at 08:13:23AM +0100, Vladimir Marek wrote: > Hi > > [...] > > > > Should I be able to compile for Oracle 9/64bit on Solaris? > > > "perl Makefile.PL -r=build64" did not compile. > > > > "did not compile" doesn't help much, but it would only stand any chance if > > perl itsel

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-29 Thread Vladimir Marek
Hi [...] > > Should I be able to compile for Oracle 9/64bit on Solaris? > > "perl Makefile.PL -r=build64" did not compile. > > "did not compile" doesn't help much, but it would only stand any chance if > perl itself was built with the same 64bit model as Oracle wants to use. > I've no idea what

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-28 Thread Tim Bunce
On Tue, Jan 27, 2004 at 02:21:32PM +0100, Dominik Stadler wrote: > > When running tests on Solaris/Oracle 9.2.0 I get: > > t/ph_typeok 11/19 expected 'trailing' but got 'trailing ' for VARCHAR2 Known issue with Oracle 9.2 - see the archives. May be an Oracle bug. I'll tweak the tests to expl

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-27 Thread Dominik Stadler
se* > include the lg of the build (ideally created using the script command). > > Thank you. > > Tim. > > On Mon, Jan 26, 2004 at 08:56:13AM +0100, Joel Van Boeckel wrote: >> Hi Mark, >> In a preceding message, I explained how I succeeded to build DBD::Oracle with

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-27 Thread Dominik Stadler
t; include the lg of the build (ideally created using the script command). > > Thank you. > > Tim. > > On Mon, Jan 26, 2004 at 08:56:13AM +0100, Joel Van Boeckel wrote: >> Hi Mark, >> In a preceding message, I explained how

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-26 Thread Tim Bunce
build (ideally created using the script command). Thank you. Tim. On Mon, Jan 26, 2004 at 08:56:13AM +0100, Joel Van Boeckel wrote: > Hi Mark, > In a preceding message, I explained how I succeeded to build DBD::Oracle with Oracle > 9i on a HP-UX system. > It seems that you encounter

RE: DBD-Oracle-1.14 and Oracle 9i

2004-01-26 Thread Joel Van Boeckel
Hi Mark, In a preceding message, I explained how I succeeded to build DBD::Oracle with Oracle 9i on a HP-UX system. It seems that you encounter the same messages I encountered. Here a copy of my solution. It's perhaps not the best one, but it works.

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-23 Thread Eric Lenio
le.so' > > I'm pretty well stumped, the only thing I can think of to try next is find > another development system with Oracle9, perl 5.6.0 or newer, "gnu gcc, make > and ld" and start from scratch. > But I'm definitely up for any input on trying to get this t

RE: DBD-Oracle-1.14 and Oracle 9i

2004-01-23 Thread Krempasky, Mark
nuary 23, 2004 8:19 AM To: 'Tim Bunce'; Potenza, Joe; Krempasky, Mark Cc: '[EMAIL PROTECTED]' Subject: RE: DBD-Oracle-1.14 and Oracle 9i I apologize for the lack of detail at this time. One of my co-workers was attempting the compile and did some searching on google. I mainly

RE: DBD-Oracle-1.14 and Oracle 9i

2004-01-23 Thread Potenza, Joe
the compilation errors you were getting. Thanks. Joe Potenza -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 2:48 AM To: Potenza, Joe Cc: '[EMAIL PROTECTED]' Subject: Re: DBD-Oracle-1.14 and Oracle 9i On Thu, Jan 22, 2004 at 05:21:

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-23 Thread Sean Kelly
Quoting "Potenza, Joe" <[EMAIL PROTECTED]>: > Has anyone been able to compile DBD-Oracle-1.14 with Oracle9i under > Solaris8? I have, but it needed some help. perl Makefile.PL ran ok, but the resulting Makefile needed changing to remove several "-o build" terms and also change references to

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-23 Thread Nilanjan Das
iday, January 23, 2004 5:51 AM Subject: DBD-Oracle-1.14 and Oracle 9i > Has anyone been able to compile DBD-Oracle-1.14 with Oracle9i under > Solaris8? > > Joe Potenza > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >

Re: Does DBD-ORACLE support Oracle 9i 64 bit ?

2004-01-23 Thread Tim Bunce
On Thu, Jan 22, 2004 at 05:47:12PM -0800, ANDERSON, DOUG (SBCSI) wrote: > Hi, > > We have just upgraded to Oracle 9i 64 bit from Oracle 8.1.7 32 bit and I > have been trying to re-install my DBD version 1.07 and am getting an error > of > ld: fatal: file /usr/local/opt/or

Re: DBD-Oracle-1.14 and Oracle 9i

2004-01-23 Thread Tim Bunce
On Thu, Jan 22, 2004 at 05:21:02PM -0700, Potenza, Joe wrote: > Has anyone been able to compile DBD-Oracle-1.14 with Oracle9i under > Solaris8? Have you been able to use google to find out? Tim.

Does DBD-ORACLE support Oracle 9i 64 bit ?

2004-01-22 Thread ANDERSON, DOUG (SBCSI)
Hi, We have just upgraded to Oracle 9i 64 bit from Oracle 8.1.7 32 bit and I have been trying to re-install my DBD version 1.07 and am getting an error of ld: fatal: file /usr/local/opt/oracle/product/9.2.0/rdbms/lib/defopt.o: wrong ELF class: ELFCLASS64, does anyone know of a way to override

DBD-Oracle-1.14 and Oracle 9i

2004-01-22 Thread Potenza, Joe
Has anyone been able to compile DBD-Oracle-1.14 with Oracle9i under Solaris8? Joe Potenza [EMAIL PROTECTED]

Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-22 Thread Tim Bunce
On Thu, Jan 22, 2004 at 01:39:47PM +0100, Joel Van Boeckel wrote: > Hi Tim, > Using the -l flag of perl Makefile.PL, I don't think that we pass thru the buid rule > discovery phase. > I send you the log of >- perl Makefile.PL -l >- perl Makefile.PL > > [EMAIL PROTECTED] DBD-Oracle-1.15 ]#

RE: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-22 Thread Joel Van Boeckel
DME and README.help files. (Of course, you have read README by now anyway, haven't you?) -Message d'origine- De : Tim Bunce [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 janvier 2004 13:19 À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; Sean Kelly Objet : Re: Can't make DBD

Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-22 Thread Tim Bunce
:[EMAIL PROTECTED] > Envoyé : mercredi 21 janvier 2004 20:07 > À : [EMAIL PROTECTED] > Cc : Sean Kelly; [EMAIL PROTECTED] > Objet : Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i > > > On Wed, Jan 21, 2004 at 06:02:29PM +0100, Joel Van Boeckel wrote: > &

RE: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-22 Thread Joel Van Boeckel
t : Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i On Wed, Jan 21, 2004 at 06:02:29PM +0100, Joel Van Boeckel wrote: > Hi Sean, > I had a lot of problems in order to build Oracle:DBD on HP-UX. > I finally ended to a very simple solution. > - recompile perl conformi

Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-21 Thread Tim Bunce
On Wed, Jan 21, 2004 at 06:02:29PM +0100, Joel Van Boeckel wrote: > Hi Sean, > I had a lot of problems in order to build Oracle:DBD on HP-UX. > I finally ended to a very simple solution. > - recompile perl conforming to HP requirements What do you mean by "HP requirements"? > - patch DBD::Oracle

RE: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

2004-01-21 Thread Joel Van Boeckel
Hi Sean, I had a lot of problems in order to build Oracle:DBD on HP-UX. I finally ended to a very simple solution. - recompile perl conforming to HP requirements - patch DBD::Oracle Makefile.PL Perhaps may this information help you in fixing the solution. The final environment is : Perl

Re: (Fwd) Re: The official word on Oracle 9i support in DBD::Oracle

2004-01-18 Thread Jared Still
[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: Re: The official word on Oracle 9i support in DBD::Oracle > Date: Wed, 14 Jan 2004 12:00:01 -0700 > >Hi! > >I've been trying to stand up a Perl setup on a RedHat Linux box as an expansion >

(Fwd) Re: The official word on Oracle 9i support in DBD::Oracle

2004-01-14 Thread Ian Harisay
Hi, What I have had to do to take care fo this problem is copy the rdbms directory over from another linux box that I has a full install of Oracle. Not just the client. I copied it over to the box I just wanted my Oracle client and it worked beautifully after that. System info is: OS: RedHat

(Fwd) Re: The official word on Oracle 9i support in DBD::Oracle

2004-01-14 Thread Tim Bunce
- Forwarded message from Jeremy Beal <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: Jeremy Beal <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: Re: The official word on Oracle 9i support in DBD::Oracle Date:

Re: The official word on Oracle 9i support in DBD::Oracle

2003-12-30 Thread Tim Bunce
On Mon, Dec 29, 2003 at 03:30:08PM -0800, Michael A Chase wrote: > On Mon, 29 Dec 2003 12:15:12 + Tim Bunce <[EMAIL PROTECTED]> wrote: > > > The next version addresses this by removing the "8" in references to > > Oracle :) > > Another thing I've been meaning to bring up. If you have to have

RE: Oracle 9i/DBD1.14/Solaris 8 or 9 64bit

2003-12-29 Thread LY, Michelle
sure... From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Mon 12/29/2003 6:01 PM To: LY, Michelle Cc: [EMAIL PROTECTED] Subject: Re: Oracle 9i/DBD1.14/Solaris 8 or 9 64bit Any chance you can try to fix the Makefile.PL to do the right thing and send it to me

Re: The official word on Oracle 9i support in DBD::Oracle

2003-12-29 Thread Michael A Chase
On Mon, 29 Dec 2003 12:15:12 + Tim Bunce <[EMAIL PROTECTED]> wrote: > The next version addresses this by removing the "8" in references to > Oracle :) Another thing I've been meaning to bring up. If you have to have different versions for different OCIs in the future, make the option positiv

Re: Oracle 9i/DBD1.14/Solaris 8 or 9 64bit

2003-12-29 Thread Tim Bunce
Any chance you can try to fix the Makefile.PL to do the right thing and send it to me? Tim. On Mon, Dec 29, 2003 at 05:09:39PM -0500, LY, Michelle wrote: > My thanks goes out to Tim Bunce (provided the new Makefile.PL) and > Michael Nhan who indicated that one of the parameters was missing. > Thi

  1   2   3   >