orapwd 中 entries指定的数究竟有什么用？

blue_stone

entries - maximum number of distinct DBA and OPERs (opt)

fish617

楼上你好，我还是不太明白，请说详细一点儿
我设得entries=1，但是rman 和hr都有sysdba权限了，2已经大于1了，这不是矛盾了吗？
系统是不是应该提示我重新建一个密码文件呢？

blue_stone

原帖由 fish617 于 2006-3-30 11:16 发表
楼上你好，我还是不太明白，请说详细一点儿
我设得entries=1，但是rman 和hr都有sysdba权限了，2已经大于1了，这不是矛盾了吗？
系统是不是应该提示我重新建一个密码文件呢？

我测试也得到了类似的结果，我设置entries=2的时候，可以给5个用户sysdba的权限，设置entries=10的时候可以给13个用户sysdba的权限。
oracle官方文档中找不到解释

我测试的oracle版本是9204 for linux.

fish617

顶一下

cattiger

This parameter specifies the number of entries that you require the password file to
accept. This number corresponds to the number of distinct users allowed to connect
Caution: It is critically important to the security of your system
that you protect your password file and the environment variables
that identify the location of the password file. Any user with access
to these could potentially compromise the security of the
connection to the database as SYSDBA or SYSOPER. The actual number of allowable entries can be higher than the number of users because the ORAPWD utility continues to assign
password entries until an operating system block is filled. For example, if your
operating system block size is 512 bytes, it holds four password entries. The number
of password entries allocated is always multiple of four!

fish617

谢谢楼上,看来很难从密码文件这一层，具体限定以SYSDBA角色登录的用户数。

olivenan

关注ing

blue_stone

我写了一篇文章在我的blog上
是关于orapwd的entries参数的
http://www.cublog.cn/u/7667/?u=h ... howart.php?id=93939

joup

cattiger 发表于 2006-03-30 14:54
This parameter specifies the number of entries that you require the password file to
accept. This n ...

oracle密码文件和文件系大小没有关系，另外，当不指定entries 或者指定的值为0-4时，最多5个用户，
生成的密码文件可以分为几个不同的组，entries参数分别为0-4,5-8,9-12,13-16,17-20 ······