OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » database upgrade (11.2.0.2)

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

database upgrade [message #634582]

Wed, 11 March 2015 11:32

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

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

You need to query dba_registry to see that state of the various components.

Report message to a moderator

Re: database upgrade [message #634585 is a reply to message #634582]

Wed, 11 March 2015 11:39

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.

Report message to a moderator

Re: database upgrade [message #634586 is a reply to message #634584]

Wed, 11 March 2015 11:45

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

Report message to a moderator

Re: database upgrade [message #634587 is a reply to message #634586]

Wed, 11 March 2015 11:46

John Watson
Messages: 8976
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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

It's also running the following:

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: database upgrade [message #634589 is a reply to message #634587]

Wed, 11 March 2015 11:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what is the difference in the content of the two catupgrade.sql files?

Report message to a moderator

Re: database upgrade [message #634590 is a reply to message #634588]

Wed, 11 March 2015 11:58

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

Report message to a moderator

Re: database upgrade [message #634591 is a reply to message #634590]

Wed, 11 March 2015 12:01

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

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

Yes.

Report message to a moderator

Previous Topic:	DBCA not found!
Next Topic:	10g to 11g migration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 00:50:12 CDT 2025