DBD::Oracle and Oracle 8

--=_alternative 0053068EC1257110_=
Content-Type: text/plain; charset="US-ASCII"

Hello DBI users,

I need help/tips/suggestions whatever you can give.

I am developing a Perl script that accesses two databases. One database is
a DB2 and the other is Oracle 8.0.4.4.0. I use ActivePerl 5.8.7 and loaded
the DBD::Oracle module (v1.16) via the PPM system of ActivePerl. The
connection to the DB2 is fine. But when I am trying to connect to the
Oracle 8 database I get the following error:

ORA-03134: Connections to this server version are no longer supported.

It looks like the old version of the oracle database is way too old :) But
it is no option to upgrade the database, because it is in production.

I found version 1.15 of DBD::Oracle for the ppm system, but this doesn't
work either (same message). The changelog of version 1.16 says:"It no
longer supports the old Oracle 7 OCI Interface." I am not a oracle
specialist, but I don't think this is the point.

I tried the Oracle Instant Client 10.2.0.1 -- same errormessage. Then I
tried the little bit older 10.1.0.4 of it. Still no luck. It looks like
Oracle has stopped the support of Oracle 8.

Finally I tried to connect via Java JDBC and it worked. Not with the
recent version of the JDBC driver but with an older one. Before I will
rewrite it in Java, I thought this mailing list is my last hope :)

What should I do to get a connection from my little perl script? I have no
experience with ODBC, but I think it's the same problem there (yeah, the
database is pretty old).


Regards
Michael

--=_alternative 0053068EC1257110_=--

Re: DBD::Oracle and Oracle 8

On Thu, Feb 09, 2006 at 04:06:50PM +0100, Michael Kebe wrote:
> Hello DBI users,
>
> I need help/tips/suggestions whatever you can give.
>
> I am developing a Perl script that accesses two databases. One database is
> a DB2 and the other is Oracle 8.0.4.4.0. I use ActivePerl 5.8.7 and loaded
> the DBD::Oracle module (v1.16) via the PPM system of ActivePerl. The
> connection to the DB2 is fine. But when I am trying to connect to the
> Oracle 8 database I get the following error:
>
> ORA-03134: Connections to this server version are no longer supported.
>
> It looks like the old version of the oracle database is way too old :) But
> it is no option to upgrade the database, because it is in production.
>
> I found version 1.15 of DBD::Oracle for the ppm system, but this doesn't
> work either (same message). The changelog of version 1.16 says:"It no
> longer supports the old Oracle 7 OCI Interface." I am not a oracle
> specialist, but I don't think this is the point.
>
> I tried the Oracle Instant Client 10.2.0.1 -- same errormessage. Then I
> tried the little bit older 10.1.0.4 of it. Still no luck. It looks like
> Oracle has stopped the support of Oracle 8.

Oracle 10 no longer supports connecting to Oracle 8.

> Finally I tried to connect via Java JDBC and it worked. Not with the
> recent version of the JDBC driver but with an older one. Before I will
> rewrite it in Java, I thought this mailing list is my last hope :)
>
> What should I do to get a connection from my little perl script? I have no
> experience with ODBC, but I think it's the same problem there (yeah, the
> database is pretty old).

Install Oracle 9 and build DBD::Oracle using that.

Tim.

Re: DBD::Oracle and Oracle 8

I am going to spend a little time on this one later today. I will try to set
up a simialr enviornment but I think you will have to get an old version or
the Oracle client and Oracle installer to get it to work.

"Michael Kebe" wrote in message
news:OFE8471EE5.0F296228-ONC1257110.00508CD0-C1257110.005306 9D@de.ibm.com...
> Hello DBI users,
>
> I need help/tips/suggestions whatever you can give.
>
> I am developing a Perl script that accesses two databases. One database is
> a DB2 and the other is Oracle 8.0.4.4.0. I use ActivePerl 5.8.7 and loaded
> the DBD::Oracle module (v1.16) via the PPM system of ActivePerl. The
> connection to the DB2 is fine. But when I am trying to connect to the
> Oracle 8 database I get the following error:
>
> ORA-03134: Connections to this server version are no longer supported.
>
> It looks like the old version of the oracle database is way too old :) But
> it is no option to upgrade the database, because it is in production.
>
> I found version 1.15 of DBD::Oracle for the ppm system, but this doesn't
> work either (same message). The changelog of version 1.16 says:"It no
> longer supports the old Oracle 7 OCI Interface." I am not a oracle
> specialist, but I don't think this is the point.
>
> I tried the Oracle Instant Client 10.2.0.1 -- same errormessage. Then I
> tried the little bit older 10.1.0.4 of it. Still no luck. It looks like
> Oracle has stopped the support of Oracle 8.
>
> Finally I tried to connect via Java JDBC and it worked. Not with the
> recent version of the JDBC driver but with an older one. Before I will
> rewrite it in Java, I thought this mailing list is my last hope :)
>
> What should I do to get a connection from my little perl script? I have no
> experience with ODBC, but I think it's the same problem there (yeah, the
> database is pretty old).
>
>
> Regards
> Michael
>

Re: DBD::Oracle and Oracle 8

--=_alternative 0049CB02C1257111_=
Content-Type: text/plain; charset="US-ASCII"

> Install Oracle 9 and build DBD::Oracle using that.

Now it works! Thank you very much!

But I have one remark. I built it with the step by step guide by John
Scoles (README.win32.txt). But at step 16 (perl Makefile.PL) first I got
an errormessage that should have a litte hint. It says:

Unable to find required Oracle OCI files for the build. Please check
That you have your OCI installed in your oracle home (C:/oracle/ora92)
Directory and that it has the following files (and probably more):
C:/oracle/ora92\oci\include\oratypes.h
C:/oracle/ora92\oci\lib\MSVC\.lib
Please install OCI or send comments back to dbi-users@perl.org
If you have an OCI directory other than oci.
This errormessages says exactly that OCI need to be installed and that was
my case, too. You have to select the OCI (Oracle Call Interface) explicit
in the user-defined installation. I used the typical installation for an
administrator and there it was not included.
C:/oracle/ora92\oci\include\oratypes.h existed for me, but reading the
next line left me alone and I had no clue.
This file C:/oracle/ora92\oci\lib\MSVC/oramts.lib existed for me, too. So
I thought I have everything and changed one line in the Makefile.PL to get
it rid of the message and finishing the execution without an error of the
Makefile.PL. After that I tried to run nmake, and there I get an error
leading me to the solution: 'oci.h': No such file or directory.
After searching the web I found someone had compilation problems with a
Oracle and PHP. There I found, the solution to select explicit the OCI
during the Oracle installation. Here the link for germany speaking guys:
http://www.issociate.de/board/post/166488/PHP-Compilierung_+ _Oracle_Client_9.2.0.4.0:_oci.h_fehlt.html
Once again, thanks for the help!
Michael
--=_alternative 0049CB02C1257111_=--

Re: DBD::Oracle and Oracle 8

Glad you solved it.

"Michael Kebe" wrote in message
news:OFB4F82DE5.71286D4D-ONC1257111.00478A14-C1257111.0049CB 05@de.ibm.com...
> > Install Oracle 9 and build DBD::Oracle using that.
>
> Now it works! Thank you very much!
>
> But I have one remark. I built it with the step by step guide by John
> Scoles (README.win32.txt). But at step 16 (perl Makefile.PL) first I got
> an errormessage that should have a litte hint. It says:

Ok as that part of the README.win32.txt is for 10g installs I do not think
it should be changed as the number of permitaions with clients and versions
would make it too long.

> Unable to find required Oracle OCI files for the build. Please check
> That you have your OCI installed in your oracle home (C:/oracle/ora92)
> Directory and that it has the following files (and probably more):
> C:/oracle/ora92\oci\include\oratypes.h
> C:/oracle/ora92\oci\lib\MSVC\.lib
> Please install OCI or send comments back to dbi-users@perl.org

However, you are right the 'Hint' above is a little vauge and I might make
anothe change to the README.win32.txt to account for this I am a little
weary of chaning the Makefile.PL as It migh break for the present versions.

> If you have an OCI directory other than oci.
> This errormessages says exactly that OCI need to be installed and that was
> my case, too. You have to select the OCI (Oracle Call Interface) explicit
> in the user-defined installation. I used the typical installation for an
> administrator and there it was not included.
> C:/oracle/ora92\oci\include\oratypes.h existed for me, but reading the
> next line left me alone and I had no clue.
> This file C:/oracle/ora92\oci\lib\MSVC/oramts.lib existed for me, too. So
> I thought I have everything and changed one line in the Makefile.PL to get
> it rid of the message and finishing the execution without an error of the
> Makefile.PL. After that I tried to run nmake, and there I get an error
> leading me to the solution: 'oci.h': No such file or directory.
> After searching the web I found someone had compilation problems with a
> Oracle and PHP. There I found, the solution to select explicit the OCI
> during the Oracle installation. Here the link for germany speaking guys:

The question I have for you is. How were you installing Oracle 9, which
version or Oracle 9 client did you use and which version of DBD:Oracle. I
need this to recreate the problem then document it properly.

Or if you want write it up youself and I will then add it to the
README.win32.txt file for you.

Cheers

John Scoles