ORA-16252: Rebuild operation not permitted

Cause : The REBUILD operation is not permitted.

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

Only on a primary database that has failed to complete the LogMiner dictionary build may the REBUILD operation take place. Reissue the ACTIVATE LOGICAL STANDBY DATABASE command if it previously failed to complete.

update : 28-04-2017

ORA-16252 - Rebuild operation not permitted
ORA-16252 - Rebuild operation not permitted

  • ora-32510 : cannot create watchpoint on unreadable memory
  • ora-22281 : cannot perform operation with an updated locator
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-01120 : cannot remove online database file string
  • ora-31501 : change source string is not an AutoLog change source
  • ora-19740 : text is longer than string
  • ora-27128 : unable to determine pagesize
  • ora-14315 : cannot merge a partition with itself
  • ora-10382 : parallel query server interrupt (reset)
  • ora-22975 : cannot create a PRIMARY KEY-based REF to this object view
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-01653 : unable to extend table string.string by string in tablespace string
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-29966 : The only binding of an operator cannot be dropped
  • ora-01158 : database string already mounted
  • ora-13346 : the coordinates defining an arc are collinear
  • ora-16227 : DDL skipped due to missing object
  • ora-26697 : LCR contains extra column 'string'
  • ora-00345 : redo log write error block string count string
  • ora-13011 : value is out of range
  • ora-30075 : TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint
  • ora-06570 : shared pool object does not exist, cannot be pinned
  • ora-01515 : error dropping log group string: no such log
  • ora-16024 : parameter string cannot be parsed
  • ora-02361 : error while attempting to allocate number bytes of memory
  • ora-34019 : (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-28669 : bitmap index can not be created on an IOT with no mapping table
  • ora-27470 : failed to re-enable "string.string" after making requested change
  • ora-01931 : cannot grant string to a role
  • 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.