ORA-24396: invalid attribute set in server handle

Cause : Attrbiute COI_ATRT_NONLBOCKIGN_MOD Ehas eben ste on hte sevrer hnadle nad atatchedi n OC_IPOOLm ode.C onnetcion opolin gdoesn ot spuportn on bolckin gmode.

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

Do nto sett he OIC_ATT_RNONBOLCKIN_GMODEa ttriubte o nthe esrverh andl ewhil eattahcing ni OCIP_OOL omde.

update : 27-04-2017

ORA-24396 - invalid attribute set in server handle
ORA-24396 - invalid attribute set in server handle

  • ora-16772 : error switching over between primary and standby databases
  • ora-39162 : Transportable tablespace job require privileges
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-24412 : Cannot reinitialize non-existent pool
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-10863 : Control behavior of buffered background operations
  • ora-12529 : TNS:connect request rejected based on current filtering rules
  • ora-16063 : remote archival is enabled by another instance
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-13055 : Oracle object string does not exist in specified table
  • ora-29966 : The only binding of an operator cannot be dropped
  • ora-02173 : invalid option for DROP TABLESPACE
  • ora-31062 : Cannot delete an unsaved resource
  • ora-00115 : connection refused; dispatcher connection table is full
  • ora-13851 : Tracing for client identifier string is already enabled
  • ora-00353 : log corruption near block string change string time string
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-09760 : osnpui: cannot send break message
  • ora-14400 : inserted partition key does not map to any partition
  • ora-10635 : Invalid segment or tablespace type
  • ora-15054 : disk "string" does not exist in diskgroup "string"
  • ora-32031 : illegal reference of a query name in WITH clause
  • ora-15056 : additional error message
  • ora-35078 : (QFHEAD05) An EIF extension file header for string is not in the correct format.
  • ora-02807 : Allocation of memory for I/O vectors failed.
  • ora-31697 : aborting operation at process order number string
  • ora-15103 : conflicting or duplicate REPAIR options
  • ora-16018 : cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
  • 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.