topic Re: 10.2.0.2 sys passwd no longer works in Operating System - HP-UX

10.2.0.2 sys passwd no longer works

Ratzie — Mon, 05 Nov 2007 13:10:05 GMT

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?

Re: 10.2.0.2 sys passwd no longer works

patrik rybar_1 — Tue, 06 Nov 2007 02:29:56 GMT

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.

Re: 10.2.0.2 sys passwd no longer works

Yogeeraj_1 — Tue, 06 Nov 2007 06:24:57 GMT

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

Re: 10.2.0.2 sys passwd no longer works

Ratzie — Tue, 06 Nov 2007 11:05:56 GMT

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

Re: 10.2.0.2 sys passwd no longer works

Ratzie — Tue, 06 Nov 2007 11:39:46 GMT

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!