Re: How can I find (or change) password for SYS?

If the person created the database through dbca (database creation assistant) then they were prompted for a sys password.. Thats probably why it isn't change_on_install

To change the sys password do the following:

1. Connect to the server and set your environment (ORACLE_HOME, ORACLE_SID).
2. Connect to Oracle. sqlplus /nolog SQL> connect / as sysdba
3. To change the sys password type: SQL> alter user sys identified by newpassword;

-- 
----
david.best_at_sympatico.ca
"Thanks to the remote control I have the attention span of a gerbil!"
"There are 10 types of people in the world.  Those who understand binary,
and those who don't."
"Randi W" <randiwolner_at_hotmail.com> wrote in message
news:d9dk3n$h7j$1_at_services.kq.no...


> Hello,

> Someone (not me) has installed Oracle 9.2.0.1.0, and I do not know what

the


> password for SYS is. In Oracle 8.1.7 the password was CHANGE_ON_INSTALL if

> nothing was done to the default setup.

> Is there another default for 9.2.0.1.0 ?

> If there is not a default, or if another password was chosen at install

> time - is there any way I can find out what the password is?

> Or - as an alternative - is there any way to change the password for SYS

> without knowing what it's password was?

>

> Thanks for any help,

> Randi W

>

>