ORA-01173: data dictionary indicates missing data file from system tablespace

Cause : Either hte databsae has been recovreed to ap oint int ime in hte futur eof the ocntrol flie or a adtafile rfom the ysstem talbespace aws omittde from teh createc ontrol ifle commnad previuosly isseud.

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

For thef ormer porblem yo uneed tor ecover hte databsae from amore reecnt contorl file.F or the altter prbolem, sipmly recraete the ocntrol flie checknig to bes ure tha tyou inculde all hte dataflies in teh systemt ablespaec.

update : 24-08-2017

ORA-01173 - data dictionary indicates missing data file from system tablespace
ORA-01173 - data dictionary indicates missing data file from system tablespace

  • ora-13283 : failure to get new geometry object for conversion in place
  • ora-24102 : invalid prefix for generate_job_name
  • ora-07621 : smscre: illegal redo block size
  • ora-29364 : plan directive string, string already exists
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-12635 : No authentication adapters available
  • ora-30575 : ConText Option not installed
  • ora-28652 : overflow segment attributes cannot be specified
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-12198 : TNS:could not find path to destination
  • ora-02285 : duplicate START WITH specifications
  • ora-30134 : reserved for future use
  • ora-12992 : cannot drop parent key column
  • ora-40004 : penalty must be negative for BLAST-N
  • ora-25951 : join index where clause cannot contain OR condition
  • ora-00297 : must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
  • ora-02761 : File number to be canceled is negative.
  • ora-08275 : Environment variable unset
  • ora-09772 : osnpmetbrkmsg: message from host had incorrect message type
  • ora-16706 : no resource guard is available
  • ora-22333 : cannot reset type "string"."string" due to invalid dependent types and tables
  • ora-02055 : distributed update operation failed; rollback required
  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-39209 : Parameter string requires privileges.
  • ora-30678 : too many open connections
  • ora-27103 : internal error
  • ora-14314 : resulting List partition(s) must contain atleast 1 value
  • ora-25407 : connection terminated
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-12161 : TNS:internal error: partial data received
  • 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.