From oracle-l-bounce@freelists.org Fri Nov 19 11:21:44 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAJHLi301338 for ; Fri, 19 Nov 2004 11:21:44 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAJHLhi01333 for ; Fri, 19 Nov 2004 11:21:43 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3329072E447; Fri, 19 Nov 2004 12:28:02 -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 19158-44; Fri, 19 Nov 2004 12:28:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 38F9272D794; Fri, 19 Nov 2004 12:17:00 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=zNf8MfmOIdB1OaIYCjEivl7eCmpmHqPLinhQG7jcBArqx9g+LszSML8RDCN0babxZEKBt5qQAr84vdQU68YMSkUgz5K/D+oeHa4JyZqlLVOQHPnFO2Da0vAdLqtldEzLpIENjyXQYxsTGG37A2Sflg0/la/N0W7ojulxfB1OvFw= ; Message-ID: <20041119170035.79863.qmail@web20704.mail.yahoo.com> Date: Fri, 19 Nov 2004 09:00:35 -0800 (PST) From: Charlotte Hammond Subject: RE: Linux ps command To: Charlotte Hammond , "Nick Tilbury @ Northampton" , ORACLE-L MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 12455 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: charlottejanehammond@yahoo.com Precedence: normal Reply-To: charlottejanehammond@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org If anyone's really still interested in this, I did a bit of Googling and I "think" the problem is due to a Linux security patch to "ptrace" broke this functionality in the 2.4.20 kernel. (http://kerneltrap.org/node/view/611 and http://groups.google.com/groups?hl=en&lr=&selm=20030422234007%243c44%40gated-at.bofh.it&rnum=1) As we like to keep the kernel that ships with the distribution, I think I'll just have to leave it for now and run my start scripts as su oracle. - Charlotte Charlotte Hammond wrote: Thanks for everyone's suggestions. Unfortunately no luck yet but I think that's because I'm looking in the wrong place focusing on 'ps' itself. I have discovered two further things: 1. ps works fine, as expected if I start the instance from the unix user oracle, but I get this "[oracle]" behaviour if I start it from any other user, ie. members of the dba group. 2. /proc//cmdline is empty if the instance is started by a non-oracle dba group member. It looks like the process just isn't being registered properly with the Linux kernel correctly at start up, so I can't blame ps for not being able to report on it. Not sure why that is - the suid and guid bits are set ok on the oracle binary. I guess I'll just have to start the instance as oracle for the time being. Any further suggestions welcome. - Charlotte "Nick Tilbury @ Northampton" wrote: My admin's last suggestion (I promise) :- export PS_PERSONALITY=sun export CMD_ENV=sun then run the usual SunOS commands "ps -ef | grep ora" -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Charlotte Hammond Sent: 19 November 2004 14:08 To: ORACLE-L Subject: RE: Linux ps command Thanks, but sorry, no - this returns "[oracle]" again: charlotte@quatermass:~> ps alx | grep ora 0 700 3589 1 15 0 14520 1864 schedu S ? 0:00 /opt/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit 0 700 27446 1 15 0 284392 7912 schedu S ? 0:00 [oracle] 0 700 27448 1 15 0 284736 7904 schedu S ? 0:00 [oracle] 0 700 27450 1 15 0 287848 9236 schedu S ? 0:00 [oracle] 0 700 27452 1 15 0 283744 7276 schedu S ? 0:00 [oracle] 0 700 27454 1 15 0 283744 16932 schedu S ? 0:00 [oracle] 0 700 27456 1 15 0 283716 10056 schedu S ? 0:00 [oracle] 0 700 27458 1 15 0 283692 9388 schedu S ? 0:00 [oracle] 0 700 27460 1 15 0 287788 6556 schedu S ? 0:00 [oracle] 0 700 27462 1 15 0 287860 6792 schedu S ? 0:00 [oracle] 0 700 27465 1 15 0 283664 5980 schedu S ? 0:00 [oracle] 0 700 27467 1 15 0 283664 5984 schedu S ? 0:00 [oracle] 0 700 27469 1 15 0 283664 5984 schedu S ? 0:00 [oracle] 0 700 27471 1 15 0 283664 6004 schedu S ? 0:00 [oracle] 0 700 27474 1 15 0 283676 6584 schedu S ? 0:00 [oracle] 0 700 27476 1 15 0 283676 6472 schedu S ? 0:00 [oracle] 0 702 27770 27747 20 0 3544 568 pipe_w S pts/0 0:00 grep ora - Charlotte "Stephane Faroult" wrote: Try ps alx Regards, Stephane Faroult RoughSea Ltd http://www.roughsea.com "Nick Tilbury @ Northampton" wrote: I cannot take credit (or blame !) for this one, it comes from our Unix admin. See if it give you want you require. try ps auxc a = all processes on a terminal, including other users u = display user-oriented format x = select processes without controlling ttys c = display true command name Nick -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Charlotte Hammond Sent: 19 November 2004 11:31 To: ORACLE-L Subject: Linux ps command Hi List, If I run "ps" on Solaris or on SuSE Linux 7.2 I see the Oracle background processes under the command heading containing the SID, eg. "ora_smon_MYSID" or "oracleMYSID (LOCAL=NO)". If I do the same under SuSE Linux 8.2 I just get "[oracle]", no process name and no SID. I know I can cross-reference process id's with V$PROCESS but it's a lot easier if this information is already in ps. Is there some way to get SuSE 8.2 to behave like 7.2 (or Solaris) in this regard? Thanks - Charlotte --------------------------------- Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! -- http://www.freelists.org/webpage/oracle-l ======================================================= This message is intended solely for the use of the individual or organisation to whom it is addressed. It may contain privileged or confidential information. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you should not use, copy, alter, or disclose the contents of this message. All information or opinions expressed in this message and/or any attachments are those of the author and are not necessarily those of VarTecTelecom Europe Ltd or its affiliates. VarTec Telecom Europe Ltd accepts no responsibility for loss or damage arising from its use, including damage from virus. ======================================================= --------------------------------- Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! -- http://www.freelists.org/webpage/oracle-l ======================================================= This message is intended solely for the use of the individual or organisation to whom it is addressed. It may contain privileged or confidential information. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you should not use, copy, alter, or disclose the contents of this message. All information or opinions expressed in this message and/or any attachments are those of the author and are not necessarily those of VarTecTelecom Europe Ltd or its affiliates. VarTec Telecom Europe Ltd accepts no responsibility for loss or damage arising from its use, including damage from virus. ======================================================= --------------------------------- Do you Yahoo!? Discover all that’s new in My Yahoo! --------------------------------- Do you Yahoo!? The all-new My Yahoo! – Get yours free! -- http://www.freelists.org/webpage/oracle-l