In addition to creating the password file, you must also set the initialization parameter
REMOTE_LOGIN_PASSWORDFILE to the appropriate value. The values recognized are:
■ NONE: Setting this parameter to NONE causes Oracle Database to behave as if the
password file does not exist. That is, no privileged connections are allowed over
nonsecure connections.
■ EXCLUSIVE: (The default) An EXCLUSIVE password file can be used with only
one instance of one database. Only an EXCLUSIVE file can be modified. Using an
EXCLUSIVE password file enables you to add, modify, and delete users. It also
enables you to change the SYS password with the ALTER USER command.
■ SHARED: A SHARED password file can be used by multiple databases running on
the same server, or multiple instances of a Real Application Clusters (RAC)
database. A SHARED password file cannot be modified. This means that you
cannot add users to a SHARED password file. Any attempt to do so or to change
the password of SYS or other users with the SYSDBA or SYSOPER privileges
generates an error. All users needing SYSDBA or SYSOPER system privileges must
be added to the password file when REMOTE_LOGIN_PASSWORDFILE is set to
EXCLUSIVE. After all users are added, you can change
REMOTE_LOGIN_PASSWORDFILE to SHARED, and then share the file.
This option is useful if you are administering multiple databases or a RAC
database.
If REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE or SHARED and the password
file is missing, this is equivalent to setting REMOTE_LOGIN_PASSWORDFILE to NONE.
设置REMOTE_LOGIN_PASSWORDFILE
该参数的三个状态为 :
1. NONE : 当作密码文件不存在
2. EXCLUSIVE : 可在密码文件新增,修改,删除用户 , 可使用alter user更改sys用户的密码
3. SHARED : 密码文件在同一服务器的多个数据库上可用 或 RAC下的多实例环境中 .
密码文件中不能添加用户 , 不能更改sys密码
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-995388/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-995388/