V
V
Vladimir2020-06-29 16:07:31
Oracle
Vladimir, 2020-06-29 16:07:31

How to update Expire password on oracle 12c?

There is a separate dev base on oracle 12c. I don't know anything about her at all. there is access by root and sysdba.
It seems to have raised a multi tenant container on it, why the truth is not clear to me.
There is one database in which users have expired by password.
I try to restore according to the instructions on the Internet, but each time it returns

ALTER USER USERNAME ACCOUNT UNLOCK;
ALTER USER USERNAME IDENTIFIED BY PASSWORD;

ORA-65048: error encountered when processing the current DDL statement in
pluggable database DB
ORA-01918: user 'USERNAME' does not exist

If I do ALTER SESSION SET CONTAINER=db;

starts writing that there is simply no such user
ORA-01918: user 'USERNAME' does not exist

In oracle I don’t rummage at all, I don’t understand at all how it should work. How to restore a user?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
E
Eugene, 2020-06-29
@idskill

show pdbs
Shows all containers.
alter session set container=<имя контейнера>;
Go to the right container.

alter user имя identified by password account unlock;

Unblock the user in the container.
If ORA-01918, then either the container is not the right one, or the username is incorrect (it is specified without quotes).

K
Konstantin Tsvetkov, 2020-06-29
@tsklab

ALTER USERUsername.
Documentation: How To Unlock a User .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question