ORA-01219：数据库未打开：仅在固定表/视图上允许查询

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

我正在使用oracle 11g和SQL开发人员工具。当我试图从数据库中检索行时,我收到错误消息: -

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

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

我找了sgadef.dbf文件,它在主目录中丢失了..有人可以帮助我使它工作。

2 个解决方案

#1

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;

Probably you will get

可能你会得到

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

Under sys account try to complete

在sys帐户下尝试完成

ALTER DATABASE OPEN;

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

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

#2

SQL>

ALTER DATABASE OPEN;
ALTER DATABASE OPEN *

ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\APP\ADMINISTRATOR\ORADATA\WIND\SYSTEM01.DBF'

#1