ORACLE在HP-UX下的系列问题处理(19)

　　Oracle: setprivgrp 解决7.3.3 版内存锁定权限错误
　　
　　问题描述
　　
　　新版的 Oracle, 7.3.3出现下面的错误:
　　Process pid num=1 does not have mem locking privileges
　　required for using large text pages in this version.
　　See setprivgrp command.
　　
　　我运行了 adb，并安装了Oracle补丁程序，但问题仍然存在。
　　
　　为什么会出现这个问题?
　　
　　配置信息
　　
　　操作系统 - HP-UX
　　版本 - 10.20
　　硬件系统 - HP9000
　　系列 - K260
　　
　　解决方法
　　
　　基本上Oracle 7.3.3 可执行文件运行了 chatr，缺省情况下它试图使用“大文本页”：超级页面，超级页面将文本映像锁定到RAM 中。试图MLOCK的组没有用setprivgrp命令授予适当的权限。
　　
　　假如看一下调用，它们似乎指向对oracle用户的默认组执行setprivgrp命令。Oracle 建议名字叫'dba' 的组。遗憾的是，对dba执行setprivgrp可能解决不了问题。查看正在运行该程序的用户，对该用户的组运行setprivgrp。
　　
　　在这个例子中，设置继续组的setprivgrp解决了问题。
　　
　　运行setprivgrp后，假如使用的是HFS文件系统，则不应当再出现任何问题；假如使用JFS，就会出现死锁。下面的补丁程序可以解决死锁的问题：
　　
　　S800 PHKL_12946
　　
　　S700 PHKL_12945
　　
　　注：补丁程序可以被后来的版本替代；因此确保加载最新的版本。
　　.........following with all English text ....
　　Oracle: Version 7.3.3 mem locking privileges error fixed by setprivgrp
　　
　　Problem Description
　　
　　The new version of Oracle, 7.3.3, gives this error:
　　
　　Process pid num=1 does not have mem locking privileges required for using large text pages in this version.
　　See setprivgrp command.
　　I have run adb and installed the Oracle patches, but the
　　problem persists.
　　
　　What is the cause of this problem?
　　
　　Configuration Info
　　
　　Operating System - HP-UX
　　Version - 10.20
　　Hardware System - HP9000
　　Series - K260
　　
　　Solution
　　
　　Basically, the Oracle 7.3.3 executable has had chatr run against it, and by default it attemps to use a 'large text page': superpage,which requires locking the text image into RAM. The group that is attempting the MLOCK has not been granted the proper privleges with the setprivgrp command.
　　If you look at calls, they seem to point to executing the setprivgrp command against the default group for the oracle user. Oracle recommends a group named 'dba'. Unfortunately, executing setprivgrp against dba may not clear up the problem. Look at the user who is running the program,
　　and run setprivgrp against the user's group.
　　In this case, setting setprivgrp for process group resolved the problem.
　　After running setprivgrp, if you are running with an HFS filesystem, you should not have any more problems. If you are running with JFS, you
　　will run into a deadlock. The deadlock is fixed by these patches:
　　S800 PHKL_12946
　　S700 PHKL_12945
　　Note: Patches can be superseded by subsequent versions;

　　be sure to load the current version.