Monday, April 25, 2016

11g db not starting with error HPUX-ia64 Error: 1: Not owner

While starting the db got error


$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 25 10:48:47 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-27125: unable to create shared memory segment
HPUX-ia64 Error: 1: Not owner
SQL> exit
Disconnected


Cause :  lock_sga=true was set in init file

we have set as per oracle action plan below which got into affect post reboot .

$ grep lock_sga initWCPROD.ora
#*.lock_sga=TRUE

..We also tried relink and checked for shmmax and shmall parameters , but those were not culprits .


No comments:

Post a Comment