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

linareja · 10-13-2008, 09:27 AM

I have following problem opening the database in oracle, could anyone tell me any idea about how to fix it? Thanks

bash-3.00$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Lun Oct 13 16:00:14 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1063426108 bytes
Fixed Size 452668 bytes
Variable Size 335544320 bytes
Database Buffers 716800000 bytes
Redo Buffers 10629120 bytes
ORA-00439: feature not enabled: Real Application Clusters

SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

TB0ne · 10-13-2008, 09:37 AM

Quote:

Originally Posted by linareja

I have following problem opening the database in oracle, could anyone tell me any idea about how to fix it? Thanks

bash-3.00$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Lun Oct 13 16:00:14 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1063426108 bytes
Fixed Size 452668 bytes
Variable Size 335544320 bytes
Database Buffers 716800000 bytes
Redo Buffers 10629120 bytes
ORA-00439: feature not enabled: Real Application Clusters

SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

Yeah, your database isn't open. Have you contacted Oracle?

linareja · 10-13-2008, 09:45 AM

Quote:

Originally Posted by TB0ne

Yeah, your database isn't open. Have you contacted Oracle?

But, is not it supposed to be opened when the command 'startup' is introduced? Once I had the same problem and it was fixed creating the database again but I do not want to do it each time I have this problem!

Any special way to open it or something like this?