Operating System - HP-UX
1838574 Members
4533 Online
110128 Solutions
New Discussion

Oracle database 9.2.0.5 startup HP-UX error

 
GNOM
Frequent Advisor

Oracle database 9.2.0.5 startup HP-UX error

hi,
I installed succefuly oracle database 9i on HP-UX 11i OS. But while starting up the database I got the following Error Messages :
"ORA:27126 Unable to lock shared memory segement in core"
"HP-UX ERROR 1 :Not Owner".

Could someone help fixe this problem ?
2 REPLIES 2
Indira Aramandla
Honored Contributor

Re: Oracle database 9.2.0.5 startup HP-UX error

Hi Amignom,

If the lock_sga parameter is set to true in the init.ora, then this problem might arise if the unix user trying to startup the database does not have privileges to lock the memory.

Here is the solution description

You need to give the oracle Unix user memory locking privileges at the OS level. Do the following:

1) Login as root:

%su root

2) Create the file "/etc/privgroup":

$vi /etc/privgroup

3) Add line "dba MLOCK" to file.

Note: The group dba is assuming the oracle owner's ID is part of the dba group.

4) As root, run the command "/etc/setprivgrp -f /etc/privgroup":

$/etc/setprivgrp -f /etc/privgroup


Explanation:
In order for Oracle to lock the SGA into memory, the software owner must have locking privileges at the OS level.


Indira A
Never give up, Keep Trying
Thierry Poels_1
Honored Contributor

Re: Oracle database 9.2.0.5 startup HP-UX error

hi,

- check /etc/privgroup
- verify or add "dba MLOCK" to this file
- reset privs with "setprivgrp -f /etc/privgroup"
- try again

good luck,
Thierry Poels.

All unix flavours are exactly the same . . . . . . . . . . for end users anyway.