Re: How to autostart Oracle 10g on SuSE 9.3

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 24 Sep 2005 20:05:49 +0200
Message-ID: <dh44hq$kt3$02$1@news.t-online.com>

Fabrizio schrieb:
> 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
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> 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
>

You are right, i've forgot it.
But anyway, prefer not to do it as root ( simply don't see any valid reason ).

Best regards

Maxim Received on Sat Sep 24 2005 - 13:05:49 CDT