Friday, April 26, 2024

ORDS was unable to make a connection to the database. The database user specified by db.username configuration setting is expired. The connection pool named: |default|lo| had the following error(s): ORA-28001: the password has expired

 First login to the user sys

and 

alter user sys identified by s;


open CMD at administrative mode

sqlplus /nolog

conn sys as sysdba

password:s

alter session set container = ORCLPDB;

column name format a15;

alter pluggable database open;

alter pluggable database ORCLPDB save state;

 alter user oriondb identified by o;

ALTER USER apex_public_user identified by s ACCOUNT UNLOCK;


ALTER USER apex_listener identified by s ACCOUNT UNLOCK;

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

 ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY s;

No comments:

Post a Comment