Upgrade from SE to EE (Oracle 10g)

[Vipassana]

Can anyone here please tell me how complicated/easy it is to upgrade from Oracle 10g database SE to EE. What are the implications with regards to options, if I want to purchase that at a later point in time? By basic question is, will there be system downtime on any such detail during the process of upgrade?

Thanks in advance.

[yxez]

Im curious about it too ...

But less me guess....since they are of the same version, I think
its not complicated. You just have to extract/install the software
from EE cd which are not available on SE cd.

[TimHall]

It's pretty simple according to this note (Metalink Note:117048.1)

In brief you need to:

1. Backup the database
2. De-install the SE software
3. Install the EE software (optionally on Unix in a new ORACLE_HOME)
4. If you have an existing database, point your ORACLE_SID to this pre-existing database
5. Startup the database
6. Run the "catalog.sql" and "catproc.sql" scripts, as usual.

Cheers

Tim...