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

Question

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 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

ALTER DATABASE OPEN;

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

Answer 2

If the problem is related to a pluggable database then you can do the following:

1. Check the status of the PDB

> SELECT name, open_mode FROM v$pdbs ORDER BY name;

NAME      OPEN_MODE
-------------------
ORCLPDB   MOUNTED

2. Change the status to OPEN if it is not (like MOUNTED for example)

ALTER PLUGGABLE DATABASE orclpdb OPEN READ WRITE;