Solution 2
Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITEDthen change the password to avoid it permanently
c:\> sqlplus scott/tiger
SQL> connect / as sysdba
Connected.
SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';
PROFILE
------------------------------
DEFAULT
SQL> SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'
AND RESOURCE_NAME='PASSWORD_LIFE_TIME';
LIMIT
----------------------------------------
60
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';
ACCOUNT_STATUS
--------------------------------
EXPIRED(GRACE)
SQL> connect scott/tiger
Connected.
SQL> PASSWORD
Changing password for SCOTT
Old password:
New password:
Retype new password:
Password changed