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 : 20-08-2017

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

  • ora-32164 : Method called on Invalid Connection type
  • ora-16733 : error executing dbms_logstdby.unskip procedure
  • ora-02793 : Close of asynchronous I/O failed.
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-24950 : unregister failed, registeration not found
  • ora-24807 : LOB form mismatch
  • ora-23388 : replication parallel push watermark error
  • ora-13851 : Tracing for client identifier string is already enabled
  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-12068 : updatable mview log for mview "string"."string" does not exist
  • ora-09770 : pws_look_up: translation failure.
  • ora-33005 : (XSAGDIMBREAK) Invalid breakout for dimension workspace object.
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-36698 : (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.
  • ora-13854 : Tracing for service(module/action) string on instance string is not enabled
  • ora-02156 : invalid TEMPORARY tablespace identifier
  • ora-02842 : Client unable to fork a server
  • ora-01658 : unable to create INITIAL extent for segment in tablespace string
  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-36884 : (XSSRF03) The value of the first parameter of the AW single row function is incorrect.
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-12317 : logon to database (link name string) denied
  • ora-02357 : no valid dump files
  • ora-36718 : (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
  • ora-15076 : Emulating I/O errors on the OSM disk
  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-01742 : comment not terminated properly
  • ora-03202 : the scan limit specification is invalid
  • 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.