ORA-09921: Unable to get information label from connection

Cause : ORACLEw as unalbe to rterieve hte users' inforamtion lbael fro mthe SQ*LNet connection.

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

Check hte UNIXe rror nmuber fo ra possbile opearting ssytem erorr. Als ocheck hte "addtiional niformatoin" fiedl for teh SQL*Nte error .If theer is noe rror, ocntact ROACLE spuport.

update : 23-01-2017
ORA-09921

ORA-09921 - Unable to get information label from connection
ORA-09921 - Unable to get information label from connection

  • ora-06812 : TLI Driver: could not read the ethernet driver's node address
  • ora-16777 : unable to find the destination entry of a standby database in V$ARCHIVE_DEST
  • ora-26754 : cannot specify both one-to-one transformation function string and one-to-many transformation function string
  • ora-24265 : Insufficient privileges for SQL profile operation
  • ora-26683 : invalid value for value_type
  • ora-12021 : materialized view "string"."string" is corrupt
  • ora-25402 : transaction must roll back
  • ora-24361 : basic bind call not invoked before invoking advanced bind call
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-06610 : LU6.2 Driver: Failed during deallocation
  • ora-13362 : disjoint sub-element in a compound polygon
  • ora-22890 : cannot specify name for REF column constraint
  • ora-02038 : define is not allowed for array type
  • ora-01752 : cannot delete from view without exactly one key-preserved table
  • ora-06932 : CMX: error in local name
  • ora-23440 : incorrect public template value
  • ora-31514 : change set string disabled due to capture error
  • ora-27143 : OS system call failure
  • ora-25275 : Test support for buffered queues
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-04941 : required operating system patch needs to be applied
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-00030 : User session ID does not exist.
  • ora-01882 : timezone region string not found
  • ora-36198 : (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified workspace object as a weight.
  • ora-29901 : function underlying operator binding does not exist
  • ora-19038 : Invalid opertions on query context
  • ora-13707 : Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.
  • ora-27158 : process control failure
  • ora-30089 : missing or 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.