ORACLE在HP-UX下的系列問(wèn)題處理(19)
2024-08-29 13:39:46
供稿：網(wǎng)友
Oracle: setPRivgrp 解決7.3.3 版內(nèi)存鎖定權(quán)限錯(cuò)誤
問(wèn)題描述
新版的 Oracle, 7.3.3出現(xiàn)下面的錯(cuò)誤:
Process pid num=1 does not have mem locking privileges
required for using large text pages in this version.
See setprivgrp command.
我運(yùn)行了 adb，并安裝了Oracle補(bǔ)丁程序，但問(wèn)題仍然存在。
為什么會(huì)出現(xiàn)這個(gè)問(wèn)題?
配置信息
操作系統(tǒng) - HP-UX
版本 - 10.20
硬件系統(tǒng) - HP9000
系列 - K260
解決方法
基本上Oracle 7.3.3 可執(zhí)行文件運(yùn)行了 chatr，缺省情況下它試圖使用“大文本頁(yè)”：超級(jí)頁(yè)面，超級(jí)頁(yè)面將文本映像鎖定到RAM 中。試圖MLOCK的組沒(méi)有用setprivgrp命令授予適當(dāng)?shù)臋?quán)限。
假如看一下調(diào)用，它們似乎指向?qū)racle用戶的默認(rèn)組執(zhí)行setprivgrp命令。Oracle 建議名字叫'dba' 的組。遺憾的是，對(duì)dba執(zhí)行setprivgrp可能解決不了問(wèn)題。查看正在運(yùn)行該程序的用戶，對(duì)該用戶的組運(yùn)行setprivgrp。
在這個(gè)例子中，設(shè)置繼續(xù)組的setprivgrp解決了問(wèn)題。
運(yùn)行setprivgrp后，假如使用的是HFS文件系統(tǒng)，則不應(yīng)當(dāng)再出現(xiàn)任何問(wèn)題；假如使用JFS，就會(huì)出現(xiàn)死鎖。下面的補(bǔ)丁程序可以解決死鎖的問(wèn)題：
S800 PHKL_12946
S700 PHKL_12945
注：補(bǔ)丁程序可以被后來(lái)的版本替代；因此確保加載最新的版本。
.........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.
