Home » RDBMS Server » Server Administration » Database up gradation (10.2.0.4,windows2003 x64)
icon5.gif  Database up gradation [message #636602] Wed, 29 April 2015 00:43 Go to next message
surmaa013
Messages: 20
Registered: April 2015
Location: delhi
Junior Member
I think my upgradation job from db 10.2.0.3 to 10.2.0.4 struck .

As i run
sql>@catupgrd.sql

the job was running successfully , but at

sql>grant execute on aq$_jms_message to public; It looks likes struck.

my DB size is arround 700Gb. what should do now ? should i cancel the job and rerun ,Please advise ?

Report message to a moderator

Re: Database up gradation [message #636603 is a reply to message #636602] Wed, 29 April 2015 00:46 Go to previous message
John Watson
Messages: 8974
Registered: January 2010
Location: Global Village
Senior Member
I would not try to fix this at all. Why not restore, and upgrade to the terminal release, which is 10.2.0.5, instead? THat might not hit the same problem.

Report message to a moderator

Previous Topic: Oracle 11g Install
Next Topic: Default Undo vs Default Temp tablesapces
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 21 12:28:43 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.