From owner-freebsd-database@FreeBSD.ORG Tue Oct 21 21:05:03 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 3F02E1065780 for ; Tue, 21 Oct 2008 21:05:03 +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 B91F28FC0A for ; Tue, 21 Oct 2008 21:05:02 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1KsNYJ-0004tE-Du for freebsd-database@freebsd.org; Tue, 21 Oct 2008 20:10:03 +0000 Received: from 200.41.broadband11.iol.cz ([90.178.41.200]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 21 Oct 2008 20:10:03 +0000 Received: from gamato by 200.41.broadband11.iol.cz with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 21 Oct 2008 20:10:03 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: martinko Date: Tue, 21 Oct 2008 22:09:44 +0200 Lines: 136 Message-ID: <48FE3708.8010501@users.sf.net> References: <78cb3d3f0807260841k336f20a9jce857189c55adb16@mail.gmail.com> <78cb3d3f0807270122r4d2377d9gbf4e3ed5386918fa@mail.gmail.com> <20080727121503.679bc598@deskjail> <78cb3d3f0807271003q3f5ab72dr2147cf7b1a3348fc@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 200.41.broadband11.iol.cz User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.17) Gecko/20081009 SeaMonkey/1.1.12 In-Reply-To: Sender: news Cc: freebsd-database@freebsd.org, freebsd-emulation@freebsd.org, rofug@rofug.ro, freebsd-ports@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: Tue, 21 Oct 2008 21:05:03 -0000 Chagin Dmitry wrote: > On Sun, 27 Jul 2008, Adrian Penisoara wrote: > >> Hi, >> >> On Sun, Jul 27, 2008 at 1:15 PM, Alexander Leidinger < >> Alexander@leidinger.net> wrote: >> >>> Quoting "Adrian Penisoara" (Sun, 27 Jul 2008 >>> 11:22:20 >>> +0300): >>> >>>> Hi, >>>> >>>> I am working on a FreeBSD port for Oracle's XE database package[1] >>> (Linux >>>> binaries) and I stumbled upon some issues related to USE_LINUX_PREFIX. >>>> Before going any further trying to support (as an option) installing >>>> the >>>> Oracle XE directly under the /compat/linux hierarchy (like the >>>> database/linux-oracle-instantclient-* ports are doing), I have to >>>> ask ask >>>> around the following: >>>> >>>> (1) Is there any real need/benefit to have an Oracle DB installation >>> rooted >>>> under /compat/linux (e.g. /compat/linux/usr/lib/oracle/xe/...) ? Side >>> note: >>>> in this case all shell scripts will need to be ran under >>>> /compat/linux/bin/bash. >>>> >>>> (2) How does one deal with installing manual pages and shared files >>>> with >>>> USE_LINUX_PREFIX -- do they also have to go under /compat/linux ? Using >>>> ${MANPREFIX} as a template gives wrong results in this case... >>> >>> A port has to install into LINUXPREFIX, if it is an infrastructure >>> port (no part has to go outside this location). It has to install into >>> the default location (PREFIX/LOCALBASE), if it is an enduser port. >>> That's the easy part. >> >> >> Good pointer, I was missing this bit. Thanks. >> >> >>> >>> >>> Now the classification, what is what, is the hard part. The linux >>> png/jpeg or whatever lib is for sure infrastructure. If this would land >>> in the default FreeBSD lib path, rest assured it would hurt. A linux >>> acroread port is an enduser application, a user will call it directly >>> to work with it. It also does not come with libs in the default FreeBSD >>> locations, so everything will be fine if it is installed in the default >>> location. >>> >>> For the Oracle stuff I can imagine that it is a hard question. If it >>> doesn't put libs into a FreeBSD lib directory (a subdirectory of a lib >>> directory is ok, as it will not cause immediate problems), there are no >>> immediate objections to putting it into the default FreeBSD location >>> (and as the DBA as an enduser would use it, this would fit into the >>> description above). But we also have the rule that nothing is allowed >>> to be put into the basesystem (/usr/Y instead of /usr/local/Y). Think >>> about jails where the base is mounted read-only and only additional >>> programs are in a RW part. >> >> >> In the default configuration the binaries (and I mean all of them!) >> would >> be placed under /usr/lib/oracle, since this is a hardcoded path in all >> places. >> I will also offer a "WITH_BSDHIER" option which will root the >> installation >> into /usr/local/oracle and just make a symlink under /usr/lib. Should I >> rather make this the default ? ;) >> >> There are no libraries (or other binaries for that fact) installed >> outside >> the Oracle hierarchy (this is the general strategy for Oracle RDBMS >> products >> at least). So I guess it very nicely fits into the "enduser" picture you >> describe above. I'm just wandering whether a /compat/linux rooted >> installation would make sense. >> >> I am still interested to hear opinions from Oracle DBAs/users on this >> subject -- would you need this option ? >> > > hi! > > I think that ora DBAs will tell that the best place it /home/ORAUSERNAME > and this user should have shell /compat/linux/bin/bash > > thnx! > Hi, No Oracle installation I have ever seen was installed into /home and it would be against Oracle Optimal Flexible Architecture (OFA) guidelines! /usr/local/oracle would be OK and users can move the directory tree elsewhere afterwards. Or maybe you can ask about Oracle Base directory during config/installation process, if possible. Cheers, Martin PS: Mind you that Oracle installation is usually owned by Oracle software owner user (oinstall by default) who is different from DBA/operator users (dba/oper by default). >> >>> >>> >>> In the end it comes down to what you are able to do and how hard the >>> software is to port. Maybe it is easy to install everything into >>> LINUXBASE and install a wrapper into LOCALBASE (/usr/local/bin/Y would >>> be a script with #!/compat/linux/bin/bash and start whatever is needed >>> to start /compat/linux/bin/Y). Maybe the installation of the software >>> allows to install into /usr/local/softwarename and you can make links >>> from /usr/local/bin/ to it. >>> >>> The rules for this are strong suggestions. If it is possible to do, >>> do everything you can to follow the rules, if you don't know how to >>> make something follow the rules, ask specific questions on ports if >>> someone has in idea. If there's no idea, forget the rule and try to do >>> something as close as possible to the goal of the rule (and document >>> what/why). >>> >>> Bye, >>> Alexander. >>> >>> >> Thank you for your time. >> Adrian. From owner-freebsd-database@FreeBSD.ORG Tue Oct 21 21:45:08 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 1A30B1065671; Tue, 21 Oct 2008 21:45:08 +0000 (UTC) (envelope-from thierry@pompo.net) Received: from postfix2-g20.free.fr (postfix2-g20.free.fr [212.27.60.43]) by mx1.freebsd.org (Postfix) with ESMTP id A95458FC1D; Tue, 21 Oct 2008 21:45:07 +0000 (UTC) (envelope-from thierry@pompo.net) Received: from smtp7-g19.free.fr (smtp7-g19.free.fr [212.27.42.64]) by postfix2-g20.free.fr (Postfix) with ESMTP id 651A02BF3647; Tue, 21 Oct 2008 21:21:21 +0200 (CEST) Received: from smtp7-g19.free.fr (localhost [127.0.0.1]) by smtp7-g19.free.fr (Postfix) with ESMTP id C1E19B0163; Tue, 21 Oct 2008 23:21:35 +0200 (CEST) Received: from graf.pompo.net (unknown [78.225.128.39]) by smtp7-g19.free.fr (Postfix) with ESMTP id 687E5B010A; Tue, 21 Oct 2008 23:21:35 +0200 (CEST) Received: by graf.pompo.net (Postfix, from userid 1001) id EA4ED114B4; Tue, 21 Oct 2008 23:21:34 +0200 (CEST) Date: Tue, 21 Oct 2008 23:21:34 +0200 From: Thierry Thomas To: martinko Message-ID: <20081021212134.GA79808@graf.pompo.net> Mail-Followup-To: martinko , freebsd-ports@freebsd.org, freebsd-database@freebsd.org, freebsd-emulation@freebsd.org, rofug@rofug.ro References: <78cb3d3f0807260841k336f20a9jce857189c55adb16@mail.gmail.com> <78cb3d3f0807270122r4d2377d9gbf4e3ed5386918fa@mail.gmail.com> <20080727121503.679bc598@deskjail> <78cb3d3f0807271003q3f5ab72dr2147cf7b1a3348fc@mail.gmail.com> <48FE3708.8010501@users.sf.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <48FE3708.8010501@users.sf.net> X-Face: (hRbQnK~Pt7$ct`!fupO(`y_WL4^-Iwn4@ly-.,[4xC4xc; y=\ipKMNm<1J>lv@PP~7Z<.t KjAnXLs: User-Agent: Mutt/1.4.2.3i X-Operating-System: FreeBSD 7.0-STABLE i386 Organization: Kabbale Eros X-PGP: 0xC71405A2 Cc: freebsd-database@freebsd.org, freebsd-emulation@freebsd.org, rofug@rofug.ro, freebsd-ports@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: Tue, 21 Oct 2008 21:45:08 -0000 Le Mar 21 oct 08 à 22:09:44 +0200, martinko écrivait : > Hi, Hello, > No Oracle installation I have ever seen was installed into /home and it > would be against Oracle Optimal Flexible Architecture (OFA) guidelines! Agreed. > /usr/local/oracle would be OK and users can move the directory tree > elsewhere afterwards. Or maybe you can ask about Oracle Base directory > during config/installation process, if possible. I would suggest to install under $ORACLE_HOME, defaulted to: ORACLE_HOME?= ${PREFIX}/oracle (or may be ${PREFIX}/oracle${VERSION} to allow the installation of different versions) Regards, -- Th. Thomas. From owner-freebsd-database@FreeBSD.ORG Wed Oct 22 22:49:46 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 C14BD1065670 for ; Wed, 22 Oct 2008 22:49:46 +0000 (UTC) (envelope-from ady@ady.ro) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.186]) by mx1.freebsd.org (Postfix) with ESMTP id 56A128FC0A for ; Wed, 22 Oct 2008 22:49:46 +0000 (UTC) (envelope-from ady@ady.ro) Received: by mu-out-0910.google.com with SMTP id i2so32865mue.3 for ; Wed, 22 Oct 2008 15:49:44 -0700 (PDT) Received: by 10.181.146.11 with SMTP id y11mr3448244bkn.5.1224713879147; Wed, 22 Oct 2008 15:17:59 -0700 (PDT) Received: by 10.181.37.7 with HTTP; Wed, 22 Oct 2008 15:17:59 -0700 (PDT) Message-ID: <78cb3d3f0810221517k780e4cafy6418c42b8c845915@mail.gmail.com> Date: Thu, 23 Oct 2008 00:17:59 +0200 From: "Adrian Penisoara" To: martinko In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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> Cc: freebsd-database@freebsd.org, freebsd-emulation@freebsd.org, rofug@rofug.ro, freebsd-ports@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: Wed, 22 Oct 2008 22:49:46 -0000 Hi, On Wed, Oct 22, 2008 at 12:51 AM, martinko wrote: > Thierry Thomas wrote: >> >> Le Mar 21 oct 08 =E0 22:09:44 +0200, martinko >> =E9crivait : >> >>> Hi, >> >> Hello, >> >>> No Oracle installation I have ever seen was installed into /home and it >>> would be against Oracle Optimal Flexible Architecture (OFA) guidelines! >> >> Agreed. >> >>> /usr/local/oracle would be OK and users can move the directory tree >>> elsewhere afterwards. Or maybe you can ask about Oracle Base directory >>> during config/installation process, if possible. >> >> I would suggest to install under $ORACLE_HOME, defaulted to: >> >> ORACLE_HOME?=3D ${PREFIX}/oracle >> >> (or may be ${PREFIX}/oracle${VERSION} to allow the installation of >> different versions) I have used a similar schema for the prefixing part, just used a different variable name. Do not confuse this with the ORACLE_HOME environment used by Oracle, what we set here is closer to the idea of ORACLE_BASE. We should not use a version field in this variable since the product version signature is further in the path (see below). >> >> Regards, > > Hallo, > > Well, it's a bit more complicated than that.. > > OFA guidelines say that $ORACLE_HOME shoud be in the form of e.g. > $ORACLE_BASE/product/10.2.0/db_1 > > And application (DB) is installed into its $ORACLE_HOME and thus one can > have many different installations of many different versions. > > Then there are other directories under $ORACLE_BASE that usually contain > Oracle Inventory (of installed software) and DB data files etc. > > Usually everything under $ORACLE_BASE is created and taken care by Oracle > Universal Installer (which is Java application). Right. See above. > > Another issue may be where to place oratab file. It is located in > /var/opt/oracle/oratab on SunOS and in /etc/oratab on other Unixes. The OracleXE packages have a hardcoded value for /etc/oratab. I'm going to leave it this way for the sake of compatibility. One more question: how usefull would it be to use the Linux (Bash) shell instead of a native (FreeBSD) shell ? Thank you for your suggestions, I'm closer to the completion of the port. Adrian. From owner-freebsd-database@FreeBSD.ORG Wed Oct 22 23:38:36 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 E8D111065674 for ; Wed, 22 Oct 2008 23:38:36 +0000 (UTC) (envelope-from ady@ady.ro) Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.152]) by mx1.freebsd.org (Postfix) with ESMTP id 87CD58FC20 for ; Wed, 22 Oct 2008 23:38:35 +0000 (UTC) (envelope-from ady@ady.ro) Received: by fg-out-1718.google.com with SMTP id l26so447775fgb.35 for ; Wed, 22 Oct 2008 16:38:34 -0700 (PDT) Received: by 10.181.150.16 with SMTP id c16mr1691153bko.150.1224718714433; Wed, 22 Oct 2008 16:38:34 -0700 (PDT) Received: by 10.181.37.7 with HTTP; Wed, 22 Oct 2008 16:38:34 -0700 (PDT) Message-ID: <78cb3d3f0810221638ua05ef45yeff0778c98b954ae@mail.gmail.com> Date: Thu, 23 Oct 2008 01:38:34 +0200 From: "Adrian Penisoara" To: freebsd-emulation , freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: Subject: Need help diagnosing Local OS authentication issue when running OracleXE Linux 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, 22 Oct 2008 23:38:37 -0000 Hi, I am working on a FreeBSD port for the OracleXE for Linux package and I stumbled upon a collateral issue when testing the functionality of OracleXE: I am unable to manually shutdown the TNS Listener (running "lsnrctl stop"), since the listener's "Local OS authentication" appears to malfunction. This feature prevents any other OS user but the user who initially started the listener to execute administrative tasks on the listener, including shutting down the listener. The listener process is a background service and accepts commands through the standard 1521 TCP port from the administration tool. I guess there is a problem when "emulating" the Linux kernel/library calls related to OS credentials for network sockets (?). Does anyone else have clues on this ? What would be the best way to proceed analyzing the issue -- e.g. how should I trace the execution for the running listener process (and eventually compare to a trace ran on a real Linux machine) ? Thank you, Adrian Penisoara Ady (@freebsd.ady.ro) From owner-freebsd-database@FreeBSD.ORG Thu Oct 23 04:56:13 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 CEA8C1065670 for ; Thu, 23 Oct 2008 04:56:13 +0000 (UTC) (envelope-from root@dchagin.dialup.corbina.ru) Received: from contrabass.post.ru (contrabass.post.ru [85.21.78.5]) by mx1.freebsd.org (Postfix) with ESMTP id 7F7E58FC19 for ; Thu, 23 Oct 2008 04:56:13 +0000 (UTC) (envelope-from root@dchagin.dialup.corbina.ru) Received: from corbina.ru (mail.post.ru [195.14.50.16]) by contrabass.post.ru (Postfix) with ESMTP id 5D92519E79; Thu, 23 Oct 2008 08:38:09 +0400 (MSD) X-Virus-Scanned: by cgpav Uf39PSi9pFi9oFi9 Received: from dchagin.dialup.corbina.ru ([78.107.232.239] verified) by corbina.ru (CommuniGate Pro SMTP 5.1.14) with ESMTPS id 1371370888; Thu, 23 Oct 2008 08:38:09 +0400 Received: from dchagin.dialup.corbina.ru (localhost.chd.net [127.0.0.1]) by dchagin.dialup.corbina.ru (8.14.3/8.14.2) with ESMTP id m9N4c71v001568; Thu, 23 Oct 2008 08:38:07 +0400 (MSD) (envelope-from root@dchagin.dialup.corbina.ru) Received: (from root@localhost) by dchagin.dialup.corbina.ru (8.14.3/8.14.2/Submit) id m9N4c24A001567; Thu, 23 Oct 2008 08:38:02 +0400 (MSD) (envelope-from root) Date: Thu, 23 Oct 2008 08:38:02 +0400 From: Chagin Dmitry To: Adrian Penisoara Message-ID: <20081023043802.GA1530@dchagin.dialup.corbina.ru> References: <78cb3d3f0810221638ua05ef45yeff0778c98b954ae@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <78cb3d3f0810221638ua05ef45yeff0778c98b954ae@mail.gmail.com> User-Agent: Mutt/1.4.2.3i Cc: freebsd-database@freebsd.org, freebsd-emulation Subject: Re: Need help diagnosing Local OS authentication issue when running OracleXE Linux 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: Thu, 23 Oct 2008 04:56:13 -0000 On Thu, Oct 23, 2008 at 01:38:34AM +0200, Adrian Penisoara wrote: > Hi, > > I am working on a FreeBSD port for the OracleXE for Linux package > and I stumbled upon a collateral issue when testing the functionality > of OracleXE: I am unable to manually shutdown the TNS Listener > (running "lsnrctl stop"), since the listener's "Local OS > authentication" appears to malfunction. > This feature prevents any other OS user but the user who initially > started the listener to execute administrative tasks on the listener, > including shutting down the listener. The listener process is a > background service and accepts commands through the standard 1521 TCP > port from the administration tool. I guess there is a problem when > "emulating" the Linux kernel/library calls related to OS credentials > for network sockets (?). > Hi, yes, this problem well-known to us :) please, see kern/102956 for full description. I think that this PR will be closed soon. > Does anyone else have clues on this ? > What would be the best way to proceed analyzing the issue -- e.g. > how should I trace the execution for the running listener process (and > eventually compare to a trace ran on a real Linux machine) ? > -- Have fun! chd