oracle

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;

while working on autonomous database after import of soe schema, I got following error while doing compilations of package owned by soe schema:  Copyright (c) 1982, 2019, Oracle.  All rights reserved. Last Successful login time: Wed Feb 10 2021 20:56:22 +05:30 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> ALTER PACKAGE SOE.ORDERENTRY COMPILE BODY; Warning: Package Body altered with compilation errors. SQL> sho error Errors for PACKAGE BODY SOE.ORDERENTRY: LINE/COL ERROR -------- ----------------------------------------------------------------- 104/13   PL/SQL: Statement ignored 104/13   PLS-00201: identifier 'DBMS_LOCK' must be declared 107/13   PL/SQL: Statement ignored 107/13   PLS-00201: identifier 'DBMS_LOCK' must be declared SQL> GRANT execute ON DBMS_LOCK TO soe; Grant succeeded. SQL> ALTER PACKAGE SOE.ORDERENTRY COMPILE BODY; Package body altered. SQL>