Oracle Database Discussions

Hi Experts,

One of database in my environment was in hang state, So I tried to shutdown immeidate, But it did not worked. So I ran shutdown immeidate. I got down, But when I start up it's throughing ORA-03113: end-of-file on communication channel Process ID Session ID error. So I mounted it, issued recover command, but it failed that

SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

Database is opening in read only mode , but not in read/write mode. Please advice.




SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size 2226912 bytes
Variable Size 520095008 bytes
Database Buffers 1073741824 bytes
Redo Buffers 7348224 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 29220
Session ID: 80 Serial number: 3



SQL> startup mount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size 2226912 bytes
Variable Size 520095008 bytes
Database Buffers 1073741824 bytes
Redo Buffers 7348224 bytes
Database mounted.
SQL> alter database open read only;
Database altered.
SQL> NAME OPEN_MODE
--------- --------------------
FBTEST READ ONLY