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

database sql oracle database-administration
Devoloper250 picture Devoloper250 · Apr 8, 2014 · Viewed 75.5k times · Source

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)

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

Answer

Dmitry Nikiforov picture Dmitry Nikiforov · Apr 8, 2014

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 

ALTER DATABASE OPEN;

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

Related questions

Oracle SQL Developer copy database step by step

I'm having big trouble in copying an Oracle DB to the same server but with another name, to use as a development DB. I'm used to SQL Server, I'm new to Oracle (11g). I wanted to use the 'Database copy' …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More