Oracle Database Discussions

SQL> conn /as sysdba
Connected.
SQL> conn hr/hr
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

-----
I tried to fixed this way but I could not.
-----
: -----

SQL> conn /as sysdba
Connected.
SQL> select status from v$instance
2 ;

STATUS
------------
MOUNTED

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 753278976 bytes
Fixed Size 1374724 bytes
Variable Size 469763580 bytes
Database Buffers 276824064 bytes
Redo Buffers 5316608 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[332], [94], [138], [], [], [], [], [], [], []


SQL> select status from v$instance
2 ;

STATUS
------------
MOUNTED

SQL> Select object_name,object_type,owner from dba_objects where data_object_id=
332
2 ;
Select object_name,object_type,owner from dba_objects where data_object_id=332
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> conn /as sysdba
Connected.
SQL> Select object_name,object_type,owner from dba_objects where data_object_id=
332
2 ;
Select object_name,object_type,owner from dba_objects where data_object_id=332
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 753278976 bytes
Fixed Size 1374724 bytes
Variable Size 469763580 bytes
Database Buffers 276824064 bytes
Redo Buffers 5316608 bytes
Database mounted.
SQL> recover database
Media recovery complete.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[332], [94], [138], [], [], [], [], [], [], []