Connect as sysdba to the database. [oracle@ijindbclone ~]$ sqlplus / as sysdba Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. Set a password for the locked user. SQL> ALTER USER user_name IDENTIFIED BY password; User altered. Unlock the user account. SQL> ALTER USER user_name ACCOUNT UNLOCK; User altered. Make sure your user is not locked anymore. SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- HR OPEN ANONYMOUS OPEN APEX_040000 LOCKED FLOWS_FILES LOCKE...
catatan pengetahuan hasil emak emak