Oracle Database: Reset User Password and disable passowrd expiration.
SQL> select resource_name,limit from dba_profiles where profile=’DEFAULT’ and RESOURCE_NAME=’PASSWORD_LIFE_TIME’; RESOURCE_NAME LIMIT ——————————– —————————————- PASSWORD_LIFE_TIME 180 alter profile DEFAULT limit password_life_time UNLIMITED; alter user oblicore identified by oblicore;