| Upgrade [message #595985] |
Mon, 16 September 2013 20:41  |
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
|
Member |
|
|
We have a 9208 Prod Database running out of 9i binaries in a HP UX Machine.We want to upgrade it to 102030.We tried upgrading it once and we failed .Oracle came back saying we need to apply a binary patch on the 10g Oracle Home as the error we faced is a bug.This is HP UX machine and there are no 10g databases running here.
.Management has asked to do a test run so that upgrade does not fail again.Unfortunately we do not have an identical test env in this case to test the binary patch.
Here is how we planned.Please let us know if its wise to do the below.
1)We make a copy of the existing 9208 Database in the same machine as a new SID i.e Clone to a new SID and make it up and running.
2)We apply the binary patch on the 10203.
3)Attempt the upgrade .If it goes fine we are good.
4)If the upgrade does not go fine and brings up new suprises(Say Oracle come back and says another patch is required),Will we have already done irreversible damage to our 10g binaries ?
Is there a good way to revert back the upgrade ?
Will the inventory be corrupt?
Is there a way to get back to old binaries if the applied patch did not help or if Oracle says to apply new patch.?
Finally will all the above create an issue to the existing 9i Database?
-DBA
|
|
|
|
|
|
|
|
| Re: Upgrade [message #595992 is a reply to message #595986] |
Tue, 17 September 2013 02:02  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I am surprised that Oracle has not asked you to upgrade to the terminal release of 10.2, which was 10.2.0.5 if I remember correctly. Both 9i and 19g are in sustaining support, and I thought that you had to be on the terminal release for that? You may well have issues which need more patches if you go with 10.2.0.3.
However, there is no need to worry about "irreversible damage" to your 10g Oracle Home, you can always rollback a patch.
|
|
|
|
|
|
| Re: Upgrade [message #596036 is a reply to message #595994] |
Tue, 17 September 2013 10:51 |
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
|
Member |
|
|
Thanks All..We will plan to go to 11g..But that very HP UX does not support 11g and the latest binaries we have on that box is 10203.Thats the reason why we want to go to 10203 first.
We eventually plan to take the DB to AIX and upgrade to 11g.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
