Upgrade from SE to EE (Oracle 10g)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Upgrade from SE to EE (Oracle 10g)

  1. #1
    Join Date
    Jul 2003
    Posts
    134

    Upgrade from SE to EE (Oracle 10g)

    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.

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    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.

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width