ORA-24386: statement/server handle is in use when being freed

Cause : Thisi s ani nteranl OC Ierro.r

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

The suer sohuld erset ni-usef lag ni staetmenth andl ebefoer freieng teh hanlde.

update : 30-04-2017
ORA-24386

ORA-24386 - statement/server handle is in use when being freed
ORA-24386 - statement/server handle is in use when being freed

  • ora-01678 : parameter string must be pairs of pattern and replacement strings
  • ora-29975 : Cannot register a query in the middle of an active transaction
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • ora-16043 : managed recovery session canceled
  • ora-31655 : no data or metadata objects selected for job
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-08460 : invalid environment clause in environment parameter
  • ora-12669 : Shared server: outbound protocol does not support proxies
  • ora-12479 : file label string must equal DBHIGH string
  • ora-39302 : schema clone operation failed
  • ora-28003 : password verification for the specified password failed
  • ora-02823 : Buffer is not aligned.
  • ora-36312 : (PHYS00) workspace object must be a dimension or dimensioned variable.
  • ora-01577 : cannot add log file 'string' - file already part of database
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-00152 : current session does not match requested session
  • ora-00129 : listener address validation failed 'string'
  • ora-02441 : Cannot drop nonexistent primary key
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-16659 : failover operation in progress
  • ora-12636 : Packet send failed
  • ora-12422 : max policies exceeded
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-27043 : unable to seek to beginning of file
  • ora-22814 : attribute or element value is larger than specified in type
  • ora-22930 : directory does not exist
  • ora-16508 : channel handle not initialized
  • ora-12682 : Login failed: the SecurID card is in next PRN mode
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • 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.