Answer the question
In order to leave comments, you need to log in
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
show pdbs
Shows all containers.
alter session set container=<имя контейнера>;
Go to the right container.
alter user имя identified by password account unlock;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question