10gR1 to 10gR2 (merged) [message #296901] |
Tue, 29 January 2008 07:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adit_me1
Messages: 49 Registered: October 2007 Location: BANGALORE
|
Member |
|
|
Hi,
I've to upgrade a 10gR1 databases to 10gR2. The database is a huge one.
I was wondering if this upgrade would require an import/export of the databases, or if it just requires an upgrade of the RDBMS and is like a patch install??
basically i wanted to know as to what will be the overhead in doing such a thing??
please reply if anyone of you have already faced a similar situation.
Thanks in advance
Aditya
|
|
|
|
Re: 10gR1 to 10gR2 [message #297003 is a reply to message #296905] |
Tue, 29 January 2008 22:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adit_me1
Messages: 49 Registered: October 2007 Location: BANGALORE
|
Member |
|
|
thanks Michel,
actually i read the related posts but din really gain that much info from them.
actually we have the option of upgrading to 10gR2 or 11g and i went throught the post for that as well.. it was very educative..
i just wanted to take as many feedbacks as possible as i am very very new to this field(just 3 months) and that confidence in upgrading a huge database like ours is just not coming. i want to be 100% sure of what to be done and how??
and where can i find upgrade/migration guide?
|
|
|
|
|
Re: 10gR1 to 10gR2 [message #297025 is a reply to message #297021] |
Tue, 29 January 2008 23:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adit_me1
Messages: 49 Registered: October 2007 Location: BANGALORE
|
Member |
|
|
i also wanted to know if upgrading the DB to a newer version may lead to compatibility issues for applications who have written their pl/sql code according to previous versions.
i mean, will upgrading my DB from 10Gr1 to 10Gr2 lead to any backward compatibility issues?
|
|
|
|
|
|
|
|
Re: 10gR1 to 10gR2 [message #300768 is a reply to message #300766] |
Mon, 18 February 2008 01:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adit_me1
Messages: 49 Registered: October 2007 Location: BANGALORE
|
Member |
|
|
ya right.. but what can be the risks involved?
can i expect any major issues?
and is there a order that i should follow? i mean what should be upgraded first - hardware or Oracle?
is it fine if i can test 10gR2 on my current box and later turn to 64 bit box?
what do you suggest?
|
|
|
|
Re: 10gR1 to 10gR2 [message #306413 is a reply to message #296901] |
Fri, 14 March 2008 02:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adit_me1
Messages: 49 Registered: October 2007 Location: BANGALORE
|
Member |
|
|
ok.. so the hardware and linux versions are still the same. No one is touching that for now.
But Now i am in a fix whether to go for oracle versions 10.2.0.1 or 10.2.0.3 ...
can anyone suggest?
|
|
|
|
Re: 10gR1 to 10gR2 [message #306422 is a reply to message #296901] |
Fri, 14 March 2008 02:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adit_me1
Messages: 49 Registered: October 2007 Location: BANGALORE
|
Member |
|
|
suggest as to which version would be better?
as far as i know, the latter has a patch upgraded on the 10gR2 version on it.. actually i am very new to this field so just wanted your opinions....
what is your say?
|
|
|
|
|
|
|
|
|
|
|
Re: 10gR1 to 10gR2 [message #385430 is a reply to message #385418] |
Mon, 09 February 2009 09:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
There is NO patch to upgrade from 10.1 to 10.2, they are 2 different versions.
You have to download 10.2 then migrate your database following the steps detailed in documentation.
Regards
Michel
|
|
|