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 : 27-06-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-12034 : materialized view log on "string"."string" younger than last refresh
  • ora-19036 : Invalid query result set in newContextFromHierarchy()
  • ora-22854 : invalid option for LOB storage index
  • ora-31062 : Cannot delete an unsaved resource
  • ora-30645 : reject limit out of range
  • ora-00401 : the value for parameter string is not supported by this release
  • ora-02345 : cannot create a view with column based on CURSOR operator
  • ora-25456 : rule set was modified or evaluation terminated for iterator: string
  • ora-01182 : cannot create database file string - file is in use or recovery
  • ora-07304 : ksmcsg: illegal redo buffer size.
  • ora-01336 : specified dictionary file cannot be opened
  • ora-01924 : role 'string' not granted or does not exist
  • ora-16722 : unable to set LOG_ARCHIVE_DEST_STATE_n initialization parameters
  • ora-31491 : could not add logfile to LogMiner session
  • ora-12600 : TNS: string open failed
  • ora-12574 : TNS:redirection denied
  • ora-19015 : Invalid XML tag identifier (string)
  • ora-30381 : REWRITE_TABLE is not compatible with Oracle version
  • ora-10973 : backout evet for 2619509
  • ora-15072 : command requires at least string failure groups, discovered only string
  • ora-14504 : syntax not supported for analyze
  • ora-31661 : there are no metadata transform values of type VARCHAR2
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-12341 : maximum number of open mounts exceeded
  • ora-19724 : snapshot too old: snapshot time is before file string plug-in time
  • ora-28358 : improper set key syntax
  • ora-07629 : smpall: $EXPREG failure
  • ora-13802 : failed to purge SQL Tuning Base entry from sql$
  • ora-31085 : schema "string" already registered
  • ora-07551 : sftcls: $CLOSE failure
  • 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.