Operating System - HP-UX
1748171 Members
4288 Online
108758 Solutions
New Discussion юеВ

Re: 10.2.0.2 sys passwd no longer works

 
Ratzie
Super Advisor

10.2.0.2 sys passwd no longer works

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?



4 REPLIES 4
patrik rybar_1
Frequent Advisor

Re: 10.2.0.2 sys passwd no longer works

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
Honored Contributor

Re: 10.2.0.2 sys passwd no longer works

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Ratzie
Super Advisor

Re: 10.2.0.2 sys passwd no longer works

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
Super Advisor

Re: 10.2.0.2 sys passwd no longer works

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!