9 Replies Latest reply on Jul 4, 2006 10:07 AM by 409632

    ORA-27086: unable to lock file - already in use

    508964
      Hi All,

      Can any one having Idea about this Error while Upgrading from 9.2.0.4.0 to 10.2.0.2.0 on AIX 5.2 after software Installation before patch set apply when i try to start the Database im Getting this Error Below

      SQL> startup mount
      ORACLE instance started.

      Total System Global Area 784334848 bytes
      Fixed Size 2022384 bytes
      Variable Size 550634512 bytes
      Database Buffers 229507072 bytes
      Redo Buffers 2170880 bytes
      ORA-00205: error in identifying control file, check alert log for more info

      Alert_LOG

      Mon Jul 3 09:17:15 2006
      ORA-00202: control file: '/oracle/QAS/sapdata1/cntrl/cntrlQAS.dbf'
      ORA-27086: unable to lock file - already in use
      IBM AIX RISC System/6000 Error: 13: Permission denied
      Additional information: 8
      Additional information: 26492


      Please Help me..........
      Ahmed
        • 1. Re: ORA-27086: unable to lock file - already in use
          376714
          Hi,

          Seems you got a problem with a controlfile.
          IBM AIX RISC System/6000 Error: 13: Permission denied
          note that the O.S. error seems to be an access right problem, so run:
          ls -al /oracle/QAS/sapdata1/cntrl/cntrlQAS.dbf
          id
          to check if you have enough access rights to open/lock the file.

          HTH,

          Yoann.
          • 2. Re: ORA-27086: unable to lock file - already in use
            kuljeet singh -
            check do u have proper permission to access this file?
            and also check whether Is this file is access by 9i database or not.if this is the condition then shutdown the database and startup from 10g home.

            27086, 00000, "skgfglk: unable to lock file - already in use"
            // *Cause:  the file is locked by another process, indicating that it is
            // currently in use by a database instance.
            // *Action: determine which database instance legitimately owns this file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
            • 3. Re: ORA-27086: unable to lock file - already in use
              508964
              Hi,

              When i ls -al is gives this '
              -rwxrwxr-x 1 oraqas dba 31678464 Jul 03 13:03 /oracle/QAS/sapdata1/cntrl/cntrlQAS.dbf

              And on this server there is only one database and i m opening by oracle_home 10g
              this file system is on Raw Device SAN any idea...........


              Thanks for quick response

              Ahmed
              • 4. Re: ORA-27086: unable to lock file - already in use
                kuljeet singh -
                Hi,

                1.before starting the oracle,verify there is no oracle process on server by
                ps -ef|grep ora_

                2.Did you started ur database after logging from oraqas user(OS user).?
                • 5. Re: ORA-27086: unable to lock file - already in use
                  508964
                  Hi,
                  this is the output below

                  oraqas 16> ps -ef|grep ora_

                  oraqas 20802 1 0 Jul 02 - 0:01 ora_mmnl_QAS
                  oraqas 22088 1 0 Jul 02 - 0:01 ora_mmon_QAS
                  oraqas 23014 1 0 Jul 02 - 0:00 ora_reco_QAS
                  oraqas 25134 1 0 Jul 02 - 0:01 ora_smon_QAS
                  oraqas 26492 1 0 Jul 02 - 0:04 ora_ckpt_QAS
                  oraqas 28206 1 0 Jul 02 - 0:01 ora_lgwr_QAS
                  oraqas 28486 1 0 Jul 02 - 0:01 ora_dbw0_QAS
                  oraqas 28884 1 0 Jul 02 - 0:01 ora_mman_QAS
                  oraqas 29400 1 0 Jul 02 - 0:01 ora_psp0_QAS
                  oraqas 32950 1 0 Jul 02 - 0:06 ora_pmon_QAS
                  oraqas 42326 39020 0 13:23:35 pts/0 0:00 grep ora_

                  yes im logging with this user only yaar.

                  Thanks
                  Ahmed
                  • 6. Re: ORA-27086: unable to lock file - already in use
                    409632
                    Hi Ahmed,

                    Already one database is running and controlfile is in use. Did you migrated the 9i database to 10g...?
                    Thanks
                    srinivas
                    • 7. Re: ORA-27086: unable to lock file - already in use
                      508964
                      Hi,

                      yes im migrating form 9i to 10g r2.

                      thanks
                      Ahmed
                      • 8. Re: ORA-27086: unable to lock file - already in use
                        471877
                        What does fuser -c /oracle/QAS/sapdata1/cntrl/cntrlQAS.dbf come back with?This lists what processes are accessing the file and in what mode.

                        Harry
                        • 9. Re: ORA-27086: unable to lock file - already in use
                          409632
                          Ahmed,

                          When you are migrating, you should shutdown your 9i database first and then from 10g Oracle home start the database as "startup upgrade" and then run the catupgrd.sql ( found in the new 10g Oracle_home/rdbms/admin).

                          thanks
                          srinivas.