ORA-01219: 数据库或可插入数据库未打开: 仅允许在固定表或视图中查询 oracle

一周没用过oracle,打开数据库的时候报错:

执行请求的操作时遇到错误:

ORA-01219: 数据库或可插入数据库未打开: 仅允许在固定表或视图中查询
01219. 00000 - "database or pluggable database not open: queries allowed on fixed tables or views only"
*Cause: A query was issued against an object not recognized as a fixed
table or fixed view before the database or pluggable database has
been opened.
*Action: Re-phrase the query to include only fixed objects, or open the
database or pluggable database.
供应商代码 1219

解决:

1、重启电脑,不管用;

2、连接上sys后,执行下面语句:

select open_mode from v$database;

alter database open;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

  

3、上面语句执行后基本正常,然后切换容器:


alter pluggable database orclpdb open;
alter session set container=orclpdb;

ORA-01219: 数据库或可插入数据库未打开: 仅允许在固定表或视图中查询 oracle

上一篇:mysql 定时器event_scheduler重启后自动设置off,如何修改固定on


下一篇:jdbc连接MySql数据库