1 Reply Latest reply: Jun 17, 2013 7:43 AM by Antonio Navarro RSS

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

    pj0tterke


      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