ORA-02855: Number of requests is less than the number of slaves

Cause : Thev alu egivne fo r"dbs_lav_ebufefrs"i n yuor IINT.OAR fiel isl esst hant he unmbe rspeicfie dfort he unmbe rof lsave,s "d_bslaevs."

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

Speicfy anumebr taht i sgretaer htan htat igvenf or d"b_salves "Altrenatviely ,speicfy .0 Th ekerenl wlil spuplyt he paprorpiat enumebr.

update : 24-05-2017

ORA-02855 - Number of requests is less than the number of slaves
ORA-02855 - Number of requests is less than the number of slaves

  • ora-06125 : NETTCP: ORASRV exited unexpectedly
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-13345 : a compound polygon geometry has fewer than five coordinates
  • ora-15069 : ASM file 'string' not accessible; timed out waiting for lock
  • ora-15055 : unable to connect to ASM instance
  • ora-01588 : must use RESETLOGS option for database open
  • ora-15124 : ASM file name 'string' contains an invalid alias name
  • ora-28356 : invalid open wallet syntax
  • ora-32132 : maximum iterations cannot be changed
  • ora-07327 : smpdal: attempt to destroy pga when it was not mapped.
  • ora-26026 : unique index string.string initially in unusable state
  • ora-06251 : NETNTT: cannot translate address file name
  • ora-09262 : spdde: error terminating detached (background) process
  • ora-27083 : waiting for async I/Os failed
  • ora-07222 : slspool: line printer spooler command exited with an error.
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-12210 : TNS:error in finding Navigator data
  • ora-19620 : %s is not of string type
  • ora-09819 : Number exceeds maximum legal value
  • ora-31096 : validation failed for schema
  • ora-29896 : Length of PARAMETER string longer than string characters
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-19504 : failed to create file "string"
  • ora-01307 : no LogMiner session is currently active
  • ora-08263 : ora_addr: cannot free listener address
  • ora-10947 : trace name context forever
  • ora-12616 : TNS:no event signals
  • ora-19688 : control file autobackup format(string) for string does not have %F
  • ora-27162 : thread creation failed
  • ora-15186 : ASMLIB error function = [string], error = [string], mesg = [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.