人力资源数据库总是锁定

Question

我已经将HR数据库添加到oracle19c中，但问题是，每次我执行sqldeveloper时，它都会说数据库没有打开，所以我转到cmd并执行以下脚本，但有什么方法可以让它始终打开吗？我不想一直转到cmd。

sqlplus / as sysdba
show con_name;
ALTER SESSION SET CONTAINER = orclpdb;
COLUMN name FORMAT a20;
SELECT name, open_mode from v$pdbs;
ALTER PLUGGABLE DATABASE open;
ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK;
conn hr/hr@orclpdb;
SHOW USER;'

Answer 1

自12.1.0.2起，新子句SAVE STATE被添加到语句ALTER PLUGGABLE DATABASE中。

SQL> show pdbs
CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED                       READ ONLY  NO
3 PDB1                           READ WRITE NO
4 PDB2                           MOUNTED
SQL> shutdown immediate

重启后，所有PDB保持关闭：

SQL> startup
SQL> show pdbs
CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED                       READ ONLY  NO
3 PDB1                           MOUNTED
4 PDB2                           MOUNTED

保留PDB的最后状态(所有具有ALL而非PDB名称的PDB(：

SQL> alter pluggable database pdb1 open;
SQL> alter pluggable database pdb1 save state;

现在，重新启动后，所需的PDB将自动打开：

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED                       READ ONLY  NO
3 PDB1                           READ WRITE NO
4 PDB2                           MOUNTED