Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Not Open

879380Aug 2 2011 — edited Aug 2 2011

Hi ,

I am using oracle 11g while working i tryed to connect i got error

ERROR at line 1:
ORA-01109: database not open

i searched in the net and done the following commands , but also my problem didnt got solved

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 805306368 bytes
Fixed Size 1289996 bytes
Variable Size 213909748 bytes
Database Buffers 587202560 bytes
Redo Buffers 2904064 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'F:\ORADATA\XE\SYSTEM.DBF'
ORA-01207: file is more recent than control file - old control file

I am new to the oracle , kindly help me

Thanks
parthiban kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2011

Added on Aug 2 2011

#11g, #dba, #general-database-discussions

5 comments

2,357 views