Skip to main content
Support

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;