# Error de Password Expirado

Cuando se genera el error

```
ORA-28002: the password will expire within 7 days
28002. 00000 -  "the password will expire within %s days"
*Cause:    The password of the user's account has expired. Since the user's
           account is associated with a password profile with a limited
           password grace period and grace period is yet to elapse, the user
           will not be prompted to input a new password and ORA-28002 warning
           message will continue to be displayed upon each successful login
           to the user account, until the user changes their password.
           Once the grace period elapses, the password will expire and user
           login will start failing with ORA-28001 error, until the user
           changes their password.
*Action:   Change the password or contact the database administrator.
Código de proveedor 28002
```

Fuente

{% embed url="<https://blogs.oracle.com/sql/post/how-to-fix-ora-28002-the-password-will-expire-in-7-days-errors>" %}

Pasos

Primero vemos el nombre del container&#x20;

```plsql
docker ps -a
```

luego ejecuta&#x20;

```plsql
docker exec -it 2b2c75a38833 bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
```

Nos muestra la consola SQL>

Ahora para Conectarse a la base de datos&#x20;

```plsql
connect sysPL as SYSDBA
```

el password es:&#x20;

```plsql
Oradoc_db1
```

Ejecutar

```plsql
 alter profile "DEFAULT" limit password_life_time unlimited;
```

Luego para indicar el numero de días de gracia para el password

```plsql
alter profile "DEFAULT" limit password_grace_time 500;
```

Cambiar la contraseña del usuario

```plsql
 alter user <nombreusuaro> identified by <nuevopassword>;
```

Luego ejecute

```plsql
alter profile "DEFAULT" limit password_life_time unlimited;
alter profile "DEFAULT" limit password_grace_time 500;
alter user <user> identified by <nuevopassword>;
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://avbravo-2.gitbook.io/docker/oracledb-docker/error-de-password-expirado.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.