Re: Insufficient privileges starting ASM client database(s) when ASM instance started with non-Oracle owner

Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient privileges starting ASM client database(s) when ASM instance started with non-Oracle owner

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 18 Nov 2005 12:25:24 GMT
Message-ID: <1132316723.290590@proxy.dienste.wien.at>

Andreas Sheriff <spamcontrol_at_iion.com> wrote:
> Oracle 10.2.0.1.0 x86_64 on RHEL4 , using ASM and ASMLIB.
> 4 gigs mem, single Xeon (dual core), 4 D1000's with 48 drives through three
> dual interfaced controllers (8 - SCSI hookups) controlled by ASM.
>
> Has anyone else seen this?
> If you start ASM with a non-Oracle binary owner ( a user who is in the DBA
> group, of course) and you try to start an ASM client database, the database
> startup fails claiming:
>
> ORA-15055: unable to connect to ASM instance
> ORA-01031: insufficient privileges

First, check if what you do is allowed.

Then, check if the oracle executable has setuid and setgid flag set. If not, your installation is broken.

I have encountered errors like this when the flags were off, but I have no idea about ASM.

Yours,
Laurenz Albe Received on Fri Nov 18 2005 - 06:25:24 CST