关于您遇到的ORA-65054错误(无法以期望的模式打开可插拔数据库),这个问题通常与Oracle数据库中Pluggable Database (PDB)的打开状态或模式设置有关。以下是一些可能的解决步骤,我将按照您提供的提示进行说明: 1. 确认ORACLE数据库版本与补丁信息 首先,确认您的Oracle数据库版本以及是否已应用所有必要的补丁。这可以通过...
alter pluggable database all open read only * ERROR at line 1: ORA-65085: cannot open pluggable databasein read-only mode 异常原因:创建好ORCLPDB、ORCLPDB3、PDB2之后,需要将这些pluggable数据库打开一次,才能实现all open read only. 解决方案: SQL> alter pluggable database ORCLPDB3open; #依次...
通过上面对status几种状态的说明,对属于NEW的pdb,需要先open。 SQL> alter pluggable database test open; 再对数据库操作open read only操作: [oracle@ora12c ~]$ sqlplus sys/oracle@192.168.10.31:1521/test as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 1 09:53:23 2015 Copyright (...
ORA-65085: cannot open pluggable databasein read-only mode 异常原因:创建好ORCLPDB、ORCLPDB3、PDB2之后,需要将这些pluggable数据库打开一次,才能实现all open read only. 解决方案: SQL> alter pluggable database ORCLPDB3open;#依次将ORCLPDB、PDB2都打开 Pluggable database altered. SQL> show pdbs CON_...
今天尝试创建了一个RAC环境的PDB数据库,在本地执行alter pluggable database pdb01 open 成功了,但是使用上去了plus连接还是连接不上,提示错误如下: 1 2 3 4 5 6 7 8 9 C:\Users\Administrator>sqlplus system/oracle@192.168.1.25:1521/pdb01 SQL*Plus: Release 19.0.0.0.0 - Productionon星期日 11月 19...
alter pluggable database salespdb open; alter pluggable database salespdb save state; 建表空间、用户、表,用于验证 alter session set container=salespdb; create tablespace scotttbs datafile '/u01/app/oracle/oradata/salespdb/scotttbs01.dbf' size 100m; ...
Oracle數據庫10gR1錯誤代碼ORA-01219 描述-database or pluggable database not open: queries allowed on fixed tables or views only。詳細的錯誤ORA-01219 會導致信息和操作建議。
查看监听状态,发现有实例在运行lsnrctl status 连上sqlplussqlplus / as sysdba 查看pdbs状态show pdbs,发现要连接的数据库的open mode为mounted 修改数据库状态alter pluggable database databasename open 再次查看pdbs状态show pdbs,看到数据库已经为read write状态,问题已解决...
SYS@CONSOLTST> alter pluggable database open services=all;Pluggable database altered. ChangesNew 21c installation CauseSign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support account? Click to get started!
--- ABCPDB SQL> 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 根据上面的alert日志和上面的查询,能断定:Oracle 在open一个插入的pdb时向本pdb的数据字典中插入datafile信息,而不是在create pluggable database时