OraFAQ Forum: Server Administration » ORA-1110 and ORA-1122 when trying startup upgrade

Home » RDBMS Server » Server Administration » ORA-1110 and ORA-1122 when trying startup upgrade (upgrading from 9208 to 10.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-1110 and ORA-1122 when trying startup upgrade [message #294746]

Fri, 18 January 2008 20:52

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

hello, when i am trying to do a startup upgrade from 9208 to 10203 it gives me a error after mounting the database .

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/instance_1/data1/system01.dbf'
ORA-01251: Unknown File Header Version read for file number 1

What could be the issue .. ?

Report message to a moderator

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294753 is a reply to message #294746]

Fri, 18 January 2008 22:49

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

Please never try to open the database after issuing an startup upgrade command. The upgrade mode is there just for you to run upgrade scripts in order to upgrade your database. Run appropriate i/s/u script [info/status/upgrade] to carry out desired upgrade task. Please read the upgrade guide for your target platform before you begin. Do not issue any commands in hurry, try to read & understand what you are doing. A certain level of patience & maturity is expected out of you as a dba. Remember you are handling Oracle software which it self is more demanding & complex than modern operating systems. I hope you understand what I mean.

My sincere apologies if you think my language is rude. You are welcome to post back any genuine technical problems if you have any during your upgrade process.

Regards

Manjit Kumar [mkbhati]

Report message to a moderator

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294754 is a reply to message #294753]

Fri, 18 January 2008 23:03

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

looks like i drove you wrong ..i got the error when i ran the startup upgrade itself .. thanks for making me recollect the dba duties once again ..

Report message to a moderator

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294757 is a reply to message #294746]

Fri, 18 January 2008 23:29

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

My sincere apologies.

1.Is your upgrade process successfully completed ?. If so than there is no logic to issue startup upgrade command and there is no reason to get data file header mismatch error.

2. If you issued startup upgrade command with intentions of upgrading than there is no logic in attempting to open the database while it is in upgrade mode.

3. If above two are not the case than have you followed the correct steeps in manual upgrading before issuing the startup upgrade command.
(a) install target version software.
(b) create new instance.
(c) move datafiles/control files/redologs/SPFILE/PFILE to their respective locations in new instance.
(d) log to new instance & issue startup upgrade.
(e) run appropriate upgrade scripts.

4 If non of above three is your case than what what was your case please write in details. I will follow this thread.

Regards

Manjit Kumar [mkbhati]

Report message to a moderator

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294774 is a reply to message #294757]

Sat, 19 January 2008 01:32

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

No issues manjit .. the problem I have is when i gave the startup upgrade it failed with the error i mentioned above.

Report message to a moderator

Previous Topic:	kill hanged transaction
Next Topic:	alter sysdba login

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:46:09 CDT 2024