Re: how to LOCK_SGA on Solaris

On Tue, 30 Dec 2003 22:29:13 +0100, Frank Langelage <frank_at_lafr.de> wrote:

>Today I switched param LOCK_SGA from FALSE to TRUE.
>After this the restart of oracle failed:
> ORA-27126: unable to lock shared memory segment in core
> SVR4 Error: 1: Not owner
>
>If I change the owner of the oracle binary to root
>-rwsr-s--x 1 root dba 62723664 Dec 17 00:18 oracle
>then then startup succeeded.
>Processes are running with user=root (and realuser=oracle).
>
>Is there a way to use LOCK_SGA without changing owner to root ?
>
>Regards
>Frank

IIRC Oracle advises against using this parameter on Solaris, nor should you need it, as Solaris has Intimate Shared Memory (ISM) Changing the owership of the executable to obtain something you don't need doesn't look like the way to go.

--
Sybrand Bakker, Senior Oracle DBA