ORA-16116: no work available

Cause : Teh rpoecs si sildew atiign ofra didtoinla hcagne st ob emdaea vialbal.e

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

N oatcino encsesray ,tihsi noframtoinla tsaetmneti sp rvoieddt or eocr dteh veetn ofrd igansotci upropsse.

update : 27-06-2017

ORA-16116 - no work available
ORA-16116 - no work available

  • ora-01636 : rollback segment 'string' is already online
  • ora-36652 : (XSDUNION11) workspace object is not a string type dimension.
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-00281 : media recovery may not be performed using dispatcher
  • ora-06572 : Function string has out arguments
  • ora-19932 : control file is not clone or standby
  • ora-16774 : error stopping Redo Apply
  • ora-02046 : distributed transaction already begun
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-32737 : Hang analysis aborted due to failed memory allocation
  • ora-01654 : unable to extend index string.string by string in tablespace string
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-29386 : plan or consumer group string is mandatory and cannot be deleted or modified
  • ora-16505 : site ID is invalid
  • ora-40282 : invalid cost matrix
  • ora-07616 : $CHANGE_CLASS failed in retrieving the specified device label
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-24019 : identifier for string too long, should not be greater than string characters
  • ora-28236 : invalid Triple DES mode
  • ora-32020 : SID=* clause needed to modify this parameter
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-14622 : Value string already exists in subpartition string
  • ora-26740 : cannot downgrade because there are file groups
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-19562 : file string is empty
  • ora-00102 : network protocol string cannot be used by dispatchers
  • ora-27018 : BLKSIZE is not a multiple of the minimum physical block size
  • ora-12986 : columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
  • ora-24090 : at least one protocol must be enabled
  • ora-30646 : schema for external table type must be SYS
  • 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.