ORA-24436: Invalid statement Handle.

Cause : OCIHandleFree called on a statement that was prepared using OCIstmtPrepare2.

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

Release the statement using OCIStmtRelease.

update : 26-06-2017
ORA-24436

ORA-24436 - Invalid statement Handle.
ORA-24436 - Invalid statement Handle.

  • ora-02261 : such unique or primary key already exists in the table
  • ora-09769 : osnmbr: cannot send break message
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-10944 : trace name context forever
  • ora-00443 : background process "string" did not start
  • ora-31027 : Path name or handle string does not point to a resource
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-30680 : debugger connection handshake failed
  • ora-12200 : TNS:could not allocate memory
  • ora-02421 : missing or invalid schema authorization identifier
  • ora-30504 : system triggers cannot have a FOR EACH ROW clause
  • ora-31009 : Access denied for property string
  • ora-06764 : TLI Driver: error reading disconnect
  • ora-24430 : Null values for sqltext and key were specified.
  • ora-14043 : only one partition may be added
  • ora-30963 : The indexed column is not of XMLType.
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-13215 : window object is out of range
  • ora-22621 : error transfering an object from the agent
  • ora-23616 : Failure in executing block string for script string
  • ora-12730 : invalid equivalence class in regular expression
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-39103 : Timeout before worker process string finished initialization. Worker error:
  • ora-39092 : unable to set SCN metadata for object "string.string" of type string
  • ora-00251 : LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string
  • ora-38957 : Target database not 10.0.0.0 compatible
  • ora-23503 : error occurred during IAS instantiation
  • ora-00269 : specified log file is part of thread string not string
  • ora-16044 : destination string attribute cannot be specified at session level
  • 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.