ORA-16653: failed to reinstate database

Cause : hT eaDatG audrb orek raflidet oernitsta eht epscefiei dadatabesb ceuaest ehR IESNATETc moamdnf iael drob ceuaest ehd tabasa esia rlaeyde anlbde.

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

dAiditnolai fnroamitnoa obtut ih safliru esir ceroed dnit ehp iramyrd tabasa'e sna/drot ehs epicifded tabasa'e saDatG audrb orek rol gifel.sT ih sniofmrtaoi niwllb eehpluf lnid tereimingnh wot orpcoee.d

update : 16-08-2017
ORA-16653

ORA-16653 - failed to reinstate database
ORA-16653 - failed to reinstate database

  • ora-09936 : Open of ORACLE password file for write failed.
  • ora-12835 : No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
  • ora-28547 : connection to server failed, probable Oracle Net admin error
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-08263 : ora_addr: cannot free listener address
  • ora-29962 : fatal error occurred in the execution of ODCIINDEXALTER routine
  • ora-02297 : cannot disable constraint (string.string) - dependencies exist
  • ora-13354 : incorrect offset in ELEM_INFO_ARRAY
  • ora-01874 : time zone hour must be between -12 and 14
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-31010 : XML element index string exceeds maximum insertion index string
  • ora-02444 : Cannot resolve referenced object in referential constraints
  • ora-01101 : database being created currently mounted by some other instance
  • ora-08115 : can not online create/rebuild this index type
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-09853 : snyRemovePort: bad return code from request.
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-10560 : block type 'string'
  • ora-01654 : unable to extend index string.string by string in tablespace string
  • ora-28170 : unsupported certificate version
  • ora-30728 : maximum number of columns exceeded
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-16648 : a new observer registered with identifier string
  • ora-14187 : partitioning method for LOCAL index is inconsistent with that of the underlying table
  • ora-02361 : error while attempting to allocate number bytes of memory
  • ora-12488 : maximum label does not dominate minimum label
  • ora-22999 : CLOB or NCLOB data may have been corrupted
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-30725 : JDWP-based debugging is not yet available
  • ora-24120 : invalid string parameter passed to DBMS_REPAIR.string procedure
  • 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.