Solution that worked for me. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 530288640 bytes Fixed Size 2131120 bytes Variable Size 310381392 bytes Database Buffers Continue reading… ORA-01194: file 1 needs more recovery to be consistent
Tag: Oracle
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
Recently I’m stuck with this error suddenly while writing data to this Oracle XE edition. Of course, it’s kind of frustrating to see this kind of errors in the middle of our tasks without even knowing the origin of these.Continue reading… ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM