After SSH login under Linux:
Su-oracle;
Sqlplus/nolog;
conn system/password; or Connect/as sysdba;
Alter user username identified by password;
=========================================
1. Connect to the database using Oracle User Login
[Email protected] ~]$ Sqlplus/nolog
Sql*plus:release 10.2.0.1.0-production on Thu Feb 26 12:06:29 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Sql> Conn/as SYSDBA
Connected.
View User
Sql> select Username,password from Dba_users;
Modify user password format ALTER user username identified by new password;
sql> alter user system identified by manager;
User altered.
Check again, compare the found password has been replaced
Sql> select Username,password from Dba_users;
Sql>
You can now do this with this password link.
Sql> Connect System/manager
is connected.
==========================
Another way to modify a value
sql> alter user system identified by values ' 2D594E86F93B17A1 ';
The user has changed.
I'm trying this code.
Sql> Connect system/oracle
is connected.
This code is not going to work.
Sql> Connect System/manager
ERROR:
Ora-01017:invalid Username/password; Logon denied
Linux Modify Oracle User