8 Replies Latest reply: Jan 15, 2013 5:04 AM by Vandy_Kh RSS

    Database not mounted

    Vandy_Kh
      Dear All,

      Related Database is just installed, I got error message as below:

      SQL> shutdown
      ORA-01507: database not mounted


      ORACLE instance shut down.
      SQL> startup
      ORACLE instance started.

      Total System Global Area 217157632 bytes
      Fixed Size 2211928 bytes
      Variable Size 159387560 bytes
      Database Buffers 50331648 bytes
      Redo Buffers 5226496 bytes
      ORA-00205: error in identifying control file, check alert log for more info


      SQL>

      Please kindly give advice for this.

      Thanks and regards,
      Vandy
        • 1. Re: Database not mounted
          Niket Kumar
          check control file location whether they exists on given location or not.
          SQL>  show parameter control_files
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          control_files                        string      C:\APP\J\ORADATA\ORA112\CONTRO
                                                           L01.CTL, D:\ARCH\ORA112\CONTRO
                                                           L02.CTL
          SQL>
          • 2. Re: Database not mounted
            Vandy_Kh
            Dear Niket,

            Thank you very much for your reply and help.


            Now I have checked follow your advice and get the result as below:

            Note: My Oracle Database (11g Realeae 2) is installed on Oracle Linux 5.8

            [oracle@ovmmger ~]$ sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 14 03:14:40 2013

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

            Connected to an idle instance.


            SQL>
            SQL> startup
            ORACLE instance started.

            Total System Global Area 217157632 bytes
            Fixed Size 2211928 bytes
            Variable Size 159387560 bytes
            Database Buffers 50331648 bytes
            Redo Buffers 5226496 bytes
            ORA-00205: error in identifying control file, check alert log for more info


            SQL> show parameter control_files

            NAME TYPE VALUE
            ------------------------------------ ----------- ------------------------------
            control_files string /u01/app/oracle/product/11.2.0
            /db_1/dbs/cntrlDB11G.dbf

            SQL> shutdown
            ORA-01507: database not mounted


            ORACLE instance shut down.
            SQL>


            Please kindly give advice for this.


            Thanks and regards,
            Vandy

            Edited by: Vandy_Kh on Jan 13, 2013 5:56 PM
            • 3. Re: Database not mounted
              415289
              appear control file is not avilable on destination which is define in controlfile parameter.
              /u01/app/oracle/product/11.2.0/db_1/dbs/cntrlDB11G.dbf
              Is this file available at OS level.
              • 4. Re: Database not mounted
                N88
                Can you check the Oraenv and then the control files on the folder where they are supposed to be located.
                • 5. Re: Database not mounted
                  EdStevens
                  960081 wrote:
                  Can you check the Oraenv and then the control files on the folder where they are supposed to be located.
                  oraenv has nothing to do with it. The started instance already shows where it is expecting to find the control files.

                  Oraenv sets enviornment variables, none of which have any bearing on location of control files.

                  Location of control files comes directly from the initialization file, whether it is an spfile or a text init<sid>.ora file.
                  • 6. Re: Database not mounted
                    TSharma-Oracle
                    Can you check and let us know if control file (cntrlDB11G.dbf) physically exists in this following location?

                    /u01/app/oracle/product/11.2.0/db_1/dbs/cntrlDB11G.dbf
                    • 7. Re: Database not mounted
                      N88
                      Thank You Edwards,


                      I have a bad understanding of Oraenv and thanks for the clarification.
                      • 8. Re: Database not mounted
                        Vandy_Kh
                        Dear All Expert,

                        Now, I can resolve this issu.

                        Thanks and regards,
                        Vandy