Re: Starting Oracle with SMF...

On May 31, 9:34 pm, joel garry <joel-ga..._at_home.com> wrote:
> On May 31, 9:43 am, "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
>
> > The associated Oracle audit file looks like:
>
> > Audit file /appl/oracle/admin/sadb/adump/ora_313.aud
> > Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> > Production
> > With the Partitioning and Data Mining options
> > ORACLE_HOME = /appl/oracle/product/10.2.0/db_1
> > System name: SunOS
> > Node name: bantry
> > Release: 5.10
> > Version: Generic_118833-36
> > Machine: sun4u
> > Instance name: sadb
> > Redo thread mounted by this instance: 0 <none>
> > Oracle process number: 0
> > Unix process pid: 313, image: oracle_at_bantry
>
> > Thu May 17 15:16:34 2007
> > ACTION : 'CONNECT'
> > DATABASE USER: '/'
> > PRIVILEGE : NONE
> > CLIENT USER: oracle
> > CLIENT TERMINAL: Not Available
> > STATUS: 1031
>
> > Here's an example of a "good" audit file:
>
> > Audit file /appl/oracle/admin/sadb/adump/ora_876.aud
> > Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> > Production
> > With the Partitioning and Data Mining options
> > ORACLE_HOME = /appl/oracle/product/10.2.0/db_1
> > System name: SunOS
> > Node name: bantry
> > Release: 5.10
> > Version: Generic_118833-36
> > Machine: sun4u
> > Instance name: sadb
> > Redo thread mounted by this instance: 0 <none>
> > Oracle process number: 13
> > Unix process pid: 876, image: oracle_at_bantry (TNS V1-V3)
>
> > Thu May 17 15:05:12 2007
> > ACTION : 'CONNECT'
> > DATABASE USER: '/'
> > PRIVILEGE : SYSDBA
> > CLIENT USER: oracle
> > CLIENT TERMINAL:
> > STATUS: 0
>
> > If anyone could offer enlightenment at this stage I would be most
> > grateful. If I just put the start/stop method into /etc/rc2.d, the
> > databases start fine. I'm obviously missing some subtlety of SMF.
>
> > Thanks and regards.
>
> > --
> > Noel N.
>
> I don't know anything about any SMF, but:
>
> Check that none of USER USERNAME LOGNAME environment variables are
> root.
> Find and post contents of all sqlnet.ora files.
> ll $ORACLE_HOME/bin/oracle from both environments.
> ll $ORACLE_HOME/dbs/orapw* from both environments. Check case of
> name.
> Who is in your dba group, whatever it is called? You don't want to
> add root to that group. I'm wondering if your root:root service is
> requiring that.
> ipcs|grep ora (Some unix will have issues if the shared memory
> segments are taken already. Given that you are having issues only
> with subsequent restarts, perhaps you are not removing the shared
> memory segments properly on reboot, and need to ipcrm. Most unix
> won't last through a reboot, but I dunno about 5.10...).
> Have you followed the instructions for starting up, including memory
> modifications? Are you using containers?
>
> Have you seen How to Use Sun Service Management Facility (SMF) To
> Start/Stop Oracle 10g Database?
> metalink Note:398580.1 "Currently we do not support SMF and do not
> have documentation how to use it for database startup. You can as well
> refer Bug 5340239 for the same. The same bug can also be monitored for
> future support information. "
> (That bug or something it refers to mentions using /etc/system rather
> than /etc/project for memory settings as a workaround)

All good advice. As Darren suggested, I was missing a dependency on the Solaris naming services.

Thanks Joel.

> jg
> --
> @home.com is bogus.
> "You can do so much more with a rich client than you can with a
> browser. At the same time, rich clients are improving and their cost
> is declining. The marriage of these services with a powerful client is
> a very powerful marriage. "http://d5.allthingsd.com/20070530/d5-gates-jobs-interview/- Hide quoted text -
>
> - Show quoted text -

--
Noel N.