Re: system privileged functions

From: Oracle <oracle_at_ddb.be.statoil.no>
Date: Wed, 16 Jun 1993 14:29:24 GMT
Message-ID: <1993Jun16.142924.13826_at_statoil.no>


In article <dewey-150693090641_at_sebastian.centerline.com>, dewey_at_centerline.com (Devan F. Dewey) writes:
> In article <1993Jun15.115346.17098_at_statoil.no>, oracle_at_ddb.be.statoil.no
> (Oracle ) wrote:
> >
> > Hi.
> > Why does sqldba responds 'ORA-01031: insufficient privileges'
> > when the root user is trying to do sqldba shutdown or connect internal,
> > even if the root is a proper member of group dba?
> > (/etc/group:
> > dba:*:101:root,oracle,dba1,dba2)
> > It works fine for the users oracle, dba1 and dba2.
> > It also works fine for additional users added to the group dba.
> >
> > (By the way, I'm running Oracle 6.0.36.5.1 on a Sun SPARC 10)
>
> IÕm having the exact same problem on a SPARC 10. And we just upgraded to
> this SPARC 10 from a Sun 4 which did not have this problem!
>
> I opened a tar with Oracle, but they did not have an answer.
>
> -Devan
>
>
> Devan F. Dewey | Senior Systems Analyst
> CenterLine Software | dewey_at_centerline.com
> 10 Fawcett Street | "Leme esplain - no dere is
> Cambridge, MA 02138 | too much. Leme sum up."
> -Inigo Montoya

I spoke to our local Oracle support here in Norway. My problem was a known one, not a bug but an 'undocumented feature' in Oracle 6.0.36 and later.....
Should use 'su - oracle -c dbstart' and like if run from root.....

Torstein Received on Wed Jun 16 1993 - 16:29:24 CEST

Original text of this message