ITPub博客

首页 > IT职业 > IT职场 > ORA-27125 When LOCK_SGA=TRUE On AIX (Doc ID 1503797.1)

ORA-27125 When LOCK_SGA=TRUE On AIX (Doc ID 1503797.1)

IT职场 作者:q418441117 时间:2019-04-29 17:01:10 0 删除 编辑

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:

  1. Set v_pinshm to 1:

    # vmo -o v_pinshm
    v_pinshm = 0

    # vmo -o v_pinshm=1

  2. 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)

  3. Then startup the instance


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26655292/viewspace-2642925/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-09-11

  • 博文量
    202
  • 访问量
    383087