ORA-27125 When LOCK_SGA=TRUE On AIX (Doc ID 1503797.1)
n this Document
|
|
Symptoms |
|
|
Changes |
|
|
Cause |
|
|
Solution |
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
IBM AIX on POWER Systems (64-bit)
SYMPTOMS
When Trying to startup Oracle instance on IBM AIX, the below error occurred:
SQL> startup; ORA-27125: unable to create shared memory segment IBM AIX RISC System/6000 Error: 1: Not owner
CHANGES
The parameter LOCK_SGA is set to true.
CAUSE
In order for Oracle to lock the SGA into memory, the software owner must have locking privileges at the OS level.
SOLUTION
You need to give the oracle Unix user memory locking privileges at the OS level.
The way to solve the issue differs from one OS to another.
To solve the issue on IBM AIX please implement the below:
-
Set v_pinshm to 1:
# vmo -o v_pinshm
v_pinshm = 0
# vmo -o v_pinshm=1
-
Add CAP_BYPASS_RAC_VMM,CAP_PROPAGATE capabilities:
# lsuser -a capabilities oracle
oracle
# chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle
# lsuser -a capabilities oracle
oracle capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE
(CAP_BYPASS_RAC_VMM,CAP_PROPAGATE capabilities need to be set in root, grid and database users to work with lock_sga)
- Then startup the instance
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26655292/viewspace-2642925/ ，如需转载，请注明出处，否则将追究法律责任。
