对oracle metalink文档我们也要敢于质疑

paulyibinyi

原帖由 zhouwf0726 于 2010-5-10 11:23 发表
两个问题吧？


--enable large page
How to enable Large Page Feature on AIX-Based Systems

--crs can not start
10.2.0.X CRS Bundle Patch Information  
Cannot startup CRS after applying 10.2.0.4 patchset or CRS Bundle Patch# 3 and above  
ASM / CSS Error : Please Change The CSS_ORACLE_USER Id CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH  

不一样的，我这边是crs能启动，用srvctl start database -d dbname这种方式不能启动，必须手工用sqlplus启动数据库

asm没用上 用的是raw,
css 这些都正常

paulyibinyi

ASM / CSS Error : Please Change The CSS_ORACLE_USER Id CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH [ID 726234.1]   

--------------------------------------------------------------------------------

  修改时间 18-MAY-2009     类型 PROBLEM     状态 PUBLISHED   

In this Document
  Symptoms
  Cause
  Solution
  References



--------------------------------------------------------------------------------


Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7
IBM AIX Based Systems (64-bit)
AIX5L Based Systems (64-bit)
Symptoms
Note: The solution provided in this document is only for Non-clusterware configurations (non-CRS).



都不是crs

都是单实例的asm和css

zhouwf0726

楼主用了large page？你说的这些权限在10203 crs bp#2以上及10204都是必须的。


On Aix starting with 10203 (BP#2) and 10204, CRS owner on AIX platform
requires some special attributes. Lack of these attributes will cause CRS to
fail to startup.
These attributes are usually set using
# /usr/bin/chuser capabilities=CAP_BYPASS_RAC_VMM,
CAP_PROPAGATE,CAP_NUMA_ATTACH crsha
and can be checked by
# /usr/bin/lsuser -f crsha | grep capabilities
capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH
CAP_PROPAGATE,CAP_NUMA_ATTACH crsha
*** ANAIR 07/28/08 11:46 am BUSINESS NEED ***
Will help customers configure these things before they run into the problem.
The CVU run before applying the patch should ideally report this.
*** JCREIGHT 07/28/08 12:07 pm RESPONSE ***
@ Looks like this one is critical for AIX






Known Issues for 10.2.0.3 CRS Bundle Patch #2:
These capabilities (CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH) are needed now that the CSS daemon runs in realtime to avoid resource constraints.  It uses the mlockall subroutine which causes all of the pages mapped by the address space of a process to be memory-resident until unlocked or until the process exits or executes another process image.  The definitions of each capability are:

CAP_BYPASS_RAC_VMM - A process has the ability to bypass restrictions on VMM resource usage.
CAP_PROPAGATE - All capabilities are inherited by child processes.
CAP_NUMA_ATTACH - A process has the ability to bind to specific resources.

paulyibinyi

原帖由 zhouwf0726 于 2010-5-10 22:45 发表
楼主用了large page？你说的这些权限在10203 crs bp#2以上及10204都是必须的。


On Aix starting with 10203 (BP#2) and 10204, CRS owner on AIX platform
requires some special attributes. Lack of these attributes will cause CRS to
fail to startup.
These attributes are usually set using
# /usr/bin/chuser capabilities=CAP_BYPASS_RAC_VMM,
CAP_PROPAGATE,CAP_NUMA_ATTACH crsha
and can be checked by
# /usr/bin/lsuser -f crsha | grep capabilities
capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH
CAP_PROPAGATE,CAP_NUMA_ATTACH crsha
*** ANAIR 07/28/08 11:46 am BUSINESS NEED ***
Will help customers configure these things before they run into the problem.
The CVU run before applying the patch should ideally report this.
*** JCREIGHT 07/28/08 12:07 pm RESPONSE ***
@ Looks like this one is critical for AIX






Known Issues for 10.2.0.3 CRS Bundle Patch #2:
These capabilities (CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH) are needed now that the CSS daemon runs in realtime to avoid resource constraints.  It uses the mlockall subroutine which causes all of the pages mapped by the address space of a process to be memory-resident until unlocked or until the process exits or executes another process image.  The definitions of each capability are:

CAP_BYPASS_RAC_VMM - A process has the ability to bypass restrictions on VMM resource usage.
CAP_PROPAGATE - All capabilities are inherited by child processes.
CAP_NUMA_ATTACH - A process has the ability to bind to specific resources.

对，所以How to enable Large Page Feature on AIX-Based Systems [ID 372157.1]
metalinke 文档 确实是少写了一项 呵呵

zhouwf0726

那些都是crs必须的东西，是否是enable large page必须的不敢说，问问metalink吧，方便的话说说SR号？

zhouwf0726

Guide to Multiple Page Size Support
on AIX 5L Version 5.3
March, 2006
David Hepkin
IBM Corporation
Contributors: Augie Mena, Greg Mewhinney


The memory allocated to 16MB pages can only be used for 16MB pages, and the
memory allocated to 16GB pages can only be used for 16GB pages. Thus, pages of these
aixtrmultiplepagewp030206.doc 4
sizes should only be configured in high-performance environments. The use of 16MB
and 16GB pages is restricted. In order to allocate pages of these sizes, a user must have
the CAP_BYPASS_RAC_VMM and CAP_PROPAGATE capabilities or have root
authority. The chuser command can be used to grant these capabilities to users.

zhouwf0726

对于large page来说，root用户本身就够了；对于crs来说，oracle要求CRS owner 用户需要3个权限。

a user must have
the CAP_BYPASS_RAC_VMM and CAP_PROPAGATE capabilities or have root
authority.

paulyibinyi

恩 谢谢斑竹的进一步解释，又加深理解了

[ 本帖最后由 paulyibinyi 于 2010-5-10 23:15 编辑 ]

langzhi000

对于这种态度，赞一个。

oradbHome

还有 root 也需要有 CAP_BYPASS_RAC_VMM,CAP_PROPAGATE  属性。

SGA Not Pinned In The AIX Large Pages When Instance Is Started With Srvctl [ID 369424.1]

Cause
The root user ID does not have the necessary capabilities CAP_BYPASS_RAC_VMM and CAP_PROPAGATE.
Solution
Check that the capabilities CAP_BYPASS_RAC_VMM and CAP_PROPAGATE have been enabled for root.

As root:

# lsuser –a capabilities root

If not enabled, add the capabilities:

# chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE root