This discussion is archived
1 Reply Latest reply: Jun 17, 2013 5:43 AM by Antonio Navarro RSS

ORA-03113: end-of-file on communication channel

pj0tterke Newbie
Currently Being Moderated


I am trying to open my standby database but this fails with the following error

 

SQL> startup nomount
ORACLE instance started.

Total System Global Area  107939720 bytes
Fixed Size                   100232 bytes
Variable Size              50216960 bytes
Database Buffers           57344000 bytes
Redo Buffers                 278528 bytes
SQL> alter database mount standby database;

Database altered.

SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL>

 

The strange thing is, according to v$database the instance is open in read only mode just as the statement must do (alter database open read only)

 

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ ONLY

SQL>

 

But when connecting with an ordinary user I get

 

SQL> connect outln/outln
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Warning: You are no longer connected to ORACLE.
SQL>

So it seems open as read onyl, but in some way it is not open. It is in a historic version of Oracle (please don't laugh) it's Oracle version 8.1.7.on OpenVMS

 

Anyone?

 

tia.

 

Peter