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

0 comments:

Post a Comment