ORA-31659: status message was invalid type - detaching job

Cause : Message from the master process on the status queue had an invalid message type, indicating a failure in the protocol.

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

Reattach and retry the operation. Contact Oracle Customer Support if the problem persists.

update : 20-08-2017
ORA-31659

ORA-31659 - status message was invalid type - detaching job
ORA-31659 - status message was invalid type - detaching job

  • ora-08321 : scnmin: NOT IMPLEMENTED YET
  • ora-19558 : error de-allocating device
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-00023 : session references process private memory; cannot detach session
  • ora-13618 : The specified value is not a valid value for procedure argument string.
  • ora-32611 : incorrect use of MODEL CV operator
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-23329 : successful user-provided ddl but no materialized view "string"."string"
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-27204 : skgfpqr: sbtpcqueryrestore returned error
  • ora-02700 : osnoraenv: error translating ORACLE_SID
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-22610 : error while adding a scalar to the image handle
  • ora-31018 : Error deleting XML document
  • ora-06778 : TLI Driver: error sending ccode
  • ora-12653 : Authentication control function failed
  • ora-32580 : both SYS and SYSTEM passwords must be provided
  • ora-28137 : Invalid FGA audit Handler
  • ora-00321 : log string of thread string, cannot update log file header
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-16018 : cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
  • ora-31491 : could not add logfile to LogMiner session
  • ora-06135 : NETTCP: connection rejected; server is stopping
  • ora-16218 : This database is already preparing to switch over.
  • ora-39138 : Insufficient privileges to load data not in your schema
  • ora-17505 : ksfdrsz:string Failed to resize file to size string blocks
  • ora-15109 : conflicting protection attributes specified
  • ora-22621 : error transfering an object from the agent
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • 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.