Wednesday, June 25, 2008

Oracle on HP-UX - lock SGA

If oracle instance in HP-UX is set to lock sga as below:

ALTER SYSTEM SET lock_sga=TRUE SCOPE=SPFILE;

There will be error:-

SQL> ORA-27126: unable to lock shared memory segment in core
HP-UX Error: 1: Not owner

Solution:
1) Create a file /etc/privgroup with this entry
dba MLOCK RTSCHED RTPRIO

2) Run
# setprivgroup -f /etc/privgroup

3) Check that above is successful
# getprivgrp
global privileges: CHOWN
dba: RTPRIO MLOCK RTSCHED

Reference:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=729423

No comments: