Re: Perl DBI libraries for connecting 12c

2017-10-10 Thread John D Groenveld 
In message , Christopher Jones
 writes:
>For the record, Instant Client is available in Solaris packages: https://blogs
>.oracle.com/jmcp/oracle-instant-client:-now-available-in-ips

Have you noticed that Oracle ships 12.2 Instant Client
but only serves 12.1 IPS packages for Solaris 11?
http://pkg.oracle.com/solaris/release/manifest/0/database%2Foracle%2Finstantclient@12.1.0.2.0%2C5.11-3%3A20150720T213959Z>

>(This may not help Michael, who is using an older version of Solaris)

Nope.

John
groenv...@acm.org

Re: Perl DBI libraries for connecting 12c

2017-10-10 Thread Christopher Jones 



On 10/10/17 3:42 pm, John R Pierce wrote:

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



For the record, Instant Client is available in Solaris packages: 
https://blogs.oracle.com/jmcp/oracle-instant-client:-now-available-in-ips
(This may not help Michael, who is using an older version of Solaris)

Chris

--
http://twitter.com/ghrd

Re: Perl DBI libraries for connecting 12c

2017-10-10 Thread Martin J. Evans 

On 10/10/17 00:07, Bruce  Johnson wrote:



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.



You should probably get the sqlplus package as well as it is used if found, to 
determine the version of Oracle client you are using.

Without it, the Makefile might assume you are oracle 8.

Martin

Re: Perl DBI libraries for connecting 12c

2017-10-09 Thread 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

2017-10-09 Thread 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

2017-10-09 Thread 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: Perl DBI libraries for connecting 12c

2017-10-09 Thread 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

2017-10-09 Thread 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]<http://atmlb.com/2eBNAik>

Perl DBI libraries for connecting 12c

2017-10-09 Thread 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]