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.