asked on

ORA-02095: specified initialization parameter cannot be modified

Hello Gurus .
My remote_login_passwordfile = exclusive I am trying to change it to none but I couldn’t I connected as sys but when issuing this command getting following error

SQL> alter system set remote_login_passwordfile=none
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

I tried to change parameter value in initSid.ora file and recreated spfile from pfile but after that I was not able to open the database so I undo the changes and recreated spfile again as set remote_login_passwordfile=exclusive

BobMc

If you specify set remote_login_password = none, you would need to be authenticated by the OS. Are you a member of the relevant ORA_DBA/ORA_OPER groups?

What version Oracle are you using?
What platform/OS
What errors do you get starting the database up, I assume its not being able to connect as sysdba/sysoper?

Bob

rehman123

ASKER

Oracle9i Enterprise Edition Release 9.0.1.1.1
WIN XP
i don't get any error while starting the database i connected as sys user .

BobMc

You cant modify the parameter for the opened instance, but you should be able to modify it in the spfile, to take affect next time you startup.

try
alter system set remote_login_passwordfile=none scope=file

rehman123

ASKER

I set remote_login_passwordfile=none in init.ora file and after shutting down the instance I startup using this command
startup pfile='f:\orc9i\admin\orc9i\pfile\init.ora'
it shows me s error
ORA-01031: insufficient privileges
I changed remote_log_passwordfile = exclusive in init.ora and again start with same command
startup pfile='f:\orc9i\admin\orc9i\pfile\init.ora'
and it open up the database I m wondering for this error . I uses system user with sysdba privilege ..

ASKER CERTIFIED SOLUTION

seazodiac

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial