Home » RDBMS Server » Server Administration » Upgrade (9i to 10g)
Upgrade [message #595985] Mon, 16 September 2013 20:41 Go to next message
hexmanju
Messages: 61
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 #595986 is a reply to message #595985] Mon, 16 September 2013 20:47 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
Hmmmm, upgrading from one obsoleted version (V9) to another unsupported version (V10) seems to be an unwise course of action.
Re: Upgrade [message #595987 is a reply to message #595985] Mon, 16 September 2013 21:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>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.?

Always backup the OS filesystem and do a database backup before upgrade.
Re: Upgrade [message #595992 is a reply to message #595986] Tue, 17 September 2013 02:02 Go to previous messageGo to next message
John Watson
Messages: 4677
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 #595994 is a reply to message #595992] Tue, 17 September 2013 02:12 Go to previous messageGo to next message
Littlefoot
Messages: 19688
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
John Watson

Both 9i and 19g are ...

Back to the future ./fa/450/0/
Re: Upgrade [message #596036 is a reply to message #595994] Tue, 17 September 2013 10:51 Go to previous message
hexmanju
Messages: 61
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.
Previous Topic: TNS-01150: The address of the specified listener name is incorrect
Next Topic: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist
Goto Forum:
  


Current Time: Wed Oct 22 03:44:30 CDT 2014

Total time taken to generate the page: 0.08991 seconds