Re: Starting Oracle with SMF...

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)

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/