KB Article #177909
AISuite users in Oracle expired
Problem
-- AISuite components can't start because of the following error:
Cannot create PoolableConnectionFactory (ORA-28001: the password has expired)
Resolution
- This happen because he users in Oracle are expired. To solve this, connect as sysdba to the database.
sqlplus / as sysdba
- check users and the status with the sql command
SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
PASSPORT EXPIRED
REPO EXPIRED
DATASTORECLIENT EXPIRED
REPORTING EXPIRED
DSVIEW OPEN
DSCACHE EXPIRED(GRACE)
DSMAIN OPEN
- For each AISuite user set a password for the locked user
SQL> ALTER USER user_name IDENTIFIED BY password;