OraFAQ Forum: Server Administration » Error during upgrade

Home » RDBMS Server » Server Administration » Error during upgrade (11gR2, Linux x86_64, ORA-01092: ORACLE instance terminated)

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

Error during upgrade [message #519387]

Thu, 11 August 2011 11:17

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

Hi,

I am upgrading a database from 11.2.0.1 to 11.2.0.2.
After running catupgrd.sql which got executed successfully, i did a mistake of opening the database in old oracle home and did a shutdown abort after that.

Now when i open it in new oracle home it gives me the below error: -

SQL> startup
ORACLE instance started.

Total System Global Area  626327552 bytes
Fixed Size                  2229080 bytes
Variable Size             322964648 bytes
Database Buffers          297795584 bytes
Redo Buffers                3338240 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 8271
Session ID: 96 Serial number: 3

when i do

startup upgrade

it shows that the database has been upgraded.

[oracle@lxx0042:/home/oracle]# sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 11 18:07:39 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area  626327552 bytes
Fixed Size                  2229080 bytes
Variable Size             322964648 bytes
Database Buffers          297795584 bytes
Redo Buffers                3338240 bytes
Database mounted.
Database opened.
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

How should i proceed further, so that i can startup the database normally.

Please let me know..

Report message to a moderator

Re: Error during upgrade [message #519389 is a reply to message #519387]

Thu, 11 August 2011 11:38

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

hi,

i just re run the catupgrd.sql script.
it worked

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 11 18:33:45 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  626327552 bytes
Fixed Size                  2229080 bytes
Variable Size             331353256 bytes
Database Buffers          289406976 bytes
Redo Buffers                3338240 bytes
Database mounted.
Database opened.
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Thank You

Report message to a moderator

Re: Error during upgrade [message #519465 is a reply to message #519389]

Fri, 12 August 2011 06:48

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Great to know this.

Pls make sure your following the readme.html doc

Report message to a moderator

Previous Topic:	Invalidation of dependencies
Next Topic:	non standard block size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:08:50 CDT 2024