Home » RDBMS Server » Server Administration » Upgrade oracle8i to oracle 9i (oracle 8i,windows server 2003)
Upgrade oracle8i to oracle 9i [message #344109] Thu, 28 August 2008 15:40 Go to next message
Messages: 14
Registered: April 2008
Location: Chennai
Junior Member

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.



[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 #344111 is a reply to message #344109] Thu, 28 August 2008 15:44 Go to previous messageGo to next message
Messages: 4766
Registered: February 2005
Location: East Coast USA
Senior Member
You should really be installing 10g or 11g as 9i was desupported as of 31-Jul-2007.
Re: Upgrade oracle8i to oracle 9i [message #344140 is a reply to message #344109] Thu, 28 August 2008 19:35 Go to previous message
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,

Previous Topic: PMON register
Next Topic: Sending email notifications for user defines metrics
Goto Forum:

Current Time: Fri Aug 18 22:52:34 CDT 2017

Total time taken to generate the page: 0.23385 seconds