Change User Password

The user can able to change the password in following way:

#sqlplus username@service_name

SQL> password

Old password:

New password:

Retype new password:

Password changed

SQL>

Change Password as Sysdba

SQL> alter user <usernamer> identified by <password>;

User altered.