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

Oracle 7.3.3: 进程没有大型文本页的权限。

问题描述

我正在使用 Oracle 7.3.3，syslog显示错误：

Process PID doesn't have memory locking privileges required for using large text pages in system version

为什么会出现这个问题?

配置信息

操作系统 - HP-UX

版本 - 10.20

硬件系统 - HP9000

系列 - K570

应用程序 - Oracle 7.3.3

解决方法

这个错误是Oracle报告的一个已知的问题，新版的 Oracle, 7.3.3增加了一个内存锁定的选项，但它似乎并不是一个真正的选项，而是缺省值。

编辑/etc/privgroup，增加下面的登录项即可解决问题：

root [CHOWN]

users [MLOCK CHOWN LOCKRDONLY]

注: 上述修改只在下一次重新启动时才有效。

在下一次重新启动之前，修改权限设置可以规避这个问题：

/usr/sbin/setprivgrp -g MLOCK CHOWN LOCKRDONLY

注: 进行上述修改后，现在命令 /bin/getprivgrp 可以产生下面的结果：

global privileges: MLOCK CHOWN LOCKRDONLY

.........following with all English text ....

Oracle 7.3.3: Process doesn't have privileges for large text pages.

Problem Description

I am running Oracle 7.3.3. I am getting an error in syslog

Process PID doesn't have memory locking privileges required for using large text pages in system version

What is causing this problem?

Configuration Info

Operating System - HP-UX

Version - 10.20

Hardware System - HP9000

Series - K570

Application - Oracle 7.3.3

Solution

This error is a known problem reported by Oracle. The new version of Oracle, 7.3.3, has a new option to do memory locking, but it appears that it isn't really an option, it's the default.

Solve the problem by making editing /etc/privgroup to make the following entries:

root [CHOWN]

users [MLOCK CHOWN LOCKRDONLY]

Note: The above changes will take effect at the next reboot.

Until the next reboot, work about the problem changing the setting for priviledges:

/usr/sbin/setprivgrp -g MLOCK CHOWN LOCKRDONLY

Note: After the above change, the command /bin/getprivgrp now gives this result:

global privileges: MLOCK CHOWN LOCKRDONLY