| Upgrade Oracle 8.1.6 to 9i [message #146588] |
Fri, 11 November 2005 05:43  |
ankurgodambe
Messages: 45
Registered: March 2005
|
Member |
|
|
Hi,
I have to upgrade our production DB server version 8.1.6.0 to 9.2.0.x release. The upgrade path can be exp/imp or through dbua/manual scripts. But 8.1.6 has to be first upgraded to 8.1.7 and then to 9i. Can anyone tell me where can i find Oracle software for 8.1.7 for sun sparc-64 bit. I searched oracle site but could not find it.
I cannot do exp/imp since the database is huge and the required downtime is unacceptable.
Thanks
|
|
|
|
| Re: Upgrade Oracle 8.1.6 to 9i [message #146595 is a reply to message #146588] |
Fri, 11 November 2005 06:15  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I want to let you know that you can upgarde oracle 8.1.6 to oracle 8.1.7 by applying patches to it. & than install oracle 9i and use database upgrade assistance tool of 9i to upgrade your 8.1.7 database..
I dont know how u will upgrade but.
First of all make a clone database of your oracle 8.1.6 than try to upgrade it to oracle 8.1.7 by applying patches, after that install oracle 9i software on the same server(i.e. machine) on which you have clone database (i.e. upgraded oracle 8.1.7.) than use dbua (i.e. database upgrade assistance) utility of 9i to upgrade oralce 8.1.7 & if things work on your clone database than do same with your original oracle 8.1.6 database.
Note:- [1] original database contain live data so first try to work on your clone db then to your original
[2] Dont forget to take full backup of your database before you start to do upgradation of database.
Regards
Always Friend Sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
