RE: Perl with Oracle 9.2
From: David P. Fannin (dpf_at_umr.edu)
Date: 10/14/03
- Next message: John W. Herbold: "RE: MYSQL where clause case sensitive?"
- Previous message: Christopher Grey: "Perl with Oracle 9.2"
- Maybe in reply to: Christopher Grey: "Perl with Oracle 9.2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 14 Oct 2003 07:08:32 -0500 To: "GREY,CHRISTOPHER (HP-Roseville,ex1)" <christopher.grey@hp.com>, <dbi-users@perl.org>
Chris,
As long as you keep the 8.1.7 ORACLE_HOME around to support your
existing perl installation, you should not have to recompile. In my
experience, the 8.1.x libraries work fine for communicating with Oracle
9.x servers. My experience is limited to Red Hat Linux, though.
I have compiled DBD::Oracle for perl 5.6 against the libraries provided
by a 9.2.0.x Oracle client installation running on RedHat 7.3. I do not
remember having any problems with the compile; this code is in
production use.
Some information about your operating environment -- operating system,
version of DBI/DBD::Oracle, etc. -- might be useful in coming up with a
solution.
-dpf-
-----------------------
David P. Fannin
Database Administrator dpf@umr.edu
UM-Rolla Information Technology FAX (573) 341-4216
URL http://www.umr.edu/~dpf PHONE (573) 341-4841
-----------------------
-----Original Message-----
From: GREY,CHRISTOPHER (HP-Roseville,ex1)
[mailto:christopher.grey@hp.com]
Sent: Monday, October 13, 2003 5:11 PM
To: dbi-users@perl.org
Subject: Perl with Oracle 9.2
There seems to be an issue with perl when using 9.2 Oracle.
We discovered this after upgrade from 8.1.7.4 to 9.2.0.4.
Perl programs get
Unable to create database handle ERROR OCIEnvInit
I am running into a lot of cases on the net via google where people are
having the same problem with 9.2 Oracle, but no one
has a solution.
Oracle states they don't support a re-compile with 9.2 oracle, so they
are no help.
There is evidence that you need to recompile or reinstall perl if you
upgrade from oracle 8i to 9.2.0.x.
I have some one who works with me who tried to recompile and there was a
missing 9.2 library in $ORACLE_HOME/lib32. I need to find out which.
Anyway does anyone have a solution to running perl 5.6 with 9.2.0.x
oracle????
Thanks, Chris
***************************************************
Office Hp: 916-785-0783
Hp email: christopher.grey@hp.com
***************************************************
- Next message: John W. Herbold: "RE: MYSQL where clause case sensitive?"
- Previous message: Christopher Grey: "Perl with Oracle 9.2"
- Maybe in reply to: Christopher Grey: "Perl with Oracle 9.2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
