首页 > 数据库技术 > 详细

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

时间:2021-02-18 10:36:18      阅读:43      评论:0      收藏:0      [点我收藏+]

一周没用过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

原文:https://www.cnblogs.com/hoge66/p/14410485.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!