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

[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?

[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 installs of 
Oracle clients (8i and 9i), two versions of Perl (5.8.0 (client 
compatibility) and 5.8.7) and we are able to switch to whatever is 
needed without any issues by just modifying the correct ENV variables (PATH 
and the Oracle vars).

> Also, I was told that the Oracle install includes Perl, Java and some other 
> things. I'm not too happy to learn that as I don't want the install to put 
> an older version of Perl on my machine. I guess to avoid that, I could do a 
> custom install and choose not to load Perl or Java.

I don't recall seeing Perl in the directories under the Oracle install, 
but I've not installed 10g yet.  As for Java, you can't skip it, as it's 
part of the base install.  Just modify your post-installation PATH 
so that the Java you want is first...

> 
> I just don't want some software install to mess up my computer. (This is for 
> a class on SQL using the Oracle database that I was thinking of taking).

If you're taking a class on ANSI SQL, you could probably install just 
about any database, and not worry about how Oracle may affect your 
system...

> Thanks for any help someone may provide.
> Chris

Please, in the future, keep your questions DBI/DBD related on this list...

HTH,
amonotod

--

`\|||/ amonotod@| sun|perl|windows
  (@@) charter.net  | sysadmin|dba
  ooO_(_)_Ooo
  _|_|_|_|_|_|_|_|

Re: Oracle 9i RAC on Linux

[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 there any issues moving to RAC?

Re: Oracle 9i RAC on Linux

[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 configuration on Linux?  If
so, were there any issues moving to RAC?




---//---
"He who learns must suffer. And even in our sleep,
 pain that cannot forget, falls drop by drop upon the heart; 
and, in our own despair, against our will,

 comes wisdom to us by the awful grace of God."
--- Aeschylus

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

[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?

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.
> This is what I did
> 
> make realclean
> perl Makefile.PL
> Edited the new Makefile to point all 9.2/lib and 9.2/rdbms/lib to
> their 32bit counterparts.
> Then made sure that the following was correct
> **per Michael Nhan***
> > -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
>made sure that all occurences of these options include the -R.
> (There are 4 I believe)
> then ran the
> make
> make test
> make install
> 
> And it went in with no problem.
> 
>

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

[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.
> This is what I did
>  
> make realclean
> perl Makefile.PL
> Edited the new Makefile to point all 9.2/lib and 9.2/rdbms/lib to
> their 32bit counterparts.
> Then made sure that the following was correct 
> **per Michael Nhan***
> > -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
>made sure that all occurences of these options include the -R.
> (There are 4 I believe)
> then ran the 
> make
> make test 
> make install
>  
> And it went in with no problem.
>  
> 

Re: Oracle 9i Lite and DBD::Oracle problems [solved]

[Tim Bunce]

Thanks for the update.

Tim.

On Tue, Sep 02, 2003 at 11:07:47AM -0700, Brent LaVelle wrote:
> With the help of Brian Haas and Ian Harisay I got DBD::Oracle working. 
> The advice is to use the regular Oracle9i not the lite version. 
> Another great source of help was:
> http://www.puschitz.com/InstallingOracle9i.html
> just getting 9i and 9i lite installed.  I use fvwm2(nvidia X driver) as
> a window manager which does not work with the 9i install program, works
> fine with the default Gnomish(nv X driver), it could have been the X
> driver too.
> 
> With Redhat9 it is REAL important to set LD_ASSUME_KERNEL to 2.4.1.
> 
> I didn't try this but it may be possible to install what is needed by
> only downloading the first disk saving some 1.3GB of download fun.
> 
> I installed a custom install from the client group.  The packages I
> installed are the Programmers section and sqlplus.  I noticed that the
> Pro*C when on as a result of the checking the Programmers section I
> assume.
> 
> Once Oracle was installed properly the DBD::Oracle install went as
> smooth as just about every other CPAN module.
> 
> I don't know if Oracle is bulletproof on Linux but the install process
> has some problems.
> 
> Thank-you for the help.
> 
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com

RE: Oracle 9i Lite and DBD::Oracle problems [solved]

[Brent LaVelle]

With the help of Brian Haas and Ian Harisay I got DBD::Oracle working. 
The advice is to use the regular Oracle9i not the lite version. 
Another great source of help was:
http://www.puschitz.com/InstallingOracle9i.html
just getting 9i and 9i lite installed.  I use fvwm2(nvidia X driver) as
a window manager which does not work with the 9i install program, works
fine with the default Gnomish(nv X driver), it could have been the X
driver too.

With Redhat9 it is REAL important to set LD_ASSUME_KERNEL to 2.4.1.

I didn't try this but it may be possible to install what is needed by
only downloading the first disk saving some 1.3GB of download fun.

I installed a custom install from the client group.  The packages I
installed are the Programmers section and sqlplus.  I noticed that the
Pro*C when on as a result of the checking the Programmers section I
assume.

Once Oracle was installed properly the DBD::Oracle install went as
smooth as just about every other CPAN module.

I don't know if Oracle is bulletproof on Linux but the install process
has some problems.

Thank-you for the help.

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

RE: Oracle 9i, CGI error.

[Sterin, Ilya]

It should work, make sure your connection parameters are OK.  If not,
fix them. 

Another thing to do, is run a trace...

DBI->trace(5, "trace.log");

And you can increase the levels up to 10, for more info.  See what's
going on at connect.

Ilya

> -Original Message-
> From: Karpagam, Madhana (M.) [mailto:[EMAIL PROTECTED] 
> Sent: Friday, August 08, 2003 4:02 PM
> To: '[EMAIL PROTECTED]'
> Cc: Broski, Jeffrey (J.M.)
> Subject: Oracle 9i, CGI error.
> 
> 
> We moved to Oracle 9i recently. The perl scripts are giving 
> out the following error. it is working fine when connecting 
> to Oracle 7.3. An error has occurred that prevents this. The 
> most likely reason is : 
> [08/Aug/2003:15:57:18] failure (15444): for host 19.49.159.74 
> trying to GET /cgi-bin/PPMHome.cgi, cgieng_scan_headers 
> reports: the CGI program 
> /ford/thishost/u/eppm/www.80/cgi-bin/PPMHome.cgi did not 
> produce a valid header (name without value: got line "can't 
> call method "prepare" without a package or object reference 
> at /ford/thishost/u/eppm/www.80/cgi-bin/ppmhome.cgi line 357.") 
> Please contact the application owner to correct this problem. 
> Please advise what needs to be done for the DB connection to 
> work with Oracle 9i. What is a compatible version on DB  to 
> work with 9i. Thanks, Madhana Karpagam.
> 
> 

RE: Oracle 9i (9.2.0.3) client compatiblity with DBD::Oracle?

[LBaxter]

See the message I just posted.

Why not reverse your upgrade order... (and separate database upgrades for
client upgrades). 

It is almost always the case that earlier clients work with later databases.



-Original Message-
From: David K. Whisler [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 01, 2003 2:28 PM
To: [EMAIL PROTECTED]
Subject: Oracle 9i (9.2.0.3) client compatiblity with DBD::Oracle?

Anyone know if the latest Oracle client (9.2.0.3) is compatible with 
Perl DBI/DBD?  Also, wondering if you can use the 9i client and use the 
latest Perl DBI/DBD and talk not only to Oracle 9i Servers but 8i 
Servers as well (without having to re-make the perl DBD).  We're 
migrating from Oracle Server 8.1.7.4 to 9.2.0.3, but want to get all of 
the clients upgraded to 9i first.  They connect to the database via perl 
dbi/dbd, but we also have scripts execute on the Oracle Server itself 
(which will have still be using the old 8.1.7.4 client since it is the 
server and still is running 8.1.7.4 server).  I hope this isn't too 
confusing

-- 
 David K. Whisler - (704) 687-3964
 Oracle DBA & Centra Administrator
The William States Lee College of Engineering
The University of North Carolina at Charlotte

RE: Oracle 9i (9.2.0.3) client compatiblity with DBD::Oracle?

[Mayes, Iman]

I was able to re-use the same DBD install based on 8i to access a 9i
database. This was on RedHat 6.2, although I don't think that matters.

Iman

-Original Message-
From: David K. Whisler [mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 2:28 PM
To: [EMAIL PROTECTED]
Subject: Oracle 9i (9.2.0.3) client compatiblity with DBD::Oracle?


Anyone know if the latest Oracle client (9.2.0.3) is compatible with 
Perl DBI/DBD?  Also, wondering if you can use the 9i client and use the 
latest Perl DBI/DBD and talk not only to Oracle 9i Servers but 8i 
Servers as well (without having to re-make the perl DBD).  We're 
migrating from Oracle Server 8.1.7.4 to 9.2.0.3, but want to get all of 
the clients upgraded to 9i first.  They connect to the database via perl

dbi/dbd, but we also have scripts execute on the Oracle Server itself 
(which will have still be using the old 8.1.7.4 client since it is the 
server and still is running 8.1.7.4 server).  I hope this isn't too 
confusing

-- 
 David K. Whisler - (704) 687-3964
 Oracle DBA & Centra Administrator
The William States Lee College of Engineering
The University of North Carolina at Charlotte

Re: Oracle 9i 64Bit on Solaris 2.8

[Michael A Chase]

On Mon, 24 Mar 2003 19:54:51 -0500 [EMAIL PROTECTED] wrote:

> Does DBD-Oracle 1.13 support Oracle 9.2.0?  If not, are there any
> alternatives I could entertain?

Yes.  No alternatives that involve DBI.

See "IF YOU HAVE PROBLEMS" in DBI-1.35/README and
DBD-Oracle-1.13/README if you have problems.

-- 
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.

Re: Oracle 9i

[Michael A Chase]

On Fri, 10 Jan 2003 17:28:18 -0600 Dean Andrews <[EMAIL PROTECTED]> wrote:

> I have a script that ran fine under 8i.  But is giving me grief under 9i.
> 
> On some systems, I set oracle home back to 8i and add a entry into the 8i
> tnsnames.ora.
> 
> On one system I don't have an oracle 8i.  And I get:
> Can't load
> '/usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.so' for
> module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.1.0: open failed:
> No
> such file or directory at /usr/perl5/5.00503/sun4-solaris/DynaLoader.pm
> line
> 169.
> 
> Is there a separate DBD/Oracle.pm available?

DBD/Oracle.pm does not need to change, but the underlying Oracle.so
does need to be different for different versions of Oracle.  On the
systems where there is not 8i, build DBD::Oracle using a 9i
ORACLE_HOME.

-- 
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.

Re: Oracle 9i and DBD 1.12

[Tim Bunce]

On Wed, Oct 23, 2002 at 09:41:19AM -0700, Todd Enersen wrote:
> 
> What am I missing?  I believe Makefile.PL links to my Oracle 9i libraries
> correctly when it's linking:
> LD_RUN_PATH="/disks/sc-soldev2-007/oracle/product/9i/lib32:/disks/sc-soldev2
> -007/oracle/product/9i/rdbms/lib32" /usr/local/bin/gcc -o
> blib/arch/auto/DBD/Oracle/Oracle.so  -G -L/usr/local/lib Oracle.o dbdimp.o
> oci7.o oci8.o

There are _no_ Oracle libraries at all in that command line. 

Tim.

RE: oracle 9i, freebsd, and dbi

[Gaul, Ken]

No reason why an 8 client can't connect to a 9 database unless you dba has
specifically not installed any backward compatibility. Best test is to try
it :) I would have thought you would get more luck with 8.1 rather then 8.0
though.

Good luck

Ken.

-Original Message-
From: Matthew Lineen [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2002 16:29
To: [EMAIL PROTECTED]
Subject: oracle 9i, freebsd, and dbi


Hello,

Without any luck, I've been trying to install the necessary components
to use DBI to access a remote Oracle 9i server from a FreeBSD (4.6.2)
webserver.  I've read through the archives, but haven't found much on
using FreeBSD and Oracle together.  I'm curious if anyone has done
this successfully and what your methods were?

In the process of trying to run the Oracle installer, I've run into
numerous java core dumps within FreeBSD's linux emulation.  Is it even
necessary to install Oracle 9i Client on the FreeBSD machine or is
there another source for the libraries to link against?  Can the 8.0
libraries be used to connect to a 9i server (since there are
instructions in the FreeBSD manual for installing Oracle 8.0.5)?

If this isn't possible at this time, what options exist to access the
Oracle server without changing operating systems (DBI::Proxy, XML,
.)?

Thanks in advance,
Matthew

Re: Oracle 9i ?

[Hasanuddin Tamir]

On Tue, 14 May 2002, Kipp, James <[EMAIL PROTECTED]> wrote,

> Does the latest version of DBI work with ORacle 9i?

We developed application with Oracle client 8.1.7 and server 8.0.5 (or
something). Once the server was upgraded to 9i and the application couldn't
connect anymore. It wasn't the problem with DBI/DBD::Oracle since SQLPlus
failed to connect as well. While I'm still figuring out what's wrong, the
admin rebooted the application server, and the application runs well again.

I still don't know what's wrong when the upgrading occured and why it needs
to reboot to work again againsts 9i.


rgd
-- 
san->http(www.trabas.com)
{If Linux doesn't have solution, you have the wrong problem}

RE: Oracle 9i ?

[Kipp, James]

I am using DBI 1.21 and DBD::Oracle 1.12 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 14, 2002 4:34 PM
> To: Tompkins, Creigh
> Cc: DBI Users; 'Fannin, David P.'; [EMAIL PROTECTED]
> Subject: RE: Oracle 9i ?
> 
> 
> 
> What is the latest DBI version that you have running?  I'm 
> trying to use
> 1.14 in a Perl program against an Oracle 9.0.1.3 database on 
> SunOS 5.7 and
> am not able to connect.
>   Error message is:  DBI->connect(DUMY) failed: ERROR OCIEnvInit
> 
> However, when running the "perl Makefile.PL -p" and "make 
> test" commands
> using the 9.0.1.3 SID, it appeared to compile successfully.
> 
> Thanks!
> Deb Vredeveld
> 
> 
> 
>   
> 
>   "Tompkins,  
> 
>   Creigh"  To:   
> "'Fannin, David P.'" <[EMAIL PROTECTED]>, DBI Users <[EMAIL PROTECTED]>   
>
>   alleaf.com>  Subject:  RE: 
> Oracle 9i ?  
>   
> 
>   05/14/02 04:03 PM   
> 
>   
> 
>   
> 
> 
> 
> 

RE: Oracle 9i ?

[dvredeveld]

What is the latest DBI version that you have running?  I'm trying to use
1.14 in a Perl program against an Oracle 9.0.1.3 database on SunOS 5.7 and
am not able to connect.
  Error message is:  DBI->connect(DUMY) failed: ERROR OCIEnvInit

However, when running the "perl Makefile.PL -p" and "make test" commands
using the 9.0.1.3 SID, it appeared to compile successfully.

Thanks!
Deb Vredeveld



   
   
  "Tompkins,   
   
  Creigh"  To:   "'Fannin, David P.'" 
<[EMAIL PROTECTED]>, DBI Users <[EMAIL PROTECTED]>   
Subject:  RE: Oracle 9i ?   
   
   
   
  05/14/02 04:03 PM
   
   
   
   
   




FYI: The latest DBI does work under Oracle 9i.  We have it running on
HPUX11i (no fun) and Linux 7.2 64bit.

Creigh Tompkins

-Original Message-
From: Fannin, David P. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 3:50 PM
To: Kipp, James; DBI Users
Subject: RE: Oracle 9i ?


We have not compiled DBD::Oracle with the 9i client code, but we have used
our existing code (compiled against the 8.0.5 libraries) to connect to 9i
servers.  There have been no problems except on HPUX 10.

-dpf-

---
David P. Fannin
Database Administrator  [EMAIL PROTECTED]
UM-Rolla Computing and Information Services  FAX (573) 341-4216
URL  http://www.umr.edu/~dpf   PHONE (573) 341-4841
---


-Original Message-
From: Kipp, James [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 2:43 PM
To: DBI Users
Subject: Oracle 9i ?


Does the latest version of DBI work with ORacle 9i?


IMPORTANT NOTICE:  The contents of this e-mail are confidential to the
ordinary user of the e-mail address to which it was addressed and may also
be privileged.  If you are not the addressee of this e-mail you may not
copy, forward, disclose or otherwise use it or any part of it in any form
whatsoever.  If you have received this e-mail in error please e-mail the
sender by replying to this message.

RE: Oracle 9i ?

[Kipp, James]

Thanks
Think I have it figured out. I have to reinstall DBD::ORacle and customize
the makefile a bit for our environment

> -Original Message-
> From: Kuo, David [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 14, 2002 4:08 PM
> To: 'Kipp, James'; DBI Users
> Subject: RE: Oracle 9i ?
> 
> 
> We got a 9i server running on a sun box and have no problem.
> 
> David
> 
> -Original Message-
> From: Kipp, James [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 14, 2002 4:01 PM
> To: DBI Users
> Subject: RE: Oracle 9i ?
> 
> 
> Thanks
> Just wanted to see.  Having some trouble with it on SunOS box.
> thanks
> 
> > -Original Message-
> > From: Fannin, David P. [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 14, 2002 3:50 PM
> > To: Kipp, James; DBI Users
> > Subject: RE: Oracle 9i ?
> > 
> > 
> > We have not compiled DBD::Oracle with the 9i client code, but 
> > we have used our existing code (compiled against the 8.0.5 
> > libraries) to connect to 9i servers.  There have been no 
> > problems except on HPUX 10.
> > 
> > -dpf-
> > 
> > 
> 

RE: Oracle 9i ?

[Tompkins, Creigh]

FYI: The latest DBI does work under Oracle 9i.  We have it running on
HPUX11i (no fun) and Linux 7.2 64bit.

Creigh Tompkins

-Original Message-
From: Fannin, David P. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 3:50 PM
To: Kipp, James; DBI Users
Subject: RE: Oracle 9i ?


We have not compiled DBD::Oracle with the 9i client code, but we have used
our existing code (compiled against the 8.0.5 libraries) to connect to 9i
servers.  There have been no problems except on HPUX 10.

-dpf-

---
David P. Fannin
Database Administrator  [EMAIL PROTECTED]
UM-Rolla Computing and Information Services  FAX (573) 341-4216
URL  http://www.umr.edu/~dpf   PHONE (573) 341-4841
---


-Original Message-
From: Kipp, James [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 2:43 PM
To: DBI Users
Subject: Oracle 9i ?


Does the latest version of DBI work with ORacle 9i?

 
IMPORTANT NOTICE:  The contents of this e-mail are confidential to the
ordinary user of the e-mail address to which it was addressed and may also
be privileged.  If you are not the addressee of this e-mail you may not
copy, forward, disclose or otherwise use it or any part of it in any form
whatsoever.  If you have received this e-mail in error please e-mail the
sender by replying to this message.

RE: Oracle 9i ?

[Kuo, David]

We got a 9i server running on a sun box and have no problem.

David

-Original Message-
From: Kipp, James [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 4:01 PM
To: DBI Users
Subject: RE: Oracle 9i ?


Thanks
Just wanted to see.  Having some trouble with it on SunOS box.
thanks

> -Original Message-
> From: Fannin, David P. [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 14, 2002 3:50 PM
> To: Kipp, James; DBI Users
> Subject: RE: Oracle 9i ?
> 
> 
> We have not compiled DBD::Oracle with the 9i client code, but 
> we have used our existing code (compiled against the 8.0.5 
> libraries) to connect to 9i servers.  There have been no 
> problems except on HPUX 10.
> 
> -dpf-
> 
> 

RE: Oracle 9i ?

[Kipp, James]

Thanks
Just wanted to see.  Having some trouble with it on SunOS box.
thanks

> -Original Message-
> From: Fannin, David P. [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 14, 2002 3:50 PM
> To: Kipp, James; DBI Users
> Subject: RE: Oracle 9i ?
> 
> 
> We have not compiled DBD::Oracle with the 9i client code, but 
> we have used our existing code (compiled against the 8.0.5 
> libraries) to connect to 9i servers.  There have been no 
> problems except on HPUX 10.
> 
> -dpf-
> 
> 

RE: Oracle 9i ?

[Fannin, David P.]

We have not compiled DBD::Oracle with the 9i client code, but we have used our 
existing code (compiled against the 8.0.5 libraries) to connect to 9i servers.  There 
have been no problems except on HPUX 10.

-dpf-

---
David P. Fannin
Database Administrator  [EMAIL PROTECTED]
UM-Rolla Computing and Information Services  FAX (573) 341-4216
URL  http://www.umr.edu/~dpf   PHONE (573) 341-4841
---


-Original Message-
From: Kipp, James [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 2:43 PM
To: DBI Users
Subject: Oracle 9i ?


Does the latest version of DBI work with ORacle 9i?

 

Re: Oracle 9i, DBI 1.12 & DBD-Oracle 1.20 Problems

[BJ Woodard]

Jay,

Yes you did respond and thank you.  After doing some additional research I 
found that the main library path being referenced was an all 64 bit library 
directory (/usr/oracle/product/9.0.1/rdbms/lib) hence the error.  After 
doing some checking I found that the file referencing this was a 
supplemental file provided by Oracle to build the make file for DBD.  This 
file (/usr/oracle/product/9.0.1/rdbms/lib/env_rdbms.mk) contained a variable 
LIBDIR that was set to lib.  I changed this variable to lib32.  By doing 
this when the Makefile.PL was re-created the correct libraries were 
referenced.

At this point I attempted to run make.  I then received the following error:
ld: Data Linkage Table (+z) overflow in files Oracle.o, dbidump.o & oci8.o - 
use +Z option to recompile.

At this point I changed the +z flag in the Makefile to +Z and re-ran the 
make command.  The make command succeeded and I then ran make test.  The 
make test command failed with the same ld error referenced above.  I 
re-sorted the Makefile to change +z to +Z and re-ran the make test.  At this 
point the make test failed on the following symbols from library dld.sl (all 
of which are 64 bit):
/usr/lib/dld.sl: Unresolved symbol: CD_free (code)  from 
blib/arch/auto/DBD/Oracle/Oracle.sl
/usr/lib/dld.sl: Unresolved symbol: CD_memset (code)  from 
blib/arch/auto/DBD/Oracle/Oracle.sl
/usr/lib/dld.sl: Unresolved symbol: CD_malloc (code)  from 
blib/arch/auto/DBD/Oracle/Oracle.sl
/usr/lib/dld.sl: Unresolved symbol: CD_memcmp (code)  from 
blib/arch/auto/DBD/Oracle/Oracle.sl
/usr/lib/dld.sl: Unresolved symbol: CD_memcpy (code)  from 
blib/arch/auto/DBD/Oracle/Oracle.sl

Even though the make test command was not entirely successful I ran make 
install.  At this point the code appeared to install.  Throughout this 
process however, I have encountered the following errors which concern me:
cc: "oci8.c", line 267: warning 604: Pointers are not assignment-compatible.
Unable to interpret Oracle oci build commands. Using fallback approach.

The compiled code still does not connect to Oracle via PERL.

Jay said:
>Did I respond?  I can't remember
>
>Jay

BJ said:
>>Jay,
>>
>>Before running the make I am exporting an Oracle environment file.  I am 
>>enclosing the file below.  I did notice one error in the SH_LIB that did 
>>not contain a $ for ORACLE_HOME which I have corrected.  I also verified 
>>that the paths being pointed to were in fact real paths.
>>
>>Also, I noticed in your example you placed lib64 as a path.  Is this a
>>valid path?  The only path I see on the machine is lib and lib32 but not 
>>64.  I am still receiving the same error even after correcting the SHLIB 
>>path.
>>
>>Thanks,
>>
>>BJ
>>
>># more 9i_env
>># Used mainly for the toolkit
>>UNIX95=XPG4; export UNIX95
>>ORACLE_BASE=/home/oracle;export ORACLE_BASE
>>ORACLE_PATH=$ORACLE_BASE/toolkit/dba/sqltools:$ORACLE_BASE/toolkit/dba
>>/dbtune:$ORACLE_BASE/toolkit/dba/progtune;
>>export ORACLE_PATH
>># Oracle Environment
>>ORACLE_HOME=/usr/oracle/product/9.0.1; export ORACLE_HOME
>>ORACLE_SID=AWSP; export ORACLE_SID
>>ORACLE_TERM=xterm; export ORACLE_TERM
>>#TNS_ADMIN=/export/home/oracle/config/9.0.1; export TNS_ADMIN
>>#NLS_LANG=AMERICAN-AMERICA.UTF8; export NLS_LANG
>>ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
>>TMPDIR=/tmp; export TMPDIR
>>
>>LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib
>>SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
>>export LD_LIBRARY_PATH
>>export SHLIB_PATH
>>
>># Set shell search paths:
>>PATH=/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/local/bin
>>:$ORACLE_HOME/bin:$ORACLE_BASE/toolkit/bin:$PATH
>>export PATH
>>
>>#CLASSPATH must include the following JRE locations:
>>CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
>>CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
>>
>>stty erase
>>HP-UX eccdb214[ /tmp/dbi ]
>>#

Jay said:
>>>BJ,
>>>Absolutely post to DBI
>>>
>>>But, I looking over your envs, Are SHLIB_PATH, and LD_LIBRARY_PATH
>>>pointing to a true locations?
>>>
>>>I'd think they'd be defined like:
>>>
>>>export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
>>>or
>>>export SHLIB_PATH=$ORACLE_HOME/lib64:$ORACLE_HOME/rdbms/lib64
>>>
>>>Also you need to define ORACLE_USERID
>>>export ORACLE_USERID=system/manger
>>>
>>>Jay
>>>

BJ said.
Jay,

The environment is liste below.  Should I also post this to the list?

Thanks,

BJ

HP-UX eccdb214[ /tmp/dbi ]
# env|sort
COLUMNS=132
EDITOR=vi
ERASE=^H
HISTFILE=/.audit/01-25-02:14:23:37.10058.audit
HISTSIZE=2500
HOME=/
LD_LIBRARY_PATH=/usr/oracle/product/9.0.1/lib:/lib:/usr/lib:/usr/ora
cle/product/9.0.1/rdbms/lib
LINES=49
LOGNAME=root
MAIL=/var/mail/root
MANPATH=/usr/share/man:/usr/contrib/man:/usr/local/man:/opt/perf/man
:/opt/OV/man:/ford/thishost/unix/man:/opt/hparray/share/man:/opt/lan
gtools/share/man:/opt/emc/SYMCLI/V4.2/m

RE: Oracle 9i

[Ron Peled]

Once again thank to you all 
I'll try it later and let you know of the results



-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 6:35 PM
To: Ron Peled
Cc: [EMAIL PROTECTED]; Scott T. Hildreth
Subject: RE: Oracle 9i



If you want to use the 9i libraries, you definitely have to recomplie
DBD::Oracle.  If the 8.0.5 instance is still on the machine you could
use the current DBD::Oracle and connect through sqlnet,

$dbh = DBI->connect("dbi:Oracle:", 'user/passwd@sid', '', {});

 /\ 
  this would be the 9i
instance.

On 04-Dec-01 Ron Peled wrote:
> Hey Scott,
> 
>First of all thanks for the quick answer.
> Second :Connecting via SQLPLUS connects me to the DB just fine.Looking in
> the tnsnames.ora it looks just fine and so is the ORACLE_SID .
> I have to admit that I'm quite new at this.
> 
> some facts that might help is that on the same machine(SUN) the same
program
> worked fine with an oracle 8.0.5 until yesterday when our DBA upgraded the
> DB .
> maybe I should remake the DBD:Oracle on the machine(sounds weired to me?)
> 
> thanks
> 
> 
> 
> -Original Message-
> From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 5:04 PM
> To: Ron Peled
> Cc: [EMAIL PROTECTED]
> Subject: RE: Oracle 9i
> 
> 
> 
> I found it works fine.  You have a listner problem,
> 
> 12514, 0, "TNS:listener could not resolve SERVICE_NAME given in
connect
> descriptor"
> // *Cause:  The SERVICE_NAME in the CONNECT_DATA was not found in the
> listener's tables.
> // *Action: Check to make sure that the SERVICE_NAME specified is correct.
> // *Comment: This error will be returned if the database instance has not 
> // registered with the listener; the instance may need to be started.
> 
> the message from DBD::Oracle is that it can't find the above text,
which 
>is extracted from the Oracle Home directories.  Try 'oerr ora 12514'
from
>a shell prompt, see if the above message is printed.
> 
> On 04-Dec-01 Ron Peled wrote:
>> Hello every one
>>  
>> Does anybody know if there is a DBD:oracle that connects/work good with
>> Oracle 9i???
>> HELP!
>>  
>> I'm currently using DBI 1.20 and the DBD:ORACLE 1.12 and I keep getting
> the
>> lines :
>> Message 12514 not found; product=RDBMS;facility=ORA (DBD ERROR:
>> OCIServerAttach)
>>  
>>  
>> Thanks
>> Ron
> 
> --
> E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
> Date: 04-Dec-01
> Time: 08:59:33
> --

--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 04-Dec-01
Time: 10:31:22
--

RE: Oracle 9i

[bill thater]

On Tue, 4 Dec 2001,Ron Peled scribbled on the wall in glitter crayon:

->Hey Scott,
->
->   First of all thanks for the quick answer.
->Second :Connecting via SQLPLUS connects me to the DB just fine.Looking in
->the tnsnames.ora it looks just fine and so is the ORACLE_SID .
->I have to admit that I'm quite new at this.
->
->some facts that might help is that on the same machine(SUN) the same program
->worked fine with an oracle 8.0.5 until yesterday when our DBA upgraded the
->DB .
->maybe I should remake the DBD:Oracle on the machine(sounds weired to me?)

no it's not. if the DBA upgraded the database to a new version, the old libs
that you used to compile DBD::Oracle are changed or not there.  sounds like
remaking the DBD is the first step.



--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

One sees great things from the valley, only small things from the peak.   - G. K. 
Chesterton

RE: Oracle 9i

[Scott T. Hildreth]

If you want to use the 9i libraries, you definitely have to recomplie
DBD::Oracle.  If the 8.0.5 instance is still on the machine you could
use the current DBD::Oracle and connect through sqlnet,

$dbh = DBI->connect("dbi:Oracle:", 'user/passwd@sid', '', {});

 /\ 
  this would be the 9i instance.

On 04-Dec-01 Ron Peled wrote:
> Hey Scott,
> 
>First of all thanks for the quick answer.
> Second :Connecting via SQLPLUS connects me to the DB just fine.Looking in
> the tnsnames.ora it looks just fine and so is the ORACLE_SID .
> I have to admit that I'm quite new at this.
> 
> some facts that might help is that on the same machine(SUN) the same program
> worked fine with an oracle 8.0.5 until yesterday when our DBA upgraded the
> DB .
> maybe I should remake the DBD:Oracle on the machine(sounds weired to me?)
> 
> thanks
> 
> 
> 
> -Original Message-
> From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 5:04 PM
> To: Ron Peled
> Cc: [EMAIL PROTECTED]
> Subject: RE: Oracle 9i
> 
> 
> 
> I found it works fine.  You have a listner problem,
> 
> 12514, 0, "TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor"
> // *Cause:  The SERVICE_NAME in the CONNECT_DATA was not found in the
> listener's tables.
> // *Action: Check to make sure that the SERVICE_NAME specified is correct.
> // *Comment: This error will be returned if the database instance has not 
> // registered with the listener; the instance may need to be started.
> 
> the message from DBD::Oracle is that it can't find the above text, which 
>is extracted from the Oracle Home directories.  Try 'oerr ora 12514' from
>a shell prompt, see if the above message is printed.
> 
> On 04-Dec-01 Ron Peled wrote:
>> Hello every one
>>  
>> Does anybody know if there is a DBD:oracle that connects/work good with
>> Oracle 9i???
>> HELP!
>>  
>> I'm currently using DBI 1.20 and the DBD:ORACLE 1.12 and I keep getting
> the
>> lines :
>> Message 12514 not found; product=RDBMS;facility=ORA (DBD ERROR:
>> OCIServerAttach)
>>  
>>  
>> Thanks
>> Ron
> 
> --
> E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
> Date: 04-Dec-01
> Time: 08:59:33
> --

--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 04-Dec-01
Time: 10:31:22
--

RE: Oracle 9i

[Ron Peled]

Hey Scott,

   First of all thanks for the quick answer.
Second :Connecting via SQLPLUS connects me to the DB just fine.Looking in
the tnsnames.ora it looks just fine and so is the ORACLE_SID .
I have to admit that I'm quite new at this.

some facts that might help is that on the same machine(SUN) the same program
worked fine with an oracle 8.0.5 until yesterday when our DBA upgraded the
DB .
maybe I should remake the DBD:Oracle on the machine(sounds weired to me?)

thanks



-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 5:04 PM
To: Ron Peled
Cc: [EMAIL PROTECTED]
Subject: RE: Oracle 9i



I found it works fine.  You have a listner problem,

12514, 0, "TNS:listener could not resolve SERVICE_NAME given in connect
descriptor"
// *Cause:  The SERVICE_NAME in the CONNECT_DATA was not found in the
listener's tables.
// *Action: Check to make sure that the SERVICE_NAME specified is correct.
// *Comment: This error will be returned if the database instance has not 
// registered with the listener; the instance may need to be started.

the message from DBD::Oracle is that it can't find the above text, which 
   is extracted from the Oracle Home directories.  Try 'oerr ora 12514' from
   a shell prompt, see if the above message is printed.

On 04-Dec-01 Ron Peled wrote:
> Hello every one
>  
> Does anybody know if there is a DBD:oracle that connects/work good with
> Oracle 9i???
> HELP!
>  
> I'm currently using DBI 1.20 and the DBD:ORACLE 1.12 and I keep getting
the
> lines :
> Message 12514 not found; product=RDBMS;facility=ORA (DBD ERROR:
> OCIServerAttach)
>  
>  
> Thanks
> Ron

--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 04-Dec-01
Time: 08:59:33
--

RE: Oracle 9i

[Scott T. Hildreth]

I found it works fine.  You have a listner problem,

12514, 0, "TNS:listener could not resolve SERVICE_NAME given in connect descriptor"
// *Cause:  The SERVICE_NAME in the CONNECT_DATA was not found in the listener's 
tables.
// *Action: Check to make sure that the SERVICE_NAME specified is correct.
// *Comment: This error will be returned if the database instance has not 
// registered with the listener; the instance may need to be started.

the message from DBD::Oracle is that it can't find the above text, which 
   is extracted from the Oracle Home directories.  Try 'oerr ora 12514' from
   a shell prompt, see if the above message is printed.

On 04-Dec-01 Ron Peled wrote:
> Hello every one
>  
> Does anybody know if there is a DBD:oracle that connects/work good with
> Oracle 9i???
> HELP!
>  
> I'm currently using DBI 1.20 and the DBD:ORACLE 1.12 and I keep getting the
> lines :
> Message 12514 not found; product=RDBMS;facility=ORA (DBD ERROR:
> OCIServerAttach)
>  
>  
> Thanks
> Ron

--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 04-Dec-01
Time: 08:59:33
--

Re: Oracle 9i/dbd

[Stephen Clouse]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Fri, Aug 17, 2001 at 03:00:27PM -0400, Jeff Besecker wrote:
> I have installed Oracle 9i on a RH 7.1 server.  I have done a database 
> install to make sure I got all of the required files.  I can connect to a 
> remote database using sqlplus.  I have installed DBI 1.19, make test and make 
> install work.  I am trying to install DBD 1.07 for Oracle. On "make test"  I 
> am receiving the following output.  I have searched everywhere and tried a few 
> solutions but none have worked (README's included).  Any ideas?
>
> PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i3
> 86-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verbose); $v
> erbose=0; runtests @ARGV;' t/*.t
> t/base..ok 3/5FAILED tests 4-5
> Failed 2/5 tests, 60.00% okay
> t/general...install_driver(Oracle) failed: Can't load 'blib/arch/auto/DB
> D/Oracle/Oracle.so' for module DBD::Oracle: blib/arch/auto/DBD/Oracle/Oracle.so:
>  undefined symbol: OCIServerAttach at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader
> .pm line 200.

Make sure the Oracle libraries are in the library search path.  On Linux the 
best solution is to add $ORACLE_HOME/lib to /etc/ld.so.conf and run ldconfig.

- -- 
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. 

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8

iQA/AwUBO4F4XAOGqGs0PadnEQKCGgCg310eEsA1tTgXzeIHpT3c6C2vCMYAoMWD
fRZBja85qgH2iJKnUN3g1dh2
=JP0G
-END PGP SIGNATURE-

Re: oracle 9i

[Tim Bunce]

On Thu, Jun 28, 2001 at 04:46:46PM +0200, Sipke Visser wrote:
> Hi,
> 
> does anybody know about a driver for oracle 9i?
> the driver for 7/8 doesn't seem to work...

Hey, here's an idea... how you you phrase it this way:

I'm getting this error when I try to build DBD::Oracle for 9i:

[insert error message here]

Here's the information that the README file asks for

[insert information here]

:-)

Tim.

p.s. If someone sends me a CD of Oracle 9i for Solaris then I'll be
able to test it myself.