10.2.0.2 sys passwd no longer works

[Ratzie]

I do not know what happened but we can no longer log into the database as sys.

We have two identical databases, one we can log in with sys, the other we cant.
Both have the same parameter:
remote_login_passwordfile =SHARED

How do fix this???
We get an error when trying to change the passwd:
ORA-28046: Password change for SYS disallowed


So some how the passwd got changed, and now we can not set it back.
If we set the remote_login_passwordfile=exclusive
Make the passwd change, then set it back to shared, will this break anything?

[patrik rybar_1]

Error: ORA-28046 (ORA-28046)
Text: Password change for SYS disallowed
---------------------------------------------------------------------------
Cause: REMOTE_LOGIN_PASSWORDFILE is set to SHARED, prohibiting SYS
password changes.
Action: Change setting of REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE or NONE.

[Yogeeraj_1]

hi,

making these changes should not "break anything"!

Unless you have a script hardcoded with the new SYS password (very much discouraged!!)which you are changing back to the old value...

kind regards
yogeeraj

[Ratzie]

So we changed it to NONE
restarted database

Was able to change the passwd for SYS

But we still can not log in to the database with SYS.
Either thru sqlplus or thru Enterprise Manager Console!!!

We also, tried changing the passwd, then starting it back up using the spfile.

Both did not work

[Ratzie]

alter system set REMOTE_LOGIN_PASSWORDFILE=none scope=spfile
shutdown immediate

startup

alter user sys identified by
quit
mv newfilename

#orapwd file=orapwSID password=new_password
alter system set REMOTE_LOGIN_PASSWORDFILE =shared scope=spfile
shutdown immediate
startup

Done!