From owner-freebsd-database@FreeBSD.ORG Tue Oct 10 21:06:20 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C10B316A4C9 for ; Tue, 10 Oct 2006 21:06:20 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 37FD843DA0 for ; Tue, 10 Oct 2006 21:06:04 +0000 (GMT) (envelope-from freebsd-database@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1GXOmc-0006Vp-FK for freebsd-database@freebsd.org; Tue, 10 Oct 2006 23:05:02 +0200 Received: from r5h168.net.upc.cz ([86.49.7.168]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 10 Oct 2006 23:05:02 +0200 Received: from gamato by r5h168.net.upc.cz with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 10 Oct 2006 23:05:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: martinko Date: Tue, 10 Oct 2006 22:59:34 +0200 Lines: 46 Message-ID: <452C09B6.4030009@pobox.sk> References: <20060711162744.A22592@malcolm.berkeley.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: r5h168.net.upc.cz User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.0.7) Gecko/20060923 SeaMonkey/1.0.5 In-Reply-To: <20060711162744.A22592@malcolm.berkeley.edu> Sender: news Cc: freebsd-questions@freebsd.org Subject: Re: Installing Oracle Client 10g on FreeBSD X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Oct 2006 21:06:20 -0000 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 ? From owner-freebsd-database@FreeBSD.ORG Tue Oct 10 22:12:11 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7AA0916A40F; Tue, 10 Oct 2006 22:12:11 +0000 (UTC) (envelope-from dwiest@vailsys.com) Received: from cprobd02.vailsys.com (cprobd02.vailsys.com [63.210.102.130]) by mx1.FreeBSD.org (Postfix) with ESMTP id D92B643D69; Tue, 10 Oct 2006 22:12:06 +0000 (GMT) (envelope-from dwiest@vailsys.com) Received: from dfsfbd06.vail (dfsfbd06.vail [192.168.129.190]) by cprobd02.vailsys.com (Postfix) with ESMTP id 1E462CE4F5; Tue, 10 Oct 2006 17:12:06 -0500 (CDT) Received: from dfwdamian.vail (dfwdamian.vail [192.168.129.233]) by dfsfbd06.vail (Postfix) with ESMTP id C5CF3323E8D; Tue, 10 Oct 2006 17:12:05 -0500 (CDT) Received: from dfwdamian.vail (dwiest@localhost.vail [127.0.0.1]) by dfwdamian.vail (8.13.4/8.13.4) with ESMTP id k9AM9Y8R030385; Tue, 10 Oct 2006 17:09:34 -0500 (CDT) Received: (from dwiest@localhost) by dfwdamian.vail (8.13.4/8.13.4/Submit) id k9AM9Yd5024016; Tue, 10 Oct 2006 17:09:34 -0500 (CDT) X-Authentication-Warning: dfwdamian.vail: dwiest set sender to dwiest@vailsys.com using -f Date: Tue, 10 Oct 2006 17:09:34 -0500 From: Damian Wiest Message-ID: <20061010220934.GA1484@dfwdamian.vail> References: <20060711162744.A22592@malcolm.berkeley.edu> <452C09B6.4030009@pobox.sk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <452C09B6.4030009@pobox.sk> User-Agent: Mutt/1.4.2i Cc: freebsd-database@freebsd.org, freebsd-questions@freebsd.org Subject: Re: Installing Oracle Client 10g on FreeBSD X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Oct 2006 22:12:11 -0000 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 From owner-freebsd-database@FreeBSD.ORG Wed Oct 11 00:01:18 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9406516A403; Wed, 11 Oct 2006 00:01:18 +0000 (UTC) (envelope-from shildret@fbsd1.dyndns.org) Received: from flpi101.sbcis.sbc.com (flpi101.sbcis.sbc.com [207.115.20.70]) by mx1.FreeBSD.org (Postfix) with ESMTP id 363E743D53; Wed, 11 Oct 2006 00:01:18 +0000 (GMT) (envelope-from shildret@fbsd1.dyndns.org) X-ORBL: [75.4.100.191] Received: from fbsd1.dyndns.org (adsl-75-4-100-191.dsl.emhril.sbcglobal.net [75.4.100.191]) by flpi101.sbcis.sbc.com (8.13.7 out spool5000 dk/8.13.7) with ESMTP id k9B00cvP023928; Tue, 10 Oct 2006 17:00:38 -0700 Received: from fbsd1.dyndns.org (localhost [127.0.0.1]) by fbsd1.dyndns.org (8.13.8/8.13.8) with ESMTP id k9B00KQO051621; Tue, 10 Oct 2006 19:00:20 -0500 (CDT) (envelope-from shildret@fbsd1.dyndns.org) Received: (from shildret@localhost) by fbsd1.dyndns.org (8.13.8/8.13.8/Submit) id k9B00JJB051620; Tue, 10 Oct 2006 19:00:19 -0500 (CDT) (envelope-from shildret@fbsd1.dyndns.org) From: "Scott T. Hildreth" To: Damian Wiest In-Reply-To: <20061010220934.GA1484@dfwdamian.vail> References: <20060711162744.A22592@malcolm.berkeley.edu> <452C09B6.4030009@pobox.sk> <20061010220934.GA1484@dfwdamian.vail> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Tue, 10 Oct 2006 19:00:16 -0500 Message-Id: <1160524816.70546.287.camel@fbsd1.dyndns.org> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 FreeBSD GNOME Team Port Cc: freebsd-database@freebsd.org, freebsd-questions@freebsd.org Subject: Re: Installing Oracle Client 10g on FreeBSD X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 11 Oct 2006 00:01:18 -0000 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-users@perl.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-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" -- Scott T. Hildreth