Home » RDBMS Server » Server Administration » upgrade from 11.1.0.7 to 11.2.0.3 taking long time (oracle version 11.2.0.3; AIX 6.1)
upgrade from 11.1.0.7 to 11.2.0.3 taking long time [message #584670] Thu, 16 May 2013 12:49 Go to next message
cakeday
Messages: 31
Registered: May 2010
Member
i am upgrade oracle database from version 11.1.0.7 to 11.2.0.3;

the following step is taking a long time.
It has been at this step for about 20+ minutes now. Any idea's why and what i can do to improve this in the prod environment ?

= = =


I have ran all the prereqs. gathered stats and all.
The size of the dataabse is about 400 GB, single intance.

SQL> begin
2 if initjvmaux.registrystatus = 'UPGRADING' and
3 initjvmaux.startstep('FIX_DEPENDENCY_TIMESTAMPS') then
4 initjvmaux.rollbacksetup;
5 commit;
6 initjvmaux.rollbackset;
7 execute immediate 'update dependency$ set p_timestamp=(select stime from obj$ where obj#=p_obj#) where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and (select type# from obj$ where obj#=p_obj#)=29 and (select owner# from obj$ where obj#=p_obj#)=0';
8 commit;
9 initjvmaux.rollbackcleanup;
10 initjvmaux.endstep;
11 end if;
12 end;
13 /

Thank You bunches!

[Updated on: Fri, 17 May 2013 10:12] by Moderator

Report message to a moderator

Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584675 is a reply to message #584670] Thu, 16 May 2013 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
20 minutes are not so long for some steps; some require more; it depends on how many things it has to do.

Regards
Michel
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584676 is a reply to message #584675] Thu, 16 May 2013 13:13 Go to previous messageGo to next message
cakeday
Messages: 31
Registered: May 2010
Member
Thank you Michel for that helps. Patience was never my virtue! : )

45 minutes later, its still hung at that step.
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584680 is a reply to message #584676] Thu, 16 May 2013 13:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you open another SYS session?

Regards
Michel
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584682 is a reply to message #584676] Thu, 16 May 2013 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You can't push a string.

We can't make your system go faster.
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584696 is a reply to message #584682] Thu, 16 May 2013 17:55 Go to previous messageGo to next message
cakeday
Messages: 31
Registered: May 2010
Member
You are Right BlackSwan.. i should have practiced patience. the upgrade finished in 2:10 minutes.. which is acceptable.
Thank You for your help.
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584697 is a reply to message #584696] Thu, 16 May 2013 17:56 Go to previous messageGo to next message
cakeday
Messages: 31
Registered: May 2010
Member
Michel: For future reference, why did u want me to log on to the db as sys using a different session? what could i have checked that would give me a bit more overview on the upgrade process ?
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584705 is a reply to message #584697] Fri, 17 May 2013 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To see what the first session is currently doing.

Regards
Michel
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584762 is a reply to message #584705] Fri, 17 May 2013 08:04 Go to previous messageGo to next message
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
Member
cakeday, could you please correct the title of your post (11.2.0.7) to 11.1.0.7? This would help future searches. Thanks.
Re: upgrade from 11.2.0.7 to 11.2.0.3 taking long time [message #584774 is a reply to message #584762] Fri, 17 May 2013 10:12 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is done, thanks for the remark.

Regards
Michel
Previous Topic: Alternative to dbms_system.ksdwrt
Next Topic: Migrate from 8.1.7.0.0 to 9.2
Goto Forum:
  


Current Time: Thu Mar 28 07:00:39 CDT 2024