RE: (Fwd) Perl with Oracle 12c

[Seidler, Reinhard]

Thanks to all. Who could know the compiled Oracle client version? 11.2 would be 
fine and certified by Oracle...

Cheers
Reinhard

From: John Scoles [mailto:byter...@hotmail.com]
Sent: Tuesday, April 10, 2018 6:26 PM
To: Seidler, Reinhard; dbi-users@perl.org
Subject: Re: (Fwd) Perl with Oracle 12c



Hmm unless you change the installed clients you DBD::Oracle should still work. 
as 11->12 should work
If you are having problems you most likely will have to recompile DBD::Oracle 
against the new client

Checking DBD::Oracle I see it hasn't seen an update for at least 4 years or so 
and therefor not sure if you will need to re-compile and they do not list a 
compatibly chart anymore  so not 100% sure on the aboce.  Hopefully your 
DBD::Oracle was copiled against the 11.2 client and therefor you should have a 
seemless update to the 12 server.

cheers
John

From: tim.bu...@pobox.com 
>
Sent: April 10, 2018 11:02 AM
To: dbi-users@perl.org
Cc: Seidler, Reinhard
Subject: (Fwd) Perl with Oracle 12c

- Forwarded message from "Seidler, Reinhard" 
> 
-

Date: Tue, 10 Apr 2018 12:16:09 +
From: "Seidler, Reinhard" 
>
To: "tim.bu...@pobox.com" 
>
Subject: Perl with Oracle 12c

   Hi Tim,

   We develop Perl applications connecting and working with Oracle database 
(DBD:Oracle). So far it was
   Oracle version 11. Now the database will be migrated to 12.2.0.1. How should 
we deal with that? Any
   answer would be appreciated.

   Thanks in advance.

   With best regards
   Reinhard

   ***
   Reinhard Seidler
   Automation Engineer

   Advanced Mask Technology Center GmbH & Co. KG
 Phone:  [+49] (0) 351 4048 384
 Fax:   [+49] (0) 351 4048 189
 [1]mailto:reinhard.seid...@amtc-dresden.com

 Advanced Mask Technology Center GmbH & Co. KG
 Raehnitzer Allee 9  | D-01109 Dresden | GERMANY
 Sitz: Dresden
 Registergericht:Dresden
 HRA Nummer:   HRA 4820

 persönlich haftender Gesellschafter:
 Advanced Mask Technology Center Verwaltungs GmbH
 Sitz des persönlich haftenden Gesellschafters: Dresden
 Registergericht:  Dresden
 HRB-Nummer: HRB 22745
 Geschäftsführer:Thomas Schmidt
   ***

   Diese Mail einschliesslich der Anhänge könnte vertraulich sein. Sollten Sie 
nicht der beabsichtigte
   Empfänger dieser Mail sein, so ist jegliches Verwenden, Offenbaren oder 
Kopieren der Mail und ihrer
   Anhänge untersagt.
   Bitte informieren Sie den Absender und löschen Sie die Mail und deren 
Anhänge von Ihrem Rechner.
   Vielen Dank.

   This email and its attachments may be confidential and/or privileged. If you 
are not the intended
   recipient, any use, disclosure or copying of this email and its attachments 
is prohibited.
   If you have received this email in error, please notify immediately the 
sender by return email and
   delete this email and its attachments from your computer system. Thank you.




References

   Visible links
   1. mailto:reinhard.seid...@amtc-dresden.com

- End forwarded message -

RE: (Fwd) Perl with Oracle 12c

[Fennell, Brian]

DBD::Oracle is hard to build from source  . . . just went thru this.
If you don't build from source it may not be compatible with your Oracle shared 
libraries, OS Shared libraries or Oracle Server.
Consider carefully Oracle client and server characterset (and Perl 
characterset, and OS characterset) - two flavors of Oracle "text" objects need 
to be considered - "CHAR" and "WCHAR" - for 8 combinations.
UTF-8 end-to-end would be nice, but your environment may not allow (ours 
didn't).
Read the general and the platform specific Troubleshooting guide here:
https://metacpan.org/release/DBD-Oracle

If you have to report a bug (or want to see is an error you are getting is a 
known bug) . . .
Bug tracker is here:
https://rt.cpan.org/Public/Dist/Display.html?Name=DBD-Oracle
And here:
https://github.com/pythian/DBD-Oracle/issues

I found this one instructive:

install DBD::Oracle from CPAN - various problems #47
https://github.com/pythian/DBD-Oracle/issues/47

You will need not only the client installed but the Oracle "demo" DVD-ROM files 
which include the "sample" makefiles (which are required prerequisites for 
building DBD::Oracle - making them more "code" than "sample").
Also there is no maintainer for the DBD::Oracle module - or at least the 
maintainer is not active.  There is a "co-maintainer" but he basically 
maintains a fork in git now, so the official CPAN module is old.  Wasn't able 
to find "build from git" instructions.  I guess it is "git clone 
https://github.com/pythian/DBD-Oracle.git; followed by "perl Makefile.PL ; make 
; make test ; make install" (the usual incantation from the MakeMaker 
documentation).  If you reach out to him via CPAN he might respond.
I found a bug in the latest version (memory leak exposed when reading a very 
large number of rows, something to do with Unicode/Characterset conversion and 
buffer size), had to downgrade the perl AND the DBD::Oracle to work-around.
Prerequisites are gcc, gnu make, and Oracle Client that matches your database 
(or older client, but not too old).  Look for a ftp CPAN mirror ( 
http://mirrors.cpan.org/ ) if you want to download an older version to work 
around a bug.
If you are not already familiar - read up on 
https://metacpan.org/pod/ExtUtils::MakeMaker especially the section "Default 
Makefile Behaviour" (and other sections) - which is the hidden documentation to 
"how CPAN modules really work".
Seriously consider the DBD::JDBC module with Oracle JDBC driver (you will need 
a java process to act as a proxy).
If you want to build the DBD::Oracle module try to build it on a test box 
similar to your production box and post results here if you run into errors 
(compile errors or runtime errors).
Allocate time in your project for trial and error.  No "point and shoot" 
solution.  OS type and version matters if you are looking for a how-to on the 
internet.  Read all the README and INSTALL files.  Carefully.  Twice.

Re: (Fwd) Perl with Oracle 12c

[Bruce Johnson]

On Apr 10, 2018, at 8:02 AM, tim.bu...@pobox.com 
wrote:

- Forwarded message from "Seidler, Reinhard" 
> 
-

Date: Tue, 10 Apr 2018 12:16:09 +
From: "Seidler, Reinhard" 
>
To: "tim.bu...@pobox.com" 
>
Subject: Perl with Oracle 12c

  Hi Tim,

  We develop Perl applications connecting and working with Oracle database 
(DBD:Oracle). So far it was
  Oracle version 11. Now the database will be migrated to 12.2.0.1. How should 
we deal with that? Any
  answer would be appreciated.

Here is the canonical client compatibility guide for Oracle Database.




--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs

Re: (Fwd) Perl with Oracle 12c

[John D Groenveld]

In message <20180410150233.7hxxrlqqhwoysp7m@timac>, "tim.bu...@pobox.com" write
s:
>   We develop Perl applications connecting and working with Oracle database (D
>BD:Oracle). So far it was
>   Oracle version 11. Now the database will be migrated to 12.2.0.1. How shoul
>d we deal with that? Any
>   answer would be appreciated.

Relinking DBD::Oracle against InstantClient 12.2 is probably not required
but something I would do.

John
groenv...@acm.org

(Fwd) Perl with Oracle 12c

[tim.bu...@pobox.com]

- Forwarded message from "Seidler, Reinhard" 
 -

Date: Tue, 10 Apr 2018 12:16:09 +
From: "Seidler, Reinhard" 
To: "tim.bu...@pobox.com" 
Subject: Perl with Oracle 12c

   Hi Tim,

   We develop Perl applications connecting and working with Oracle database 
(DBD:Oracle). So far it was
   Oracle version 11. Now the database will be migrated to 12.2.0.1. How should 
we deal with that? Any
   answer would be appreciated.

   Thanks in advance.

   With best regards
   Reinhard

   ***
   Reinhard Seidler
   Automation Engineer

   Advanced Mask Technology Center GmbH & Co. KG
 Phone:  [+49] (0) 351 4048 384
 Fax:   [+49] (0) 351 4048 189
 [1]mailto:reinhard.seid...@amtc-dresden.com

 Advanced Mask Technology Center GmbH & Co. KG
 Raehnitzer Allee 9  | D-01109 Dresden | GERMANY
 Sitz: Dresden
 Registergericht:Dresden
 HRA Nummer:   HRA 4820

 persönlich haftender Gesellschafter:
 Advanced Mask Technology Center Verwaltungs GmbH
 Sitz des persönlich haftenden Gesellschafters: Dresden
 Registergericht:  Dresden
 HRB-Nummer: HRB 22745
 Geschäftsführer:Thomas Schmidt
   ***

   Diese Mail einschliesslich der Anhänge könnte vertraulich sein. Sollten Sie 
nicht der beabsichtigte
   Empfänger dieser Mail sein, so ist jegliches Verwenden, Offenbaren oder 
Kopieren der Mail und ihrer
   Anhänge untersagt.
   Bitte informieren Sie den Absender und löschen Sie die Mail und deren 
Anhänge von Ihrem Rechner.
   Vielen Dank.

   This email and its attachments may be confidential and/or privileged. If you 
are not the intended
   recipient, any use, disclosure or copying of this email and its attachments 
is prohibited.
   If you have received this email in error, please notify immediately the 
sender by return email and
   delete this email and its attachments from your computer system. Thank you.




References

   Visible links
   1. mailto:reinhard.seid...@amtc-dresden.com

- End forwarded message -