This discussion is archived
3 Replies Latest reply: Oct 5, 2013 10:35 AM by Dude! RSS

Oracle Linux virtual machines failing to boot

user7222768 Newbie
Currently Being Moderated

We have 2 oracle linux virtual machines on one host machine, both running Oracle Linux release 6 update 2 for X86_64. Both were built identically with oracle 11 installed on them. Both machines were working ok until this morning when the host machine rebooted. After the reboot, the virtual machines now hang during the boot process. The login prompt never comes up. The database does not start up on both machines. The machines are up enough that I could putty into them. In  startup.log, the following is listed for the two machines. One is named demo, the other test.

 

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 4 12:24:02 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area  438423552 bytes

Fixed Size            2214136 bytes

Variable Size          331351816 bytes

Database Buffers      100663296 bytes

Redo Buffers            4194304 bytes

Database mounted.

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: '/u02/oradata/demo/redo02.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

/u01/app/oracle/dbhome_1/bin/dbstart: Database instance "demo" warm started.

 

 

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 4 13:06:49 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area  438423552 bytes

Fixed Size            2214136 bytes

Variable Size          331351816 bytes

Database Buffers      100663296 bytes

Redo Buffers            4194304 bytes

Database mounted.

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

Process ID: 3665

Session ID: 1 Serial number: 5

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

/u01/app/oracle/dbhome_1/bin/dbstart: Database instance "test" warm started.

 

The demo machine is looking for a redo log file. The file does not exist. If that file ever existed, what would make that file disappear? The test machine does not have any redo log files either but the test one is not even looking for it.

 

What could have gone wrong with these?

  • 1. Re: Oracle Linux virtual machines failing to boot
    EdStevens Guru
    Currently Being Moderated

    user7222768 wrote:

     

    We have 2 oracle linux virtual machines on one host machine, both running Oracle Linux release 6 update 2 for X86_64. Both were built identically with oracle 11 installed on them. Both machines were working ok until this morning when the host machine rebooted. After the reboot, the virtual machines now hang during the boot process. The login prompt never comes up. The database does not start up on both machines. The machines are up enough that I could putty into them. In  startup.log, the following is listed for the two machines. One is named demo, the other test.

     

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 4 12:24:02 2013

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

    SQL> Connected to an idle instance.

    SQL> ORACLE instance started.

    Total System Global Area  438423552 bytes

    Fixed Size            2214136 bytes

    Variable Size          331351816 bytes

    Database Buffers      100663296 bytes

    Redo Buffers            4194304 bytes

    Database mounted.

    ORA-00313: open failed for members of log group 2 of thread 1

    ORA-00312: online log 2 thread 1: '/u02/oradata/demo/redo02.log'

    ORA-27037: unable to obtain file status

    Linux-x86_64 Error: 2: No such file or directory

    Additional information: 3

    SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    /u01/app/oracle/dbhome_1/bin/dbstart: Database instance "demo" warm started.

     

     

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 4 13:06:49 2013

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

    SQL> Connected to an idle instance.

    SQL> ORACLE instance started.

    Total System Global Area  438423552 bytes

    Fixed Size            2214136 bytes

    Variable Size          331351816 bytes

    Database Buffers      100663296 bytes

    Redo Buffers            4194304 bytes

    Database mounted.

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

    Process ID: 3665

    Session ID: 1 Serial number: 5

    SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    /u01/app/oracle/dbhome_1/bin/dbstart: Database instance "test" warm started.

     

    The demo machine is looking for a redo log file. The file does not exist. If that file ever existed, what would make that file disappear? The test machine does not have any redo log files either but the test one is not even looking for it.

     

    What could have gone wrong with these?

     

    Perhaps not all the file system mounted.

    Does /u02/oradata/demo exist?

    How about /u02/oradata

    How about /u02

  • 2. Re: Oracle Linux virtual machines failing to boot
    user7222768 Newbie
    Currently Being Moderated

    Yes the directory is there. There are other system level files present in /u02/oradata/demo, just not the redo log file it is looking for. I don't think the redo log file ever existed in this directory.  The test machine does not have it either.

  • 3. Re: Oracle Linux virtual machines failing to boot
    Dude! Guru
    Currently Being Moderated

    There can be a lot of reasons for the failure. Did you specify enough RAM for your virtual machine? What virutalization product are you using?

     

    You can try to press F2 during system startup and perhaps see where the problem occurs.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points