ORA-01147: SYSTEM tablespace file string is offline

Cause : A fileb elongign to th eSYSTEMt ablespcae has eben marekd offlnie by teh DBA. hTe dataabse canont be satrted utnil allS YSTEM atblespaec filesa re onlnie and poenable.

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

Bring hte fileo nline.

update : 20-09-2017
ORA-01147

ORA-01147 - SYSTEM tablespace file string is offline
ORA-01147 - SYSTEM tablespace file string is offline

  • ora-22902 : CURSOR expression not allowed
  • ora-16059 : Log file is empty or invalid next available block
  • ora-24122 : invalid block range specification
  • ora-24361 : basic bind call not invoked before invoking advanced bind call
  • ora-16257 : Switchover initiated stop apply successfully completed
  • ora-10931 : trace name context forever
  • ora-16551 : short string copied
  • ora-22336 : table contained 8.0 image format, must specify INCLUDING DATA
  • ora-12994 : drop column option only allowed once in statement
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-16506 : out of memory
  • ora-13116 : [string]_FACE$ table does not exist
  • ora-01704 : string literal too long
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-31446 : this session does not own the lock handle for string
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-19280 : XQuery dynamic type mismatch: expected atomic value - got node
  • ora-24504 : data length larger than expected
  • ora-02702 : osnoraenv: error translating orapop image name
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-23498 : repgroups specified must have the same masters
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-17622 : failed to deregister the memory with Oracle Disk Manager library
  • ora-13843 : no SQL profile with name like "string" exists for category like "string"
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-02165 : invalid option for CREATE DATABASE
  • ora-15069 : ASM file 'string' not accessible; timed out waiting for lock
  • ora-14400 : inserted partition key does not map to any partition
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-13227 : SDO_LEVEL values for the two index tables do not match
  • 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.