HOW TO UNLOCK HR AND SCOTT USER in Oracle Database 19c

SQLPLUS / as SYSDBA

COLUMN name FORMAT a20;

SELECT name,con_id FROM v$pdbs;

SELECT name as “Service Name” FROM v$active_services WHERE con_id=3;
SQLPLUS / as SYSDBA

SHOW con_name

ALTER SESSION SET CONTAINER=orclpdb;

COLUMN name FORMAT a20;

SELECT name,con_id FROM v$pdbs;

SELECT name,open_mode FROM v$pdbs;

ALTER PLUGGABLE DATABASE open;

ALTER USER hr identified by hr ACCOUNT UNLOCK;
—- SCOTT USER :

COLUMN name FORMAT a20;

SELECT name,con_id FROM v$pdbs;

CONN / AS SYSDBA

ALTER SESSION SET CONTAINER=orclpdb;

CREATE USER SCOTT IDENTIFIED BY TIGER;

GRANT DBA TO SCOTT;

CONN SCOTT/TIGER@orclpdb

URL for scott schema : https://docs.google.com/document/d/1brKxdadCEU7t4fEcsPKaTmxKSBP7W4Tf2slFlFAMGDc/edit?usp=sharing