4 Replies Latest reply on Oct 5, 2012 5:18 AM by Srini Chavali-Oracle

    ORA-01034+27101:Can't start db after applying Oracle 11g patch (

      I installed Oracle Database Enterprise and it runned without problems.

      After applying Oracle 11g patch (, i get this errors on starting the db:
      sqlplus "/as sysdba"
      SQL*Plus: Release - Production on Tue May 12 10:38:45 2009
      Copyright (c) 1982, 2008, Oracle. All rights reserved.
      Connected to an idle instance.

      SQL> startup mount

      ORACLE instance started.
      Total System Global Area 1018830848 bytes
      Fixed Size 2166048 bytes
      Variable Size 251658976 bytes
      Database Buffers 759169024 bytes
      Redo Buffers 5836800 bytes
      Database mounted.

      SQL> alter database open
      ERROR at line 1:
      ORA-01092: ORACLE instance terminated. Disconnection forced
      Process ID: 20257
      Session ID: 170 Serial number: 5


      Listener is ok:

      lsnrctl start
      LSNRCTL for Linux: Version - Production on 12-MAY-2009 10:51:27

      Copyright (c) 1991, 2008, Oracle. All rights reserved.

      Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version - Production
      System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
      Log messages written to /u01/app/oracle/diag/tnslsnr/cochise/listener/alert/log.xml
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cochise)(PORT=1521)))

      STATUS of the LISTENER
      Alias LISTENER
      Version TNSLSNR for Linux: Version - Production
      Start Date 12-MAY-2009 10:51:27
      Uptime 0 days 0 hr. 0 min. 0 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
      Listener Log File /u01/app/oracle/diag/tnslsnr/cochise/listener/alert/log.xml
      Listening Endpoints Summary...
      Services Summary...
      Service "CO11G" has 1 instance(s).
      Instance "CO11G", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully


      Have you any suggestion please?