Password problem

[Paul H]

Oracle 8.1.7. - Windows 2000

I am needing to change the default password of 'sys' it is currently "change_on_install".

I shutdown the DB. Stopped the service. Renamed the 'pwd' file. Then i did orapwd file= '........' password = xxxxxx

Started the service. Tried to connect but the password had'nt changed???!!! Why?

I can still connect but using the old password??

NB
In the init.ora REMOTE_LOGIN_PASSWORDFILE = EXCUSIVE.

[Minesh]

Hi Paul,

You are right on track. rename the pwd.ora file and then run following command on dos prompt.

c:> orapwd file=c:\oracle\ora81\database\pwdsid.ora password=psw entries=10


here file=you oracle home dirictory path where pwd.ora file is stored.


try it.

[Paul H]

Yes thanks. But I've done all that already. I read in metalink that I may have to change the registry, can anyone confirm?

[amar]

I don't know what you mean when you say "default" password for SYS - but if you just want to change the password for user SYS to something else from "change_on_install" - just use the ALTER USER SYS IDENTIFIED BY while being logged on as an use with DBA priv. This will be automatically reflected in the password file.

-amar

[leo]

Password file is being used only when data dictionary is not available (i.e. your database is down or not open). All other times the password that is stored in data dictionary is used.

Use alter user to change the password:

alter user system identified by new_password;

new_password is whatever you want new password to be.

NOte that it will not change password in the password file.

Leo

[Paul H]

Thanks everyone. I used the alter statement and it changed my password for 'sys' and 'internal' just as I wanted.

[julian]

I recommend reading the article about SYS' password in the last issue of Oracle Magazine.