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

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

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


My steps:

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

2. Upgrade 10.2.0.1 EE software to 10.2.0.4 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;

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

5 rows selected.

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

 COUNT(*)
----------
        0

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.

Thanks!