- 論壇徽章:
- 0
|
原帖由 netzh 于 2007-9-19 11:00 發(fā)表 ![]()
樓主寫的不錯(cuò)，加精了。
但是有些地方不太完善，比如沒(méi)有設(shè)置oracle用戶MLOCK權(quán)限。
修改后就完美了
謝謝斑竹，終于加精了。
你說(shuō)的mlock權(quán)限，個(gè)人認(rèn)為不是必須的，就沒(méi)加上。如果要加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.
另外文檔中有幾個(gè)錯(cuò)誤，在此更正一下：
1）P9中，說(shuō)明在hpnode4 中export ORACLE_SID=r9i，應(yīng)改為r9i2
2)p14中，還有點(diǎn)要強(qiáng)調(diào)如果您的redo log 為奇數(shù)個(gè)，比如為3 個(gè)。下面的貼圖貼成了control file的圖，筆誤。
看參考下面這個(gè)圖。
[ 本帖最后由 nebula2000 于 2007-9-21 08:57 編輯 ] |
|
免費(fèi)注冊(cè)
發(fā)表于 2007-09-05 17:12
