重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: ora-65054 [打印本页]

作者: miss_puff 时间: 2018-1-9 17:44
标题: ora-65054
12C多租户环境启动pdb提示ORA-65054错误。
如下：
SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      MOUNTED
      3 RACDB1PDB                   MOUNTED
SQL> alter pluggable database racdb1pdb open;
alter pluggable database racdb1pdb open
*
ERROR at line 1:
ORA-65054: Cannot open a pluggable database in the desired mode.

重启下数据库，再次Open成功
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  524288000 bytes
Fixed Size                8794696 bytes
Variable Size          377490872 bytes
Database Buffers       134217728 bytes
Redo Buffers             3784704 bytes
Database mounted.
Database opened.
SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 RACDB1PDB                   MOUNTED
SQL> alter pluggable database racdb1pdb open;

Pluggable database altered.

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)