Xref: alice comp.databases.oracle.server:42096
Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news-lond.gip.net!news.gsl.net!gip.net!baron.netcom.net.uk!netcom.net.uk!usenet.co.uk!newspeer.usenet.co.uk!post.usenet.co.uk!not-for-mail
From: Alex Hudghton <alex.hudghton@capgemini.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: HELP: starting oracle 8i as root user
Date: Wed, 03 Mar 1999 15:25:47 +0000
Organization: Cap Gemini UK Plc
Lines: 36
Message-ID: <36DD547B.578CCF30@capgemini.co.uk>
References: <7bhumj$ctf$1@remarQ.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: hagen.cloud9.co.uk 920474748 5034 194.42.240.2 (3 Mar 1999 15:25:48 GMT)
X-Complaints-To: abuse@usenet.co.uk
NNTP-Posting-Date: 3 Mar 1999 15:25:48 GMT
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en

You need to switch user to the oracle owner, then run the db & listener
startups. Use something like su - oracle -c "command string" in the startup
file.

Alex

Patrick Gibson wrote:

> I've installed Oracle 8i on a Linux system. As the oracle user, I can
> startup the server; however, when I try startup the server as the root user,
> I get a "SVRMGR> ORA-01031: insufficient privileges" error message. Both the
> root user and the oracle user are in the group 'dba'.
>
> I did an experiment where I added the user 'patrick' to the group 'dba'. As
> 'patrick', I was able to startup and shutdown the server without any
> problems.
>
> The reason I need 'root' to be able startup and shutdown the server is
> because I want Oracle started and stopped automatically when (and if) the
> system goes up and down.
>
> Can anyone provide me with some advice/pointers for getting this to work? I
> am find Oracle Corporation's documentation to be very inadequate.
>
> Thanks,
>
> Patrick
>
> PS: Please reply via email as well as to this group.
>
> --[ iMac therefore I am ]------------------+
>  patrick gibson ( patrick @ firstweb.com )
>  http://www.firstweb.com
>  tel: 604.646.0467 / fax: 604.646.0468
> -----------------------------[ got iMac? ]-+