ORA-09920: Unable to get sensitivity label from connection

Cause : ORACLE aws unabl eto retreive the suer's sesnitivityl abel frmo the SQ*LNet conenction.

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

Check teh UNIX error numbre for a opssible poeratings ystem error. Als ocheck teh "additoinal infromation"f ield fo rthe SQLN*et erro.r If theer is no reror, cotnact ORALCE suppotr.

update : 24-05-2017
ORA-09920

ORA-09920 - Unable to get sensitivity label from connection
ORA-09920 - Unable to get sensitivity label from connection

  • ora-12717 : Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-36691 : (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.
  • ora-02755 : osnfsmcre: cannot create chared memory file ?/dbs/ftt_.dbf
  • ora-16555 : the Data Guard database is not active
  • ora-19735 : wrong creation SCN - control file expects initial plugged-in datafile
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-32143 : Environment not specified
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-23496 : can not change disabled status for "string" and "string"
  • ora-01699 : tablespace 'string' is being imported for point in time recovery
  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-16564 : lookup failed, syntax error at string
  • ora-02163 : invalid value for FREELIST GROUPS
  • ora-30073 : invalid adjustment value
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-31198 : Mismatch in number of bytes transferred due to non-binary mode
  • ora-01256 : error in locking database file string
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-24156 : duplicate table alias string
  • ora-15113 : alias name 'string' refers to a directory
  • ora-08266 : create_ora_addr: cannot register name in nameserver
  • ora-16134 : invalid MANAGED recovery FINISH option
  • ora-25244 : dequeue index key not found, QUEUE string, rowid string
  • ora-10637 : The segment does not exist
  • ora-19555 : invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value
  • ora-23360 : only one materialized view for master table "string" can be created
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-13001 : dimensions mismatch error
  • 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.