Re: Starting Oracle with SMF...

On May 31, 6:48 pm, Darren Dunham <ddun..._at_redwood.taos.com> wrote:
> In comp.unix.solaris Noel R. Nihill <Noel.Nih..._at_vallent.com> wrote:
>
> > Hi all.
> > This is really baffling me. I've got an SMF service manifest here
> > which is supposed to
> > start a couple of Oracle instances. It runs as root:root, depends on
> > filesystem:local
> > only, and works great from the command line. That is to say, I can
> > svcadm enable/disable
> > as root from a shell prompt. (The start/stop method "su -"s to the
> > oracle user.) The weird thing is, when I reboot a system immediately
> > after installing the databases, they start up fine automatically. But
> > subsequent reboots fail, with the following in the startup logs:
> > SQL> ORA-01031: insufficient privileges
>
> I think the best way to attack this is to understand the oracle
> complaint better. What would cause the privileges to change?
>
> However, my guess is that your dependencies are insufficient and the
> startup requires some OS feature that has not yet started (networking?
> name services?)
>
> As a quick test, make it dependent on milestone/multi-user. If that
> works consistently, I'd assume that that's the root of the issue. You
> could leave it like that or investigate exactly *what* other service or
> services it needs and make those dependencies explict.

Bingo. Adding a dependency to the system milestone 'svc:/milestone/ name-services'
makes it much happier. I should have thought of that, but I was completely thrown by
the fact that the first post-install reboot works OK for some bizarre reason.

Thanks Darren.

> I would probably also want to make a dependency from multi-user-server
> to it.

I might just do that.

> --
> Darren Dunham ddun..._at_taos.com
> Senior Technical Consultant TAOS http://www.taos.com/
> Got some Dr Pepper? San Francisco, CA bay area
> < This line left intentionally blank to confuse you. >

--
Noel N.