Starting Oracle with SMF...

From: Noel R. Nihill <Noel.Nihill_at_Vallent.com>
Date: 31 May 2007 09:43:56 -0700
Message-ID: <1180629835.954901.54770@m36g2000hse.googlegroups.com>

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.

Received on Thu May 31 2007 - 11:43:56 CDT