ORA-01219：数据库未打开：仅在固定表/视图上允许查询 [英] ORA-01219: database not open: queries allowed on fixed tables/views only

问题描述

我使用oracle 11g和SQL开发工具。当我试图从db检索行我得到错误消息为： -

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :-

ORA-01219: database not open: queries allowed on fixed tables/views only)

我找了sgadef.dbf文件，有人可以帮助我，使它工作。

I looked for sgadef.dbf file and it was missing in home directory.. Can someone help me to make it working.

推荐答案

首先检查您使用的实例的状态（这可能需要在管理员帐户下连接） p>

First of all check the status of the instance you work with (this may need to connect under administrator account):

select status from v$instance;

可能会得到

STATUS
------------
MOUNTED

在sys帐户下尝试完成

Under sys account try to complete

ALTER DATABASE OPEN;

并检查其是否已成功完成。
如果没有 - 请分享您的问题中的输出和提醒日志的结果。

and check that it's completed successfuly. If not - please share the result of output and alert log in your question.

这篇关于ORA-01219：数据库未打开：仅在固定表/视图上允许查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！