7/24/2019 Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

http://slidepdf.com/reader/full/migrate-oracle-xe-11202-to-oracle-ee-11204 1/7

Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

 Author: Vinoth Kumar Subramani

Overview:

Source DB: Oracle XE 11.2.0.2

Target DB: Oracle EE 11.2.0.4

Both the DB runs on the same host.

Since my Source DB runs in root user, logon as root user.

select USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,PROFILE from dba_users where

USERNAME in ('ADMUSER','PRIVUSER','PUBUSER','PXRPTUSER','BGJOBUSER');

7/24/2019 Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

http://slidepdf.com/reader/full/migrate-oracle-xe-11202-to-oracle-ee-11204 2/7

 

Create the directory in command prompt and create alias in DB.

Go to SQL prompt.

7/24/2019 Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

http://slidepdf.com/reader/full/migrate-oracle-xe-11202-to-oracle-ee-11204 3/7

 

Take the backup of the source environment as below:

Come out of the SQL prompt and then fire the command:

In the source DB:

expdp system/oracle full=Y directory=VINODB dumpfile=PRIMAVERA_DB.dmplogfile=expPRIMAVERA_DB.log

7/24/2019 Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

http://slidepdf.com/reader/full/migrate-oracle-xe-11202-to-oracle-ee-11204 4/7

 

Bring up the target DB:

7/24/2019 Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

http://slidepdf.com/reader/full/migrate-oracle-xe-11202-to-oracle-ee-11204 5/7

Create the directory in command prompt and create alias in DB.

Hold here. We need to create table space in new DB as such in old one.

In source DB:

select USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from dba_users where USERNAME

in ('ADMUSER','PRIVUSER','PUBUSER','PXRPTUSER','BGJOBUSER');

7/24/2019 Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

http://slidepdf.com/reader/full/migrate-oracle-xe-11202-to-oracle-ee-11204 6/7

and

select tablespace_name,file_name,bytes/1024/1024 MB from dba_data_files where tablespace_name

in ('PMDB_DAT1','PMDB_PX_DAT1');

Now go to the target DB host and create a directory as shown below (I created with my DB name).

And fire the below queries.

create tablespace PMDB_DAT1 datafile '&DATAFILE' size 250M;

/u01/app/oracle/oradata/vino/PMDB_DAT1.DBF

create tablespace PMDB_PX_DAT1 datafile '&DATAFILE' size 250M;

/u01/app/oracle/oradata/vino/PMDB_PX_DAT1.DBF

7/24/2019 Migrate Oracle XE 11.2.0.2 to Oracle EE 11.2.0.4.

http://slidepdf.com/reader/full/migrate-oracle-xe-11202-to-oracle-ee-11204 7/7

 

create tablespace PMDB_NDX1 datafile '&DATAFILE' size 350M;

/u01/app/oracle/oradata/vino/PMDB_NDX1.DBF

create tablespace PMDB_LOB1 datafile '&DATAFILE' size 250M;

/u01/app/oracle/oradata/vino/PMDB_LOB1.DBF

Copy the .dmp file

Import the .dmp file to target system;

impdp \"/ as sysdba\" full=Y directory=VINODB dumpfile=PRIMAVERA_DB.dmp

logfile=impPRIMAVERA_DB.log TABLE_EXISTS_ACTION=REPLACE