08 Move OMR - Third Attempt

Overview

This is the third attempt to move the OMR from GRIDCTRL to GORDON.

References

Procedure

Create Directory in EMREPOSP

In the EMREPOS database on GORDON, a new directory is created as follows:

CONNECT / AS SYSDBA ALTER SESSION set container = emreposp; CREATE DIRECTORY local_dp_dir AS '/opt/app/oracle/admin/emreposp/dpdump';

Update IMPDP Parameter

On GORDON, the parameter file for the impdp utility was updated as follows:

cat >move_omr.par <<DONE FULL=Y DUMPFILE=move_omr.dmp DIRECTORY=local_dp_dir TRANSPORT_DATAFILES= '+DATA/EMREPOS/3CB2554A25C20D21E0536B01A8C0F6BF/DATAFILE/mgmt.dbf', '+DATA/EMREPOS/3CB2554A25C20D21E0536B01A8C0F6BF/DATAFILE/mgmt_deepdive.dbf', '+DATA/EMREPOS/3CB2554A25C20D21E0536B01A8C0F6BF/DATAFILE/mgmt_ecm_depot1.dbf', '+DATA/EMREPOS/3CB2554A25C20D21E0536B01A8C0F6BF/DATAFILE/rman_catalog.dbf', '+DATA/EMREPOS/3CB2554A25C20D21E0536B01A8C0F6BF/DATAFILE/users01.dbf' LOGFILE=import_omr.log DONE

Import Tranferred Metadata into EMREPOSP

On GORDON, the impdp utility was invoked as follows:

impdp system@emreposp parfile=move_omr.par

This failed with:

Import: Release 12.1.0.2.0 - Production on Mon Sep 19 16:55:28 2016 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Password: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Source time zone is +00:00 and target time zone is -07:00. import done in AL32UTF8 character set and AL16UTF16 NCHAR character set export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set WARNING: possible data loss in character set conversions Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@emreposp parfile=move_omr.par Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK ORA-39123: Data Pump transportable tablespace job aborted ORA-29345: cannot plug a tablespace into a database using an incompatible character set Job "SYSTEM"."SYS_IMPORT_FULL_01" stopped due to fatal error at Mon Sep 19 16:59:03 2016 elapsed 0 00:02:36

The alert log shows:

Tartget db char set AL32UTF8 is not a superset of WE8MSWIN1252. Failed to plug in a tablespace due to incompatible database character set"AL32UTF8" and transportable set database character set "WE8MSWIN1252"