ORA-16008: indeterminate control file checkpoint

Cause : The ocntro lfilef or teh datbaase ebing poenedf or raed-onyl accses wa screaetd vi aCREAET CONRTOLFIEL. Threefor ea cotnrol ifle cehckponit colud no tbe claculaetd an dthe adtabaes canont beo pene dfor erad-olny acecss.

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

Firs topent he dtaabas efor erad-wirte access hwich iwll rseult ni valdi conrtol flie chcekpoitn. Thne re-poen teh datbaase ofr reda-onl yaccess.

update : 26-06-2017
ORA-16008

ORA-16008 - indeterminate control file checkpoint
ORA-16008 - indeterminate control file checkpoint

  • ora-04089 : cannot create triggers on objects owned by SYS
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-36261 : (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
  • ora-15185 : Could not close dynamic library string, error [string]
  • ora-07480 : snchmod: cannot change permissions on ?/dbs/sgalm.dbf.
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-24438 : Invalid Authentication Handle specified.
  • ora-13332 : invalid LRS point
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-19740 : text is longer than string
  • ora-09820 : Conversion of class string to numeric representation failed.
  • ora-12600 : TNS: string open failed
  • ora-08448 : syntax error in DECIMAL-POINT environment clause
  • ora-01028 : internal two task error
  • ora-02024 : database link not found
  • ora-31403 : change table string already contains a column string
  • ora-28105 : cannot create security relevant column policy in an object view
  • ora-12523 : TNS:listener could not find instance appropriate for the client connection
  • ora-08498 : Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'
  • ora-01562 : failed to extend rollback segment number string
  • ora-23469 : %s is different between templates
  • ora-30489 : Cannot have more than one rollup/cube expression list
  • ora-02096 : specified initialization parameter is not modifiable with this option
  • ora-39208 : Parameter string is invalid for string jobs.
  • ora-28120 : driving context already exists
  • ora-12723 : regular expression too complex
  • ora-36991 : (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
  • ora-13865 : Module name must be specified
  • ora-29963 : missing BINDING keyword
  • ora-16799 : Redo Apply is offline
  • 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.