EM 13c: Migrate_db Fails In Final Phase In Step "Source DB Pre Migration Checks" With Error "Database character set of "<Source DB name>" does not match the database character set of "<Target DB name>".
(Doc ID 2694985.1)
Last updated on AUGUST 25, 2020
Applies to:
Enterprise Manager for Oracle Database - Version 13.3.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) Cloud Control, while performing emcli migrate_db fails in step Source DB Pre Migration Checks" With Error "Database character set of "source" does not match the database character set of "target".
Command:
$ emcli migrate_db -file="/u03/migrate_scripts/tts_final.xml"
Migrate database deployment procedure submitted successfully: ONLINE_DBCONSOLIDATION_USING_TTS 1589720475057
Job Step Log:
Job Steps Log for Job :Source DB Pre Migration Checks
Database Compatibility Check
Validating the compatibility of <Source DB name>and <Target Hostname>.
Compatibility validation of <Source DB name> and <Target Hostname> completed.
ExpressionEvaluationException: Below error message was returned while executing this Computational step.
----------------------------------------------------------
Source DB Prechecks failed
----------------------------------------------------------
ERROR : Database character set of "<Source DB name>" does not match the database character set of "<Target Hostname>". This may cause migration to fail or may result in corruption of data.
------------------------------------------------------------
$ emcli migrate_db -file="/u03/migrate_scripts/tts_final.xml"
Migrate database deployment procedure submitted successfully: ONLINE_DBCONSOLIDATION_USING_TTS 1589720475057
Job Step Log:
Job Steps Log for Job :Source DB Pre Migration Checks
Database Compatibility Check
Validating the compatibility of <Source DB name>and <Target Hostname>.
Compatibility validation of <Source DB name> and <Target Hostname> completed.
ExpressionEvaluationException: Below error message was returned while executing this Computational step.
----------------------------------------------------------
Source DB Prechecks failed
----------------------------------------------------------
ERROR : Database character set of "<Source DB name>" does not match the database character set of "<Target Hostname>". This may cause migration to fail or may result in corruption of data.
------------------------------------------------------------
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |