how to LOCK_SGA on Solaris

From: Frank Langelage <frank_at_lafr.de>
Date: Tue, 30 Dec 2003 22:29:13 +0100
Message-ID: <bssqnf$13p27$1@ID-48907.news.uni-berlin.de>

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 Received on Tue Dec 30 2003 - 15:29:13 CST