Home » RDBMS Server » Server Administration » database upgrade (11.2.0.2)
database upgrade [message #634582] Wed, 11 March 2015 11:32 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
I was in the process of upgrading database from 11.2.0.2 to 11.2.0.4.
I ran catupgrade.sql from the 11.2.0.2 home instead of 11.2.0.4 by mistake.
I have following questions:-
How could i make sure that that i did not mess up the database by doing so?
Could you tell me what steps could i take now to prevent any messy situation with database?

Thanks,

Varun

[Updated on: Wed, 11 March 2015 11:35]

Report message to a moderator

Re: database upgrade [message #634584 is a reply to message #634582] Wed, 11 March 2015 11:37 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to query dba_registry to see that state of the various components.
Re: database upgrade [message #634585 is a reply to message #634582] Wed, 11 March 2015 11:39 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Do you have a backup?

If not, I'd get in touch with support tbh.
Re: database upgrade [message #634586 is a reply to message #634584] Wed, 11 March 2015 11:45 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi John,
when I query dba_registry,i get the following results:-

From the results,it seems that everything looks fine.

Could you give your advise?

COMP_NAME STATUS
------------------------------ ------------------------------
Spatial VALID
Oracle Multimedia VALID
Oracle XML Database VALID
Oracle Text VALID
Oracle Expression Filter VALID
Oracle Rules Manager VALID
Oracle Workspace Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and T VALID
ypes


COMP_NAME STATUS
------------------------------ ------------------------------
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Real Application Cluste VALID
rs


Thanks,

Varun
Re: database upgrade [message #634587 is a reply to message #634586] Wed, 11 March 2015 11:46 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Please enclose your copy/paste within bbcode [code] tags in future.

You might want to check the VERSION column.

[Updated on: Wed, 11 March 2015 11:46]

Report message to a moderator

Re: database upgrade [message #634588 is a reply to message #634586] Wed, 11 March 2015 11:50 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
It's also running the following:
SQL> SELECT owner, count(*)
     FROM dba_objects
     WHERE status != 'VALID'
     GROUP BY owner;

As long as everything owned by SYS is valid you should be OK.
Re: database upgrade [message #634589 is a reply to message #634587] Wed, 11 March 2015 11:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what is the difference in the content of the two catupgrade.sql files?
Re: database upgrade [message #634590 is a reply to message #634588] Wed, 11 March 2015 11:58 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
John,

There are 2474 owned by sys that are invalid when I run the query sent by you.

But I haven't run the utlrp script yet.

Shall I run the utlrp script and then run the the query again?

The version is still 11.2.0.2



Thanks,

Varun
Re: database upgrade [message #634591 is a reply to message #634590] Wed, 11 March 2015 12:01 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Quote:
Shall I run the utlrp script and then run the the query again?

Yes.
Previous Topic: DBCA not found!
Next Topic: 10g to 11g migration
Goto Forum:
  


Current Time: Thu Mar 28 09:31:52 CDT 2024