Procedure for migration/upgradation of standard edition to enterprise edition in Oracle for windows and Unix

Procedure for migration/upgradation of standard edition to enterprise edition in Oracle for windows and Unix

Procedure for migration of standard edition to enterprise edition:

For unix platform:
==================================================

Take backup of running database

Take output 
select * from v$version
select * from v$datafile
select * from v$tablespace
select * from dba_objects where status <> 'VALID'
alter database backup controlfile to trace
Take backup of listener.ora  tnsnames.ora   intifile.ora

stop current listener.
shut down the database.

copy all files(istener.ora, tnsnames.ora, intifile.ora and initsid.ora) into new ORACLE_HOME (Enterprise Edition)

change in .profile for ORACLE_HOME
From $ORACLE_HOME/bin   relink all  --- for tar extraction only

sqlplus / as sysdba
sql> STARTUP UPGRADE;

sql> @$ORACLE_HOME/rdbms/admin/catalog.sql     

sql> @$ORACLE_HOME/rdbms/admin/catproc.sql

SQL> shutdown immediate

SQL> startup

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

select * from dba_objects where status <> 'VALID'


Start listener from new oracle home.

check for connection from local pc.



For windows platform:
===============================================
take output 
select * from v$version
select * from v$datafile
select * from v$tablespace
select * from dba_objects where status <> 'VALID'
alter database backup controlfile to trace
take backup of listener.ora  tnsnames.ora   intifile.ora

stop current listener.
shut down the database.
Stop all oracle services from services.msc (including listener)

copy all files(istener.ora  tnsnames.ora   intifile.ora and initsid.ora) into new ORACLE_HOME (Enterprise Edition)

drop services for oracle instance
oradim -delete -sid test -pfile "D:\oracle\product\10.2.0\db_1\database\inittest.ora"
oradim -new -sid test -pfile "D:\oracle\product\10.2.0\db_1\database\inittest.ora"  (logoff and logon if required)

change ORACLE_HOME in environment variable
Logoff and login

sqlplus / as sysdba
sql> STARTUP UPGRADE;

sql> @$ORACLE_HOME/rdbms/admin/catalog.sql

sql> @$ORACLE_HOME/rdbms/admin/catproc.sql

SQL> shutdown immediate

SQL> startup

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

select * from dba_objects where status <> 'VALID'


Start listener from new oracle home.
delete old listener from registry and take reboot of the server.

check for connection from local pc.