Changes the Default Profile.

As you can seee the default behaviour for Oracle User to change the password after limiting time, here is the following solution to use Oracle user without changes a password.

sql>conn sys/oracle as sysdba

sql>select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from  dba_users where USERNAME in ('HR');

-- Chech the PASSWORD_LIFE_TIME LIMIT in dba_profiles tables for 'DEFAULT' profile..

sql>select * from dba_profiles where PROFILE='DEFAULT' and RESOURCE_NAME='PASSWORD_LIFE_TIME' ;

-- set 'PASSWORD_LIFE_TIME' limit to 'UNLIMITED'
sql>alter profile DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ;

sql>select * from dba_profiles where PROFILE='DEFAULT' and 
RESOURCE_NAME='PASSWORD_LIFE_TIME' ;

sql>select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from  dba_users where USERNAME in ('HR');