Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 2193 invoked from network); 2 Feb 2007 12:54:20 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2007 12:53:56 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0EFDD5D3E66; Fri, 2 Feb 2007 13:51:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00528-03-4; Fri, 2 Feb 2007 13:51:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 589F15D403F; Fri, 2 Feb 2007 13:51:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Feb 2007 13:50:40 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5DF2C5D3EB3 for ; Fri, 2 Feb 2007 13:50:40 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32576-04 for ; Fri, 2 Feb 2007 13:50:40 -0500 (EST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60D4B5D3E7D for ; Fri, 2 Feb 2007 13:50:39 -0500 (EST) Received: by wr-out-0506.google.com with SMTP id 68so893084wra for ; Fri, 02 Feb 2007 10:51:49 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=YP8CKiu0GYoYVeLQOs/tivKP5RvbeGUFd4CRiU6mEv2oOryMq7RYSC3vNmD5wp8qbPsfREcyueCG6FLQoPhdrxNU65/aYN+y19iVL97yKbH8uwsIDF/GEQR7b1PfByTX2kzVeYrXIhDnNrSylOm0rYd/2v7aTnnHHml7DSI5P2o= Received: by 10.90.66.9 with SMTP id o9mr5413060aga.1170442309543; Fri, 02 Feb 2007 10:51:49 -0800 (PST) Received: from ?172.27.75.5? ( [172.27.75.5]) by mx.google.com with ESMTP id 45sm7119433wri.2007.02.02.10.51.48; Fri, 02 Feb 2007 10:51:49 -0800 (PST) Message-ID: <45C38841.6040401@gmail.com> Date: Sat, 03 Feb 2007 05:51:45 +1100 From: Grant Allen User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: JDunn@sefas.com CC: oracle-l Subject: Re: Finding out what user oracle is installed under References: <2F802216565E44489600A03F763219A80BC4CF@mia.SEFASBRISTOL> In-Reply-To: <2F802216565E44489600A03F763219A80BC4CF@mia.SEFASBRISTOL> Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-archive-position: 45093 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: gxallen@gmail.com Precedence: normal Reply-to: gxallen@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net John Dunn wrote: > Is there a database query that will tell me what Unix account oracle > is installed under? I know that in most cases this will be oracle, but > is there a database query that will tell me? This is more a SQL*Plus+shell command rather than a query, but if you're worried about the case of installed account not matching running account, you could always: SQL> ! ls -l $ORACLE_HOME/bin/oracle | awk '{print $3}' oracle I'll leave relevant changes as an exercise for the reader if your operating system promises you "genuine advantage" :-) Ciao Fuzzy :-) -- http://www.freelists.org/webpage/oracle-l