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 : 26-09-2017

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

  • ora-30354 : Query rewrite not allowed on SYS relations
  • ora-16751 : resource guard encountered errors in switchover to primary database
  • ora-12341 : maximum number of open mounts exceeded
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-24232 : unknown Embedded PL/SQL Gateway attribute string
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-32732 : Parallel Oradebug session is aborted
  • ora-07484 : snlkput: cannot convert(put) lock.
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-29953 : cannot issue DDL on a domain index partition marked as FAILED
  • ora-16640 : CRS warns that multiple instances may still be running
  • ora-26697 : LCR contains extra column 'string'
  • ora-36210 : (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
  • ora-27062 : could not find pending async I/Os
  • ora-14277 : tables in EXCHANGE SUBPARTITION must have the same number of columns
  • ora-27146 : post/wait initialization failed
  • ora-01491 : CASCADE option not valid
  • ora-12636 : Packet send failed
  • ora-26575 : remote database does not support replication parallel propagation
  • ora-02737 : osnpcl: cannot tell orapop to exit
  • ora-06116 : NETTCP: unable to create ORASRV process
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-24365 : error in character conversion
  • ora-16565 : duplicate property, syntax error at "string"
  • ora-09281 : sllfop: error opening file
  • ora-29701 : unable to connect to Cluster Manager
  • ora-00378 : buffer pools cannot be created as specified
  • ora-27031 : mirror resilvering functions not supported
  • 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.