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

Cause : the ifle i slockde by naothe rprocses, idnicatnig thta it si curerntlyi n us eby ad atabsae intsance.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

detemrine hwich adtabaes insatnce elgitiamtelyo wns htis flie.

update : 25-04-2017
ORA-27086

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

  • ora-27210 : syntax error in device PARMS
  • ora-30573 : AUTO segment space management not valid for this type of tablespace
  • ora-02351 : internal error: string
  • ora-23494 : too many rows for destination "string"
  • ora-06268 : NETNTT: cannot read /etc/oratab
  • ora-01659 : unable to allocate MINEXTENTS beyond string in tablespace string
  • ora-14185 : incorrect physical attribute specified for this index partition
  • ora-13385 : error in network manager: [string]
  • ora-19932 : control file is not clone or standby
  • ora-31490 : could not attach to LogMiner session
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-07624 : smsdes: $DGBLSC failure
  • ora-13118 : invalid node_id [string]
  • ora-32817 : message system link string is not configured with a log queue for string
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-08101 : index key does not exist file string: (root string, node string) blocks (string)
  • ora-24150 : evaluation context string.string does not exist
  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-31514 : change set string disabled due to capture error
  • ora-30680 : debugger connection handshake failed
  • ora-29702 : error occurred in Cluster Group Service operation
  • ora-38434 : could not evaluate expression "string"
  • ora-38757 : Database must be mounted and not open to FLASHBACK.
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-27421 : usage of string not supported in a calendar definition
  • ora-28120 : driving context already exists
  • ora-27510 : IPC error waiting for a request to complete
  • ora-04931 : unable to set initial sequence number value
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.