Re: ORA-01031: insufficient privileges

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