01219 oracle,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;

标签：database,数据库,视图,pluggable,oracle,fixed,open,alter

来源： https://www.cnblogs.com/hoge66/p/14410485.html