Convert " SE+CPU" to " EE+CPU"

Wednesday, July 14, 2010

In this test case I will convert "Oracle SE + CPU" to "Oracle EE + CPU".

I’ve installed "Oracle SE+CPU" on my test machine and created database for test purpose. Database resides on Linux 32bit operating system.

My steps:

1. Install Oracle EE software to different location.
During software installation I will keep my database running and won’t touch SE installation.

2. Upgrade EE software to version and apply CPU.

3. Shutdown database and listener + take cold backup.

4. Copy parameter file (init.ora/spfile.ora) from SE/dbs to EE/dbs.

5. Copy tnsnames.ora, listener.ora and sqlnet.ora from SE/network/admin to EE/network/admin.

6. Change ORACLE_HOME environment variable to point database to new EE home.

7. If necessary change /etc/oratab entries to point new EE home.

8. Startup database and listener.

9. Run the catalog.sql and catproc.sql scripts.

10. Run utlrp.sql to recompile invalid objects.

11. Later you can remove SE installation using OUI (if everything went OK).

Small checks:

SQL> select * from v$version;

Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - Production
CORE      Production
TNS for Linux: Version - Production
NLSRTL Version - Production

5 rows selected.

SQL> select count(*) from dba_objects where status<>'VALID';


1 row selected.

Check Alert.log -> OK.

Maybe some steps are unnecessary or incorrect so if you have any suggestion or correction please leave it in a comment and I will add correction.




  • Damir Vadas (aka Funky)

    What about dba_registry content?

    All is valid?

    Damir Vadas

  • Marko Sutic

    It seems that everything is valid:

    SQL> select comp_name, version, status from dba_registry;

    -------------------------------------------------- -------------------------------------------------- --------------------
    Spatial VALID
    Oracle interMedia VALID
    Oracle Enterprise Manager VALID
    Oracle XML Database VALID
    Oracle Text VALID
    Oracle Expression Filter VALID
    Oracle Rules Manager VALID
    Oracle Workspace Manager VALID
    Oracle Data Mining VALID
    Oracle Database Catalog Views VALID
    Oracle Database Packages and Types VALID
    JServer JAVA Virtual Machine VALID
    Oracle XDK VALID
    Oracle Database Java Packages VALID

    14 rows selected.


  • Damir Vadas (aka Funky)


    When you connect through SQLPlus to that instance, what do you get?

    SQL*Plus: Release - Production on Sri Kol 4 10:02:15 2010

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to:
    Oracle Database 10g Enterprise Edition Release - 64bit Production
    With the Partitioning, Real Application Clusters, OLAP, Data Mining
    and Real Application Testing options


    This is also some prove about version...amateur but good enough.

    However still would not use this in production.
    Damir Vadas

  • Marko Sutic

    I get:

    $ sqlplus "/as sysdba"

    SQL*Plus: Release - Production on Wed Aug 4 12:39:19 2010

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    Connected to:
    Oracle Database 10g Enterprise Edition Release - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options


    This is nice check to find out more information about client version also.

    Thx for comment ;)


  • Post a Comment