10g say's Database not open . . .tackle ORA-01219

SQL> startup mount

ORACLE instance started.

Total System Global Area  126951228 bytes

Fixed Size                            454460 bytes

Variable Size                       109051904 bytes

Database Buffers               16777216 bytes

Redo Buffers                      667648 bytes

Database mounted.

SQL> select * from dba_users;

select * from dba_users

              *

ERROR at line 1:

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

Now what ? ? ? ? ? ? ?

To check the Database mode :

1) fire up : select open_mode from v$database

2) If its mounted then you need to fire up : alter database open

3) Thats it now you can fire any query you want . . . .

Enjoy 10g ,

Thank You

Reference