初始化参数 remote_login_passwordfile起到什么作用

显示全部楼层 · 2005-10-30 17:05:33

如题

千问 · 2005-10-30 17:05:33

sysdba/sysoper用户身份认证

千问 · 2005-10-30 17:05:33

谢谢，帮我解决了一个ora-01994的问题

千问 · 2005-10-30 17:05:33

能否讲详细些

千问 · 2005-10-30 17:05:33

ORA-01994 GRANT failed: cannot add users to shared password file
Cause: A grant failed because a user could not be added to the password file. This is because the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to SHARED.
Action: To add a user to the password file, shut down the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and restart the database

千问 · 2005-10-30 17:05:33

这个参数是针对口令文件的
分为三种情况：
1、none 默认操作，不安全
2、exclusive可由sys/sysoper/经sys授权的用户使用
3、shared只供sys用户使用

千问 · 2005-10-30 17:05:33

NONE
Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.
SHARED
More than one database can use a password file. However, the only user recognized by the password file is SYS.
EXCLUSIVE
The password file can be used by only one database and the password file can contain names other than SYS.

千问 · 2005-10-30 17:05:33

还有一个用途，9i里面默认是不能使用sys的普通身份登陆的，只有sysdba或者sysoper
如果设这个参数为true，就可以像8i一样直接使用conn sys/change_on_install登陆数据库了

千问 · 2005-10-30 17:05:33

最初由 eygle 发布
[B]NONE
SHARED
More than one database can use a password file. However, the only user recognized by the password file is SYS.
. [/B]
请问：如果这个参数设为shared，如何设置多个数据库共享使用同一个口令文件，要在数据库中设置哪些参数。