- 论坛徽章:
- 0
|
原帖由 netzh 于 2007-9-19 11:00 发表 ![]()
楼主写的不错，加精了。
但是有些地方不太完善，比如没有设置oracle用户MLOCK权限。
修改后就完美了
谢谢斑竹，终于加精了。
你说的mlock权限，个人认为不是必须的，就没加上。如果要加mlock可以参考以下：
Complete root user set-up tasks:
1. Log in as the root user.
2. Create database administrator groups by using the System Administrator's Menu (SAM).
The OSDBA group, typically dba.
The optional OSOPER, group, typically oper.
The optional ORAINVENTORY group, typically oinstall.
Grant the OSDBA group RTSCHED, RTPRIO and MLOCK privileges.
A new HP scheduling policy called SCHED_NOAGE enhances Oracle9i's performance
by scheduling Oracle processes so that they do not increase or decrease in priority, or become preempted.
The RTSCHED and RTPRIO privileges grant Oracle the ability to change its process scheduling policy to SCHED_NOAGE and also tell Oracle what priority level it should use when setting the policy. The MLOCK privilege grants Oracle the ability to execute asynch I/Os through the HP asynch driver. Without this privilege, Oracle9i generates trace files with the following error message: "Ioctl ASYNCH_CONFIG error, errno = 1".
As root, do the following:
If it does not already exist, create the /etc/privgroup file. Add the following line to the file:
dba MLOCK RTSCHED RTPRIO
Use the following command syntax to assign these privileges:
$ Setprivgrp -f /etc/privgroup
In the preceding command, groupname is the name of the group that receives the privileges, and privileges are the privileges that are granted to the group.
另外文档中有几个错误，在此更正一下：
1）P9中，说明在hpnode4 中export ORACLE_SID=r9i，应改为r9i2
2)p14中，还有点要强调如果您的redo log 为奇数个，比如为3 个。下面的贴图贴成了control file的图，笔误。
看参考下面这个图。
[ 本帖最后由 nebula2000 于 2007-9-21 08:57 编辑 ] |
|
免费注册
发表于 2007-09-05 17:12
