(1) Does the DBI:Oracle 1.14 support Oracle 9.2 in HPUX 10? We had Oracle upgraded from 8.1.7 to 9.2, but still keep the DBD:Oracle 1.14. After "perl Makefile.PL", "make",we had the error message:
ld: Can't find library: "qsmashr" *** Error exit code 1 (2) I downloaded the latest DBD:Oracle 1.16 RC7 from your suggested site, saved it to my local pc, then tried to unzip it by Winzip, it won't open. Does it work only for Unix: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc7-20040826.tar.gz (3)Do we need to download the latest DBI:Oracle, in order to work with above DBD:Oracle 1.16 in HPUNIX? ftp://ftp.esoftmatic.com/outgoing/DBI/ --> DBI 5.8.4? Thanks. George -----Original Message----- From: HSIA, GEORGE (SBCSI) Sent: Friday, October 01, 2004 3:20 PM To: 'Hardy Merrill'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: DBI and Oracle 9.2 & Complete Step-by-Step Instructions Hardy and Tim, I am having the same question. Our Oracle dba has just upgraded from 8.1.7 to 9.2. 1)where & how to get the new DBI/DBD downloaded. 2)where are the step-by-step instructions to do all necessary recompilations or rebuilds? George Hsia SBC Services, Inc. -----Original Message----- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 4:29 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: DBI and Oracle 9.2 Just in case you didn't get the meaning behind Tim's comment, if you upgrade your version of Oracle, you then always need to rebuild DBD::Oracle. DBD::Oracle needs to be built _after_ installing any version of Oracle. >>> Tim Bunce <[EMAIL PROTECTED]> 09/17/04 06:21AM >>> Rebuild DBD::Oracle. Tim. On Thu, Sep 16, 2004 at 07:45:37AM -0700, Robert wrote: > > I have upgraded Oracle from 8.1.7 to 9.2, after changing to the new Oracle environment when I run the cgi script which always used to work in Oracle 8.1.7 to Oracle 9.2 is giving the following error. > Software error: > DBI connect('user1','user123',...) failed: ERROR OCIEnvInit at /home/user1/www/cgi-bin/test.cgi line 260 > > For help, please send mail to this site's webmaster, giving this error message and the time and date of the error. > > > > I have changed the Oracle 9.2 environment in the cgi script (OraHome1 is the Oracle 9.2 ) > > $ENV{ORACLE_HOME} = q[/ora1/u01/oracle/OraHome1]; > $ENV{LD_LIBRARY_PATH} = qq[$ENV{ORACLE_HOME}/lib]; > > > > Tnsping is working and also I can connect to oracle using sqlplus, is there any compatibility issue with DBI-1.43/DBD-Oracle-1.15 and Oracle 9.2? . > > > > Thanks in advance > > > > > > > > > > --------------------------------- > Do you Yahoo!? > vote.yahoo.com - Register online to vote today!
