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 : 29-06-2017
ORA-02855

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-01123 : cannot start online backup; media recovery not enabled
  • ora-03293 : Cluster to be truncated is a HASH CLUSTER
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-13783 : invalid tuning scope
  • ora-26737 : version string already has an export dump file
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-03261 : the tablespace string has only one file
  • ora-32309 : object mview type "string"."string" does not match the master table type
  • ora-00964 : table name not in FROM list
  • ora-00956 : missing or invalid auditing option
  • ora-09825 : Unable to disable allowmacaccess privilege.
  • ora-13005 : recursive HHCODE function error
  • ora-16078 : media recovery disabled
  • ora-03130 : the buffer for the next piece to be fetched is required
  • ora-25353 : branch marked for deletion
  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • ora-02020 : too many database links in use
  • ora-01720 : grant option does not exist for 'string.string'
  • ora-01566 : file specified more than once in ALTER DATABASE
  • ora-14123 : duplicate NOREVERSE clause
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-31625 : Schema string is needed to import this object, but is unaccessible
  • ora-36722 : (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.
  • ora-14036 : partition bound value too large for column
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • ora-12151 : TNS:received bad packet type from network layer
  • ora-30184 : argument type not compatible with a format code
  • ora-27250 : OS system call failure
  • ora-30078 : partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
  • ora-32807 : message system link string already exists
  • 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.