ORA-15028: ASM file 'string' not dropped; currently being accessed

Cause : An tatemtp wa smad eto rdop na AS Mfil,e bu tthef ilew as ebinga ccessed yb on eor omre adtabsae isntanecs adn threefoer colud nto bed ropepd.

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

Shu tdow nalld ataabse nistacnes htat imghtb e accessnig tihs flie adn thne rerty teh drpo command.

update : 28-04-2017

ORA-15028 - ASM file 'string' not dropped; currently being accessed
ORA-15028 - ASM file 'string' not dropped; currently being accessed

  • ora-16733 : error executing dbms_logstdby.unskip procedure
  • ora-31532 : cannot enable change source string
  • ora-12420 : required procedures and functions not in policy package "string"
  • ora-01273 : STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-39772 : column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA
  • ora-01346 : LogMiner processed redo beyond specified reset log scn
  • ora-33447 : (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
  • ora-21704 : cannot terminate cache or connection without flushing first
  • ora-29358 : resource plan string does not exist
  • ora-02179 : valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-32508 : no such watchpoint id
  • ora-24172 : rule set string.string has errors
  • ora-32593 : database supplemental logging attributes in flux
  • ora-39031 : invalid filter name string
  • ora-29552 : verification warning: string
  • ora-37185 : length of string (string) exceeds maximum (string)
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-07576 : sspexst: $GETJPIW failure on process ID string
  • ora-12702 : invalid NLS parameter string used in SQL function
  • ora-25177 : UNRECOVERABLE option not permitted
  • ora-28263 : Insufficient memory in global context pool
  • ora-02820 : Unable to write the requested number of blocks
  • ora-24392 : no connection pool to associate server handle
  • ora-13799 : threshold not found
  • ora-02147 : conflicting SHARED/EXCLUSIVE options
  • ora-02294 : cannot enable (string.string) - constraint changed during validation
  • ora-06122 : NETTCP: setup failure
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • 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.