Installing Oracle Client 10g on FreeBSD

Mike Friedman wrote:
> I'm running FreeBSD 5.4-RELEASE and I want to run a
current Oracle
> client-only with encryption support.
> 
> First, I installed the Oracle client port, which
represents Oracle 7.
> But my database support person tells me that's quite
old and, in fact,
> he couldn't be sure it would work (especially the
encryption part) with
> the Oracle database I'd be using (which he helps
support).  And I was
> getting some strange symptoms when I tested it.
> 
> So, he recommended that I download the Oracle 10g
Client for Linux.
> Since my FreeBSD system is configured for Linux
compatibility, I'm
> hoping this will work.  However, I can't even get the
Installer to
> complete!  It keeps telling me that I may not have
enough space in my
> root partition, even though I'm not trying to install
into the root
> partition.  (The partition in which I'm installing has
lots of space).
> 
> In addition, I should say that the machine on which
this Oracle client
> will be installed is not running X Windows.  This means
I can't use the
> installation menus, so I've been running the
Installation tool with a
> 'response file'.  The response file, however, doesn't
have much
> flexibility.  In particular, when I'm told I may not
have enough space,
> it asks me if I want to continue, but there's no way
for me to reply
> 'yes' from the response file.
> 
> In any case, based on the installation logs, it really
looks like the
> Installation tool is looking at the root partition for
how much space is
> available.
> 
> I've found in the FreeBSD handbook an article on
installing Oracle 8.0.
> But it appears that there have been changes with 10g. 
Also, those
> instructions seem to assume a server install, so they
talk about setting
> some shared memory values and other things that may not
apply to me anyway.
> 
> Do I have any other options?  I don't want to install
the full Oracle
> package (client and server), just the client, so that I
can write some
> perl scripts to query a remote Oracle database.
> 
> Any suggestions?
> 
> Thanks.
> 
> Mike
> 

Mike, have you considered linux-oracle-instantclient-* ports
?

_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

On Tue, Oct 10, 2006 at 10:59:34PM +0200, martinko wrote:
> Mike Friedman wrote:
> > I'm running FreeBSD 5.4-RELEASE and I want to run
a current Oracle
> > client-only with encryption support.
> > 
> > First, I installed the Oracle client port, which
represents Oracle 7.
> > But my database support person tells me that's
quite old and, in fact,
> > he couldn't be sure it would work (especially the
encryption part) with
> > the Oracle database I'd be using (which he helps
support).  And I was
> > getting some strange symptoms when I tested it.
> > 
> > So, he recommended that I download the Oracle 10g
Client for Linux.
> > Since my FreeBSD system is configured for Linux
compatibility, I'm
> > hoping this will work.  However, I can't even get
the Installer to
> > complete!  It keeps telling me that I may not have
enough space in my
> > root partition, even though I'm not trying to
install into the root
> > partition.  (The partition in which I'm installing
has lots of space).
> > 
> > In addition, I should say that the machine on
which this Oracle client
> > will be installed is not running X Windows.  This
means I can't use the
> > installation menus, so I've been running the
Installation tool with a
> > 'response file'.  The response file, however,
doesn't have much
> > flexibility.  In particular, when I'm told I may
not have enough space,
> > it asks me if I want to continue, but there's no
way for me to reply
> > 'yes' from the response file.
> > 
> > In any case, based on the installation logs, it
really looks like the
> > Installation tool is looking at the root partition
for how much space is
> > available.
> > 
> > I've found in the FreeBSD handbook an article on
installing Oracle 8.0.
> > But it appears that there have been changes with
10g.  Also, those
> > instructions seem to assume a server install, so
they talk about setting
> > some shared memory values and other things that
may not apply to me anyway.
> > 
> > Do I have any other options?  I don't want to
install the full Oracle
> > package (client and server), just the client, so
that I can write some
> > perl scripts to query a remote Oracle database.
> > 
> > Any suggestions?
> > 
> > Thanks.
> > 
> > Mike
> > 
> 
> Mike, have you considered linux-oracle-instantclient-*
ports ?

If all you want to do is use Perl to access the database,
then why are 
you bothering with Oracle's client software?  Just use the
CPAN module 
to build and install DBD::Oracle.

Just curious, but how were you able to perform a silent
install wihout
a frame buffer?  I ran into this problem installing Oracle
9i, but used
xvfb as a workaround.

-Damian
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

On Tue, 2006-10-10 at 17:09 -0500, Damian Wiest wrote:
> On Tue, Oct 10, 2006 at 10:59:34PM +0200, martinko
wrote:
> > Mike Friedman wrote:
> > > I'm running FreeBSD 5.4-RELEASE and I want to
run a current Oracle
> > > client-only with encryption support.
> > > 
> > > First, I installed the Oracle client port,
which represents Oracle 7.
> > > But my database support person tells me
that's quite old and, in fact,
> > > he couldn't be sure it would work (especially
the encryption part) with
> > > the Oracle database I'd be using (which he
helps support).  And I was
> > > getting some strange symptoms when I tested
it.
> > > 
> > > So, he recommended that I download the Oracle
10g Client for Linux.
> > > Since my FreeBSD system is configured for
Linux compatibility, I'm
> > > hoping this will work.  However, I can't even
get the Installer to
> > > complete!  It keeps telling me that I may not
have enough space in my
> > > root partition, even though I'm not trying to
install into the root
> > > partition.  (The partition in which I'm
installing has lots of space).
> > > 
> > > In addition, I should say that the machine on
which this Oracle client
> > > will be installed is not running X Windows. 
This means I can't use the
> > > installation menus, so I've been running the
Installation tool with a
> > > 'response file'.  The response file, however,
doesn't have much
> > > flexibility.  In particular, when I'm told I
may not have enough space,
> > > it asks me if I want to continue, but there's
no way for me to reply
> > > 'yes' from the response file.
> > > 
> > > In any case, based on the installation logs,
it really looks like the
> > > Installation tool is looking at the root
partition for how much space is
> > > available.
> > > 
> > > I've found in the FreeBSD handbook an article
on installing Oracle 8.0.
> > > But it appears that there have been changes
with 10g.  Also, those
> > > instructions seem to assume a server install,
so they talk about setting
> > > some shared memory values and other things
that may not apply to me anyway.
> > > 
> > > Do I have any other options?  I don't want to
install the full Oracle
> > > package (client and server), just the client,
so that I can write some
> > > perl scripts to query a remote Oracle
database.
> > > 
> > > Any suggestions?
> > > 
> > > Thanks.
> > > 
> > > Mike
> > > 
> > 
> > Mike, have you considered
linux-oracle-instantclient-* ports ?
> 
> If all you want to do is use Perl to access the
database, then why are 
> you bothering with Oracle's client software?  Just use
the CPAN module 
> to build and install DBD::Oracle.

   He can't, DBD::Oracle uses oci underneath so he needs the
Oracle client to get the shared 
   libraries.   Mike you also need to compile or install a
linux perl and then install DBI & DBD::Oracle
   with the linux perl.  You could use DBD::Proxy instead of
installing DBD::Oracle.  It installed
    with DBI.  Type 'perldoc DBD::Proxy' to see the docs. 
If you need help, you can email me 
   or join the dbi-usersperl.org.


> 
> Just curious, but how were you able to perform a silent
install wihout
> a frame buffer?  I ran into this problem installing
Oracle 9i, but used
> xvfb as a workaround.
> 
> -Damian
> _______________________________________________
> freebsd-databasefreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"
-- 
Scott T. Hildreth <shildretfbsd1.dyndns.org>
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

Hello,

Scott T. Hildreth wrote:
>    He can't, DBD::Oracle uses oci underneath so he
needs the Oracle client to get the shared 
>    libraries.   Mike you also need to compile or
install a linux perl and then install DBI & DBD::Oracle
>    with the linux perl.  You could use DBD::Proxy
instead of installing DBD::Oracle.  It installed
>     with DBI.  Type 'perldoc DBD::Proxy' to see the
docs.  If you need help, you can email me 
>    or join the dbi-usersperl.org.

Not fully correct - when I wanted to use DBD::Oracle, I did
not need to 
install linux-perl - just instantclient (linux compatibility
enabled) as 
Martinko mentioned. And it worked. And DBD::Oracle has been
used with 
native perl.


Martin
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

On Sun, 2006-10-15 at 11:30 +0200, Martin Hudec wrote:
> Hello,
> 
> Scott T. Hildreth wrote:
> >    He can't, DBD::Oracle uses oci underneath so he
needs the Oracle client to get the shared 
> >    libraries.   Mike you also need to compile or
install a linux perl and then install DBI & DBD::Oracle
> >    with the linux perl.  You could use DBD::Proxy
instead of installing DBD::Oracle.  It installed
> >     with DBI.  Type 'perldoc DBD::Proxy' to see
the docs.  If you need help, you can email me 
> >    or join the dbi-usersperl.org.
> 
> Not fully correct - when I wanted to use DBD::Oracle, I
did not need to 
> install linux-perl - just instantclient (linux
compatibility enabled) as 
> Martinko mentioned. And it worked. And DBD::Oracle has
been used with 
> native perl.

  Interesting, I have not used the instantclient.  I always
have a full 
  Oracle install, since I need the database.  I will try
that, 
  DBD::Oracle must not be linking with the libcltnsh.so.


> 
> 
> Martin
> _______________________________________________
> freebsd-databasefreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"
-- 
Scott T. Hildreth <shildretscotth.emsphone.com>
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

	I'm also interested of mixing native FreeBSD libraries and
Linux once, if it's possible ...

	I tryed to install a DBD::Oracle module with natively build
FreeBSD perl and Linux Oracle Instantclient. After some
hacking of DBD::Oracle's make file, i managed to build
native Oracle.so linked against Instantclient's libcltnsh.so
library.

	When i tryed "use DBD::Oracle" in a perl script i
got "Segmentation fault".
	I don't think it's possible to intermix native FreeBSD
libraries and Linux once used by a native FreeBSD
executable.

		Vladimir


On Mon, 16 Oct 2006 08:55:45 -0500
"Scott T. Hildreth" <shildretscotth.emsphone.com> wrote:

> On Sun, 2006-10-15 at 11:30 +0200, Martin Hudec wrote:
> > Hello,
> > 
> > Scott T. Hildreth wrote:
> > >    He can't, DBD::Oracle uses oci underneath
so he needs the Oracle client to get the shared 
> > >    libraries.   Mike you also need to compile
or install a linux perl and then install DBI &
DBD::Oracle
> > >    with the linux perl.  You could use
DBD::Proxy instead of installing DBD::Oracle.  It installed
> > >     with DBI.  Type 'perldoc DBD::Proxy' to
see the docs.  If you need help, you can email me 
> > >    or join the dbi-usersperl.org.
> > 
> > Not fully correct - when I wanted to use
DBD::Oracle, I did not need to 
> > install linux-perl - just instantclient (linux
compatibility enabled) as 
> > Martinko mentioned. And it worked. And DBD::Oracle
has been used with 
> > native perl.
> 
>   Interesting, I have not used the instantclient.  I
always have a full 
>   Oracle install, since I need the database.  I will
try that, 
>   DBD::Oracle must not be linking with the
libcltnsh.so.
> 
> 
> > 
> > 
> > Martin
> > _______________________________________________
> > freebsd-databasefreebsd.org mailing list
> > http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> > To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"
> -- 
> Scott T. Hildreth <shildretscotth.emsphone.com>
> _______________________________________________
> freebsd-databasefreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

On Mon, 2006-10-16 at 17:18 +0300, Vladimir Terziev wrote:
> 	I'm also interested of mixing native FreeBSD libraries
and Linux once, if it's possible ...
> 
> 	I tryed to install a DBD::Oracle module with natively
build FreeBSD perl and Linux Oracle Instantclient. After
some hacking of DBD::Oracle's make file, i managed to build
native Oracle.so linked against Instantclient's libcltnsh.so
library.
> 
> 	When i tryed "use DBD::Oracle" in a perl
script i got "Segmentation fault".
> 	I don't think it's possible to intermix native FreeBSD
libraries and Linux once used by a native FreeBSD
executable.

          I didn't either, but I am going to try. 

          Martin, how did you do this?


> 
> 		Vladimir
> 
> 
> On Mon, 16 Oct 2006 08:55:45 -0500
> "Scott T. Hildreth" <shildretscotth.emsphone.com> wrote:
> 
> > On Sun, 2006-10-15 at 11:30 +0200, Martin Hudec
wrote:
> > > Hello,
> > > 
> > > Scott T. Hildreth wrote:
> > > >    He can't, DBD::Oracle uses oci
underneath so he needs the Oracle client to get the shared 
> > > >    libraries.   Mike you also need to
compile or install a linux perl and then install DBI &
DBD::Oracle
> > > >    with the linux perl.  You could use
DBD::Proxy instead of installing DBD::Oracle.  It installed
> > > >     with DBI.  Type 'perldoc DBD::Proxy'
to see the docs.  If you need help, you can email me 
> > > >    or join the dbi-usersperl.org.
> > > 
> > > Not fully correct - when I wanted to use
DBD::Oracle, I did not need to 
> > > install linux-perl - just instantclient
(linux compatibility enabled) as 
> > > Martinko mentioned. And it worked. And
DBD::Oracle has been used with 
> > > native perl.
> > 
> >   Interesting, I have not used the instantclient. 
I always have a full 
> >   Oracle install, since I need the database.  I
will try that, 
> >   DBD::Oracle must not be linking with the
libcltnsh.so.
> > 
> > 
> > > 
> > > 
> > > Martin
> > >
_______________________________________________
> > > freebsd-databasefreebsd.org mailing list
> > > http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> > > To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"
> > -- 
> > Scott T. Hildreth <shildretscotth.emsphone.com>
> > _______________________________________________
> > freebsd-databasefreebsd.org mailing list
> > http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> > To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"
-- 
Scott T. Hildreth <shildrethallantgroup.com>
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

Hello,


Scott T. Hildreth wrote:
>           I didn't either, but I am going to try. 
> 
>           Martin, how did you do this?

Well, as I've already had linux compatibility present in the
system, 
I've installed instantclient for linux and built
DBD::Oracle.

Currently I have it uninstalled as it is no longer needed
for me, but I 
can try it and provide with instructions.

DBD::Oracle was being used by CMS system of my previous
employer, and 
that CMS was based on native perl stuff, not linux perl
stuff.


Martin
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

	I'll be very thankful if you provide working instructions
how to intermix FreeBSD and Linux libraries.

	Thanks in advance!

		Vladimir

On Mon, 16 Oct 2006 17:51:01 +0200
Martin Hudec <corwinaeternal.net> wrote:

> Hello,
> 
> 
> Scott T. Hildreth wrote:
> >           I didn't either, but I am going to try.

> > 
> >           Martin, how did you do this?
> 
> Well, as I've already had linux compatibility present
in the system, 
> I've installed instantclient for linux and built
DBD::Oracle.
> 
> Currently I have it uninstalled as it is no longer
needed for me, but I 
> can try it and provide with instructions.
> 
> DBD::Oracle was being used by CMS system of my previous
employer, and 
> that CMS was based on native perl stuff, not linux perl
stuff.
> 
> 
> Martin
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

Hello Vladimir,

Vladimir Terziev wrote:
> 	I'll be very thankful if you provide working
instructions how to intermix FreeBSD and Linux libraries.
> 	Thanks in advance!

I sense bit of irony here, but I hope I just have wrong
feeling .
Mixing BSD and Linux libs? Well - what do you say on using
native 
Firefox with linux flash plugin? Works too.

I will try to do it, and let's hope I'll be able to get
oracle 
connection to test simple perl script as without it I am bit
lost (I 
used only client stuff, not full oracle database).

Martin
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"