Re: How to autostart Oracle 10g on SuSE 9.3

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Sat, 24 Sep 2005 17:47:38 GMT
Message-ID: <_igZe.15024$pJ6.976613@news4.tin.it>

Hi Maxim,

> Yet another point - putting a symlink into rc directory to dbstart. It
> will cause execution of dbstart by user root, if root isn't in 'dba'
> group ( usually it is not the case ), instance will not start due to
> insufficient privileges ( ORA-01031 ), what happens if the root is
> actually in the 'dba' group and can start the instance - i will not even
> spent time to try it ( i had enough headache to find out , what was
> wrong when operators from datacenter started listener as root - they
> usually do almost all as root )
>

Nothing too terrible would happen since the oracle executable is suided:

rangelife:~ # id
uid=0(root) gid=0(root) groups=0(root),55(dba)

rangelife:~ # sqlplus sys/test8k_at_test8k as sysdba

SQL*Plus: Release 10.1.0.3.0 - Production on Sat Sep 24 19:40:36 2005

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1493172224 bytes

Fixed Size                  1321872 bytes
Variable Size             383505520 bytes
Database Buffers         1107296256 bytes
Redo Buffers                1048576 bytes

Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

rangelife:~ # ps -fe|grep dbw

oracle   11838     1  0 19:40 ?        00:00:00 ora_dbw0_TEST8K
root     11867 11762  0 19:41 pts/1    00:00:00 grep dbw

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Sat Sep 24 2005 - 12:47:38 CDT