Linux ora 01219,ORA-01219 - “database or pluggable database not open: queries allowed on fixed table...

3764672 wrote:Hello everyone,I've just installed oracle database 18c on my windows 10 machine. Then I used Oracle SQL Developer to login to the database that I've created during the installation with connection information below: [![sqldeveloper1][1]][1]The connection was successful and when I tried to open the Tables, it showed an error OCA-01219:[![enter image description here][2]][2] I've found this solution: [ORA-01219: database not open: queries allowed on fixed tables/views only][3] that trying to make the database open. I have tried this but still no success, my database status: [![enter image description here][4]][4]Can anyone please help to to solve this problem? Thank you very much in advanced. [1]: https://i.stack.imgur.com/9rfPD.png [2]: https://i.stack.imgur.com/7Fwbz.png [3]: https://stackoverflow.com/questions/22940636/ora-01219-database-not-open-queries-allowed-on-fixed-tables-views-only [4]: https://i.stack.imgur.com/I6IJm.png

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.

What results when you issue SQL below?

ALTER DATABASE OPEN;

Please click on URL below & respond accordingly