ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated

Cause : When eexcutinga queryo n a gv $fixed ivew, on eor mor einstanecs failde to alolcate as lave t oproces squery.

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

Check rtace ouptut fori nstancse on whcih slavse faile dto statr. GV$ uqery ca nonly porceed i fslavesc an be lalocate don alli nstancse.

update : 28-04-2017

ORA-12850 - Could not allocate slaves on all specified instances: string needed, string allocated
ORA-12850 - Could not allocate slaves on all specified instances: string needed, string allocated

  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-30476 : PLAN_TABLE does not exist in the user's schema
  • ora-12441 : policy string already exists
  • ora-24144 : rules engine internal error, arguments: [string], [string]
  • ora-36814 : (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).
  • ora-16589 : Data Guard Connection process detected a network transfer error
  • ora-27475 : "string.string" must be a string
  • ora-38463 : invalid XML Tag list
  • ora-31534 : Change Data Capture string publisher string is missing DBA role
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-19599 : block number string is corrupt in string string
  • ora-29892 : indextypes with array DML do not support the given data type
  • ora-12828 : Can't start parallel transaction at a remote site
  • ora-16214 : apply stalled for apply delay
  • ora-13068 : wrong table or column name in SDO_TOPO_GEOMETRY constructor
  • ora-16661 : the standby database needs to be reinstated
  • ora-16148 : user requested expiration of managed recovery operation
  • ora-04089 : cannot create triggers on objects owned by SYS
  • ora-16082 : logical standby is not initialized correctly
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-39036 : invalid metadata filter name string
  • ora-07710 : sksaprs: file name buffer too small
  • ora-21500 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-25105 : RECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-01950 : no privileges on tablespace 'string'
  • ora-30376 : prevent sharing of a parsed query of an explain rewrite session
  • ora-29290 : invalid offset specified for seek
  • ora-31201 : DBMS_LDAP: generic error: string
  • 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.