Troubles with changing password for SYS in password file

From: mariok <mario.kackovic_at_gmail.com>
Date: Thu, 6 Dec 2007 10:09:54 -0800 (PST)
Message-ID: <b38b8427-b3c1-4285-aef4-7f1eaa450d64@l1g2000hsa.googlegroups.com>

Extract from manual tells:

"If you issue the ALTER USER statement to change the password for SYS after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated, but..."

on my O10gR2 database it works as follows:

18:37:15 SQL> conn sys/oracle_at_orcl as sysdba Connected.
18:46:27 SQL> select username, password from dba_users where username='SYS';

USERNAME PASSWORD
--------------- ------------------------------
SYS 8A8F025737A9097A 18:48:12 SQL> alter user sys identified by ora;

User altered.

18:48:59 SQL> select username, password from dba_users where username='SYS';

USERNAME PASSWORD
--------------- ------------------------------
SYS 03EA201D12FA4679 18:49:02 SQL> conn sys/ora_at_orcl as sysdba Connected.
18:49:17 SQL> alter user sys identified by values '8A8F025737A9097A'; !!! password is oracle !!!

User altered.

18:50:21 SQL> conn sys/oracle_at_orcl as sysdba ERROR:
ORA-01031: insufficient privileges !!! I cannot connect because password isn't changed in passwordfile !!!

Warning: You are no longer connected to ORACLE. 18:50:31 SQL> conn sys/ora_at_orcl as sysdba Connected.
18:51:14 SQL> alter user sys identified by oracle;

User altered.

18:51:25 SQL> select username, password from dba_users where username='SYS';

USERNAME PASSWORD
--------------- ------------------------------
SYS 8A8F025737A9097A 18:51:34 SQL> conn sys/oracle_at_orcl as sysdba Connected.
18:51:49 SQL> disc
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

So, my conclusion (is that truth?):

I can change password for sys in password file with "alter user sys identified by <passwd>" statement, but
I cannot do that with "alter user sys identified by values '<hash>' " statement.

Is there anybody who can tell me how to change password for sys in password file without providing the password itself? Received on Thu Dec 06 2007 - 12:09:54 CST