Purpose:
To recover the asuser account in the appstream database.
Cause:
The asuser account for the appstream database has expired, locked out, or forgotton password.
Resolution:
Un-expiring an Oracle account and keeping the same password
# Get connected to the database (administrator account password not required to connect)
sqlplus.exe administrator@ORCL AS SYSDBA
#Check the status of the ASUSER account
SQL> select USERNAME, ACCOUNT_STATUS from DBA_USERS where USERNAME='ASUSER';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ASUSER EXPIRED
#Check the profile that ASUSER belongs to
SQL> select profile from DBA_USERS where USERNAME='ASUSER';
PROFILE
------------------------------
DEFAULT
#Set the DEFAULT profile password to unlimited life time
SQL> alter profile DEFAULT limit password_life_time UNLIMITED;
Profile altered.
#Set the DEFAULT profile to unlimited password reuse
SQL> alter profile DEFAULT limit password_reuse_time UNLIMITED;
Profile altered.
#Select the user based on his password
SQL> select password from user$ where name='ASUSER';
PASSWORD
------------------------------
541D5B19B4A49E44
#Modify the user
SQL> alter user ASUSER identified by values '541D5B19B4A49E44';
User altered.
#Check the status of the ASUSER account
SQL> select USERNAME, ACCOUNT_STATUS from DBA_USERS where USERNAME='ASUSER';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ASUSER OPEN
#All set!!