Re: What happens to DB when Oracle Server is upgraded from win'98 to 2000

Sangeetha wrote:
> Dear All,
> Can anyone tell me whether Oracle has to be installed again, if the OS
> of the server is changed from Windows'98 to 2000.What actually happens to
> the database.
>
>

AFAIK, the database is fine during this kind of upgrade. However, the software (and therefore instance) is radically different and and the '98 stuff will not work properly for long (if at all). So YES, you need to install a new copy of the database software!

I am assuming you used a certified version of the Oracle RDBMS for Windows98 (the last certified one was 9.0.1). Hopefully you are very comfortable with the conceptual difference between 'Database' and '[database] Instance'.

You may have noted the install and README documents discuss the significant variations between the '98 version and the other cousins.

Standard tactics indicate a) backup (in this case I also recommend a full export here as well); b) install new s/w into new ORACLE_HOME; c) use the upgrade facility in the new ORACLE_HOME to manage the database upgrade. Read the INSTALL document and README carefully!

HTH
/Hans Received on Mon Mar 08 2004 - 09:19:37 CST