Home » RDBMS Server » Server Administration » ORA-1110 and ORA-1122 when trying startup upgrade (upgrading from 9208 to 10.2.0.3)
ORA-1110 and ORA-1122 when trying startup upgrade [message #294746] Fri, 18 January 2008 20:52 Go to next message
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 .. ?

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294753 is a reply to message #294746] Fri, 18 January 2008 22:49 Go to previous messageGo to next message
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]

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294754 is a reply to message #294753] Fri, 18 January 2008 23:03 Go to previous messageGo to next message
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 ..

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294757 is a reply to message #294746] Fri, 18 January 2008 23:29 Go to previous messageGo to next message
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]

Re: ORA-1110 and ORA-1122 when trying startup upgrade [message #294774 is a reply to message #294757] Sat, 19 January 2008 01:32 Go to previous message
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.
Previous Topic: kill hanged transaction
Next Topic: alter sysdba login
Goto Forum:
  


Current Time: Sat Dec 10 16:34:10 CST 2016

Total time taken to generate the page: 0.08040 seconds