| Upgrade oracle8i to oracle 9i [message #344109] |
Thu, 28 August 2008 15:40  |
|
|
Hi friends,
In one system has Installed Oracle 8i in Windows server 2003 OS. Now i need to install oracle 9i in same Os without uninstal oraacle 8i. Is there any way to do it?
Please advise me.
Thanks
Ramya
[mod-edit] removed font and color.
[Updated on: Thu, 28 August 2008 15:42] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Upgrade oracle8i to oracle 9i [message #344140 is a reply to message #344109] |
Thu, 28 August 2008 19:35  |
naveenmelbourne
Messages: 15
Registered: August 2007
|
Junior Member |
|
|
Hi Friend,
I have done the same task migrating 8i to 9i in solaris OS.Its very simple. Things to do.
0. Take the backup (compulsory)
1. Install the new version binaries in the host with different ORACLE_HOME.
2.Add an entry in the oratab file.(UNIX OS).
3.Make sure you have enough space as the control files and system data files will grow.(SYSTEM datafile atleast 160MB free).
4.Make sure your previous database is up and running.
5. comment out prevoius oracle_home in oratab.
6. go the new ORACLE_HOME bin file and run the DBUA.
7. select the database you want to upgrade.
8. After finish. just change the pfile parameter back to same as previous version.(Some parameter will get changed in pfile by DBUA).
All done....... your database is migrated to new version.
Thank you,
Naveen
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
