Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01031: insufficient privileges

Re: ORA-01031: insufficient privileges

From: joel garry <joel-garry_at_home.com>
Date: 23 Feb 2007 13:58:12 -0800
Message-ID: <1172267892.597629.43990@q2g2000cwa.googlegroups.com>


On Feb 23, 1:28 pm, DA Morgan <damor..._at_psoug.org> wrote:
> lazyboy..._at_yahoo.com wrote:
> > Hi All,
>
> >> What UNIX account owns the installation?
>
> > It should be sysdba:oracle, but it's changed now & pls see the below
> > for explanation.
>
> >> Is it the same as when you type whoami?
>
> > No, it's not the same, but does it matter?
>
> > # su - sysdba
>
> Second time:
>
> SYSDBA is a role inside the database ... it is not a user either in
> the operating system or in the database.

Daniel, you need to refer back to his original post. He _created_ both a unix user and group called sysdba. Whether that is something that sends Oracle into lalaland is something I couldn't say, though I wouldn't expect it.

>From the OP:

> $ grep sysdba /etc/group
> oracle::101:sysdba,oracle
> $ grep sysdba /etc/passwd
> sysdba:x:1001:101:Chris Oracle Testing Acct:/oraclesw:/bin/bash
> $ id
> uid=1001(sysdba) gid=101(oracle)

jg

--
@home.com is bogus.
http://www.ebaymotorssucks.com/vladuz-suppliment.htm
Received on Fri Feb 23 2007 - 15:58:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US