Re: Perl DBI libraries for connecting 12c

[John R Pierce]

On 10/9/2017 6:32 PM, Lincoln A Baxter wrote:
You can solve this problem by building your own perl with gcc. It's 
not that hard.
After build, install it in a location on path (actually you pick the 
install location has part of configuring the build).
Then you can build the DBI, and DBD::oracle. You do need to have the 
oracle client libraries and headers (which you have to get from Oracle).



or you could install the perl from sunfreeware/unix packages or opencsw.

--
john r pierce, recycling bits in santa cruz

Re: Perl DBI libraries for connecting 12c

[Lincoln A Baxter]

On Mon, 2017-10-09 at 15:52 -0700, John R Pierce wrote:
> On 10/9/2017 2:49 PM, Furst, Carl wrote:
> > I believe you have to go to Oracle to get those.. You can get DBI and even 
> > DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link 
> > off of. You’ll need to install an oracle client library.
> 
> 
> as I recall, to use CPAN and build modules that work with the Solaris 
> Perl, you have to have the Sun/Oracle Studio C compiler (formerly called 
> Forte), not GCC, unless you leap through some hoops.

You can solve this problem by building your own perl with gcc.  It's
not that hard.
After build, install it in a location on path (actually you pick the
install location has part of configuring the build).
Then you can build the DBI, and DBD::oracle.  You do need to have the
oracle client libraries and headers (which you have to get from
Oracle).

Lincoln

Re: Perl DBI libraries for connecting 12c

[Bruce Johnson]

> On Oct 9, 2017, at 3:52 PM, John R Pierce  wrote:
> 
> On 10/9/2017 2:49 PM, Furst, Carl wrote:
>> I believe you have to go to Oracle to get those.. You can get DBI and even 
>> DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link off 
>> of. You’ll need to install an oracle client library.
> 
> 
> as I recall, to use CPAN and build modules that work with the Solaris Perl, 
> you have to have the Sun/Oracle Studio C compiler (formerly called Forte), 
> not GCC, unless you leap through some hoops.
> 
> This used to work, but I've not been down these bunny trails for years and 
> years : http://search.cpan.org/~aburlison/Solaris-PerlGcc-1.3/pod/perlgcc.pod 
> ...  you also need to make sure you installed the full oracle developer stuff 
> as part of the client.  

With Instant Client you have to install the Basic and the SDK packages. The 
latter gets the developer header files and libs that DBD::Oracle uses to 
compile the c code.

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

Institutions do not have opinions, merely customs

Re: DBD::mysql path forward

[Patrick Galbraith]

Dan,

I think get the original work Pali did (I need to get the master-new he 
references below in) and also I need to figure out what it will 
inevitably mean for distribution packages. And test, and test. I need to 
also find the emails of people who had a problem last time and have a 
plan to get people able to adopt and use the driver changes and give 
them all the info they need to modify their code to work with the proper 
driver.


regards,

Patrick


On 10/04/2017 04:49 PM, Dan Book wrote:

How can we proceed from here?
-Dan

On Mon, Sep 18, 2017 at 1:17 PM, Patrick M. Galbraith > wrote:


Pali,

Great! Now we can start moving forward.

Sorry if my responses have been intermittent - first week at new job.

Regards,

Patrick

On 9/16/17 4:35 AM, p...@cpan.org  wrote:

I prepared branch master-new, which is based on current DBD-mysql master
branch and revert state to pre-4.043 version, including all changes done
after 4.043 release to master branch. I have this master-new branch in
my fork. If you want you can use it...

https://github.com/pali/DBD-mysql/tree/master-new

Re: Perl DBI libraries for connecting 12c

[John R Pierce]

On 10/9/2017 2:49 PM, Furst, Carl wrote:

I believe you have to go to Oracle to get those.. You can get DBI and even 
DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link off 
of. You’ll need to install an oracle client library.



as I recall, to use CPAN and build modules that work with the Solaris 
Perl, you have to have the Sun/Oracle Studio C compiler (formerly called 
Forte), not GCC, unless you leap through some hoops.


This used to work, but I've not been down these bunny trails for years 
and years : 
http://search.cpan.org/~aburlison/Solaris-PerlGcc-1.3/pod/perlgcc.pod 
...  you also need to make sure you installed the full oracle developer 
stuff as part of the client.    at least when I was doing this, it would 
NOT install as part of the 'server', you had to explicitly do an 
additional 'client' installation to get the right bunch of stuff 
unless I'm confusing this with Pro*C, something else our old stack required.



--
john r pierce, recycling bits in santa cruz

Re: Perl DBI libraries for connecting 12c

[Furst, Carl]

I believe you have to go to Oracle to get those.. You can get DBI and even 
DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link off 
of. You’ll need to install an oracle client library.

--
Carl Yamamoto-Furst


From: Michael Radakovich 
Date: Monday, October 9, 2017 at 5:46 PM
To: "dbi-users@perl.org" 
Subject: Perl DBI libraries for connecting 12c

  Hello,

  I need to install the Perl DBI libraries that are 
used by Perl scripts for connecting to an Oracle 12c database. The server is 
running Solaris 10 sparc
  Any help would be greatly appreciated.

# perl -v

This is perl, v5.8.4 built for sun4-solaris-64int
(with 37 registered patches, see perl -V for more detail)

Copyright 1987-2004, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'.  If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

Michael Radakovich
Engineer, Infrastructure II
Family Guy, Sports Junkie, Music Man
WOW! internet, cable & phone
--
desk: 630-536-3163mobile: 630-803-9048fax: 630-536-3108












[http://corpweb.mlb.com/MLB_COM_Disclaimed1.png]

Perl DBI libraries for connecting 12c

[Michael Radakovich]

  Hello,

  I need to install the Perl DBI libraries that are 
used by Perl scripts for connecting to an Oracle 12c database. The server is 
running Solaris 10 sparc
  Any help would be greatly appreciated.

# perl -v

This is perl, v5.8.4 built for sun4-solaris-64int
(with 37 registered patches, see perl -V for more detail)

Copyright 1987-2004, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'.  If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

Michael Radakovich
Engineer, Infrastructure II
Family Guy, Sports Junkie, Music Man
WOW! internet, cable & phone
--
desk: 630-536-3163mobile: 630-803-9048fax: 630-536-3108
[cid:image009.jpg@01D340F9.6E796440]
   [cid:image010.png@01D340F9.6E796440] 
   
[cid:image011.png@01D340F9.6E796440]
[cid:image012.png@01D340F9.6E796440]