 |
|
Changing remote_login_passwordfile
Oracle Error Tips by Stephanie Filio of Burleson Consulting
|
Many times, users come across ORA-02095 error: specified initialization
parameter can not be modified, when using the alter system command while
attempting to change the remote_login_passwordfile.
This particular problem with the remote_login_passwordfile
setting came up on Oracle dba Forums, with a resolution that
may be helpful to you. It was advised that in order to change
remote_login_passwordfile Oracle users should try
alter system set
remote_login_passwordfile=none scope=spfile
Furthermore, when granting "a sysdba role to a user by using the command:
grant sysdba to admin (admin here is the name of a user)" Oracle users can avoid
ORA-01994: GRANT failed: cannot add users to public password file by restarting
the instance after the alter system with scope=spfile (which was used to change
remote_login_passwordfile).
You may want to examine
this
information page regarding user privileges in conjunction with
Using
orapwd to Connect Remotely as SYSDBA for more information.
