Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01219 - “database or pluggable database not open: queries allowed on fixed tables or views only”

3764672Dec 21 2018 — edited Dec 24 2018

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:

sqldeveloper.PNG

The connection was successful and when I tried to open the Tables, it showed an error OCA-01219:

sqldeveloper1.PNG

I've found this solution:

https://stackoverflow.com/questions/22940636/ora-01219-database-not-open-queries-allowed-on-fixed-tables-views-only that trying to make the database open.

I have tried this but still no success, my database status:

sqldeveloper2.PNG

Can anyone please help to to solve this problem? Thank you very much in advanced and Merry Christmas!

Comments
Post Details
Added on Dec 21 2018
3 comments
26,048 views