From owner-freebsd-database@FreeBSD.ORG Mon Oct 27 21:22:21 2008 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id DF55B1065679 for ; Mon, 27 Oct 2008 21:22:21 +0000 (UTC) (envelope-from ady@ady.ro) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.184]) by mx1.freebsd.org (Postfix) with ESMTP id 6E4FA8FC24 for ; Mon, 27 Oct 2008 21:22:21 +0000 (UTC) (envelope-from ady@ady.ro) Received: by fk-out-0910.google.com with SMTP id k31so2459352fkk.11 for ; Mon, 27 Oct 2008 14:22:19 -0700 (PDT) Received: by 10.181.158.3 with SMTP id k3mr1935730bko.182.1225142051877; Mon, 27 Oct 2008 14:14:11 -0700 (PDT) Received: by 10.181.37.7 with HTTP; Mon, 27 Oct 2008 14:14:11 -0700 (PDT) Message-ID: <78cb3d3f0810271414g157ee526pb4d745fb9c1428@mail.gmail.com> Date: Mon, 27 Oct 2008 22:14:11 +0100 From: "Adrian Penisoara" To: martinko In-Reply-To: <88acbbae0810230213k5bade96fq3bdeb89780f5f561@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <78cb3d3f0807260841k336f20a9jce857189c55adb16@mail.gmail.com> <78cb3d3f0807270122r4d2377d9gbf4e3ed5386918fa@mail.gmail.com> <20080727121503.679bc598@deskjail> <78cb3d3f0807271003q3f5ab72dr2147cf7b1a3348fc@mail.gmail.com> <48FE3708.8010501@users.sf.net> <20081021212134.GA79808@graf.pompo.net> <78cb3d3f0810221517k780e4cafy6418c42b8c845915@mail.gmail.com> <88acbbae0810230213k5bade96fq3bdeb89780f5f561@mail.gmail.com> Cc: freebsd-database@freebsd.org Subject: Re: Q: Is there any use for Oracle database port installation under Linux compat root ? 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: Mon, 27 Oct 2008 21:22:22 -0000 Hi, On Thu, Oct 23, 2008 at 10:13 AM, martinko wrote: [...] >> >> One more question: how usefull would it be to use the Linux (Bash) >> shell instead of a native (FreeBSD) shell ? >> > > I'm not sure. I think using our (native) bash would be OK. On the > other hand if linux bash is usually installed with linux_base or other > common linux port we could use it. Or maybe we could use linux > version if available and fall back to native version otherwise, if it > is doable of course. I would recommend asking someone who ported a > few linux apps dependent on bash. Actually I was hoping for some feedback from people effectively using Oracle[XE] on FreeBSD. Anyone ? > >> Thank you for your suggestions, I'm closer to the completion of the port. >> Adrian. >> > > Thank you for doing this! > > And btw what about standard Oracle RDBMS port ? The full blown Oracle RDBMS server has a standalone Java installer (the Oracle Universal Installer) and the Oracle DBA's are accustomed deploying it this way. On the other hand the Oracle installation tutorial in the FreeBSD ports could use some "freshening up" for newer versions. I will look into installing Oracle RDBMS after finishing up the OracleXE port(s). Regards, Adrian. From owner-freebsd-database@FreeBSD.ORG Tue Oct 28 16:15:59 2008 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 7FF811065673 for ; Tue, 28 Oct 2008 16:15:59 +0000 (UTC) (envelope-from shildret@scotth.emsphone.com) Received: from scotth.emsphone.com (scotth.emsphone.com [199.67.51.179]) by mx1.freebsd.org (Postfix) with ESMTP id 39C9D8FC16 for ; Tue, 28 Oct 2008 16:15:59 +0000 (UTC) (envelope-from shildret@scotth.emsphone.com) Received: from scotth.emsphone.com (localhost [127.0.0.1]) by scotth.emsphone.com (8.14.2/8.14.2) with ESMTP id m9SG4EoS037139; Tue, 28 Oct 2008 11:04:14 -0500 (CDT) (envelope-from shildret@scotth.emsphone.com) Received: (from shildret@localhost) by scotth.emsphone.com (8.14.2/8.14.2/Submit) id m9SG4Dpw037137; Tue, 28 Oct 2008 11:04:13 -0500 (CDT) (envelope-from shildret@scotth.emsphone.com) From: "Scott T. Hildreth" To: Adrian Penisoara In-Reply-To: <78cb3d3f0810271414g157ee526pb4d745fb9c1428@mail.gmail.com> References: <78cb3d3f0807260841k336f20a9jce857189c55adb16@mail.gmail.com> <78cb3d3f0807270122r4d2377d9gbf4e3ed5386918fa@mail.gmail.com> <20080727121503.679bc598@deskjail> <78cb3d3f0807271003q3f5ab72dr2147cf7b1a3348fc@mail.gmail.com> <48FE3708.8010501@users.sf.net> <20081021212134.GA79808@graf.pompo.net> <78cb3d3f0810221517k780e4cafy6418c42b8c845915@mail.gmail.com> <88acbbae0810230213k5bade96fq3bdeb89780f5f561@mail.gmail.com> <78cb3d3f0810271414g157ee526pb4d745fb9c1428@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Tue, 28 Oct 2008 11:04:13 -0500 Message-Id: <1225209853.31912.23.camel@scotth.emsphone.com> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 FreeBSD GNOME Team Port Cc: freebsd-database@freebsd.org, martinko Subject: Re: Q: Is there any use for Oracle database port installation under Linux compat root ? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: shildreth@allantgroup.com List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Oct 2008 16:15:59 -0000 On Mon, 2008-10-27 at 22:14 +0100, Adrian Penisoara wrote: > Hi, > > On Thu, Oct 23, 2008 at 10:13 AM, martinko wrote: > [...] > >> > >> One more question: how usefull would it be to use the Linux (Bash) > >> shell instead of a native (FreeBSD) shell ? > >> > > > > I'm not sure. I think using our (native) bash would be OK. On the > > other hand if linux bash is usually installed with linux_base or other > > common linux port we could use it. Or maybe we could use linux > > version if available and fall back to native version otherwise, if it > > is doable of course. I would recommend asking someone who ported a > > few linux apps dependent on bash. > > Actually I was hoping for some feedback from people effectively using > Oracle[XE] on FreeBSD. Anyone ? Sorry, I haven't read through the whole thread. I am not exactly sure what you are looking for, so I will just let you know how I run Oracle on FreeBSD. I haven't run an install since 8.x.x, since they went to the Java installer. I could never get it to stop locking up. So I copied a 9.2 directory from one of our linux servers. We install in the standard /u01/app/oracle/product/, I put the directory structure in /usr and created a /u01 link. The oracle user on my system does have the linux bash as its default shell, I only use this userid for running CreateDBs. Everything works great running with my standard userid and I also install gqlplus & sqldeveloper (very useful). I have a start up script in /usr/local/etc/rc.d, which starts up the listener and the db. I haven't had a need to upgrade to 10.x, but I am going to soon. Hope this isn't completely useless info for you. :-) > > > > >> Thank you for your suggestions, I'm closer to the completion of the port. > >> Adrian. > >> > > > > Thank you for doing this! > > > > And btw what about standard Oracle RDBMS port ? > > The full blown Oracle RDBMS server has a standalone Java installer > (the Oracle Universal Installer) and the Oracle DBA's are accustomed > deploying it this way. > On the other hand the Oracle installation tutorial in the FreeBSD > ports could use some "freshening up" for newer versions. I will look > into installing Oracle RDBMS after finishing up the OracleXE port(s). > > Regards, > Adrian. > _______________________________________________ > 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" From owner-freebsd-database@FreeBSD.ORG Wed Oct 29 17:25:54 2008 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D6AF4106564A for ; Wed, 29 Oct 2008 17:25:54 +0000 (UTC) (envelope-from ady@ady.ro) Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.226]) by mx1.freebsd.org (Postfix) with ESMTP id B37578FC28 for ; Wed, 29 Oct 2008 17:25:54 +0000 (UTC) (envelope-from ady@ady.ro) Received: by rv-out-0506.google.com with SMTP id b25so91300rvf.43 for ; Wed, 29 Oct 2008 10:25:54 -0700 (PDT) Received: by 10.141.116.17 with SMTP id t17mr5034282rvm.251.1225301154327; Wed, 29 Oct 2008 10:25:54 -0700 (PDT) Received: by 10.141.129.4 with HTTP; Wed, 29 Oct 2008 10:25:54 -0700 (PDT) Message-ID: <78cb3d3f0810291025w62353a6bp73c6d2f9a4be788e@mail.gmail.com> Date: Wed, 29 Oct 2008 18:25:54 +0100 From: "Adrian Penisoara" To: shildreth@allantgroup.com In-Reply-To: <1225209853.31912.23.camel@scotth.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <78cb3d3f0807260841k336f20a9jce857189c55adb16@mail.gmail.com> <78cb3d3f0807271003q3f5ab72dr2147cf7b1a3348fc@mail.gmail.com> <48FE3708.8010501@users.sf.net> <20081021212134.GA79808@graf.pompo.net> <78cb3d3f0810221517k780e4cafy6418c42b8c845915@mail.gmail.com> <88acbbae0810230213k5bade96fq3bdeb89780f5f561@mail.gmail.com> <78cb3d3f0810271414g157ee526pb4d745fb9c1428@mail.gmail.com> <1225209853.31912.23.camel@scotth.emsphone.com> Cc: freebsd-database@freebsd.org, martinko Subject: Re: Q: Is there any use for Oracle database port installation under Linux compat root ? 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, 29 Oct 2008 17:25:54 -0000 Hi, On Tue, Oct 28, 2008 at 5:04 PM, Scott T. Hildreth wrote: [...] >> >> Actually I was hoping for some feedback from people effectively using >> Oracle[XE] on FreeBSD. Anyone ? > > Sorry, I haven't read through the whole thread. I am not exactly sure > what you are looking for, so I will just let you know how I run Oracle > on FreeBSD. I haven't run an install since 8.x.x, since they went to > the Java installer. I could never get it to stop locking up. So I > copied a 9.2 directory from one of our linux servers. We install in > the standard /u01/app/oracle/product/, I put the directory structure > in /usr and created a /u01 link. The oracle user on my system does > have the linux bash as its default shell, I only use this userid for > running CreateDBs. Everything works great running with my standard > userid and I also install gqlplus & sqldeveloper (very useful). I have > a start up script in /usr/local/etc/rc.d, which starts up the listener > and the db. I haven't had a need to upgrade to 10.x, but I am going > to soon. Hope this isn't completely useless info for you. :-) > Yes, it helps. So I will keep the option to offer a Linux Bash shell for the oracle user. Question is whether I should make it default the Linux bash shell or a FreeBSD shell ? Thank you, Adrian.