Oracle 9i Upgrade to 10g [message #460877] |
Tue, 15 June 2010 06:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
paradoxkhan
Messages: 92 Registered: April 2008 Location: Pakistan
|
Member |
|
|
Hi,
We have production environment running on oracle 9i database. we are planning to upgrade it to 10g. I have reviewed many documents and blogs but still have few concerns. Pls provide me complete steps to upgrade our 9i db to 10g.Also if anyone can clear these points.
1. For 9i to 10g upgrade we need to install oracle 10g with
different oracle_home and then launch dbua and upgrade 9i?
2. will new installed 10g home will read 9i home when dbua
launched?
3. Is there any upgrade installer available to upgrade to 10g like
patchset upgrade installer?
Thanks in advance, Waiting for reply
|
|
|
|
|
Re: Oracle 9i Upgrade to 10g [message #460986 is a reply to message #460899] |
Tue, 15 June 2010 23:46 ![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) |
paradoxkhan
Messages: 92 Registered: April 2008 Location: Pakistan
|
Member |
|
|
Hi,
Due to some unavoidable reasons we couldn't proceed with the up gradation. One more thing i need to clarify, After upgrading 9i to 10g, what to do with installed 10g home(new home)installed for 9i up gradation? either we have to remove it or what?
Thanks,
Yasir Aftab
|
|
|
Re: Oracle 9i Upgrade to 10g [message #460993 is a reply to message #460986] |
Wed, 16 June 2010 00:43 ![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) |
![](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 |
|
|
What you want!
Once you have upgraded the database it is no more useful (unless you want to downgrade some time later or create another 9i database or have some local client programs that requires 9i and assuming you didn't put your database files inside 9i home).
Regards
Michel
[Updated on: Wed, 16 June 2010 00:44] Report message to a moderator
|
|
|
Re: Oracle 9i Upgrade to 10g [message #461018 is a reply to message #460993] |
Wed, 16 June 2010 02:32 ![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) |
paradoxkhan
Messages: 92 Registered: April 2008 Location: Pakistan
|
Member |
|
|
Let me clarify my question in steps.
1. For 9i upgradation i need to install oracle 10g on same machine with different oracle_home;
2. After installing i will have 2 oracle_homes(oracle9i and oracle10g) , Right?
3. Will Upgrade 9i to 10g using 10g(new installed) dbua, Right?
4. After upgradation, we still have 2 oracle_homes, one upgraded 10g(previously 9i) and other new installed 10g.
My question was, now we will only need upgraded 10g home(previously 9i), not the new installed 10g. so we need to delete it after upgradation?
Hope i have clarified....
Regards,
Yasir
|
|
|
|
|