Converting US7ASCII to UTF8/AL32UTF8 – for EBS R12 database and application tier
Database and Application Tier Migration
Globalization Guide for Oracle Applications Release 12 (Doc ID 393861.1)
Appendix-A-of-Doc-ID-393861.1– Migrating to Unicode
Migrate Database Character Set – Use DMU
See changing Or Choosing the Database Character Set ( NLS_CHARACTERSET ) (Doc ID 225912.1)
Excerpt from 225912.1:
D) Character set conversion to Unicode (UTF8/AL32UTF8) in Oracle RDBMS 12c. (works with 11gR2 and others as well)
For migration of an existing database to AL32UTF8 (and the deprecated UTF8), there is in Oracle RDBMs 12c a new tool available called the Database Migration Assistant for Unicode (DMU).
The DMU tool is an unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.
DMU’s intuitive user-interface greatly simplifies the migration process and lessens the need for character set migration expertise by guiding the DBA through the entire migration process as well as automating many of the migration tasks.
For more information please see Note 1272374.1 The Database Migration Assistant for Unicode (DMU) Tool .
See: Oracle Database Migration Assistant for Unicode
From Oracle 12c database onwards, DMU will be the only tool available to migrate the NLS_CHARACTERSET:
Erman Arslan Blogspot EBS 122 database characterset migration – with a hint about using a 12.2 template to simplify the appl tier – if he is referring to OVM templates, this is not applicable
Migrating an E-Business Suite Application Tier to a New Character Set 393861.1 appears to describe the process in the document Appendix A
Determine Application Tier Character Set
Issue the OS command:
# locale
from sqlplus run $AD_TOP/sql/adutconf.sql as apps/apps
Determining Database Character Set You Are Currently Using
You can use this SQL command to check the database character set:
select value from nls_database_parameters where parameter=’NLS_CHARACTERSET’;
select * from nls_database_parameters
where parameter like ‘%CHARACTERSET’;
AL32UTF8 UTF8 (Unicode) Database Character Set Implications [ID 788156.1]
******************** the following blog and DOC IDs for related tools may not be applicable when using DMU **************************
From the blog below… which may or may not be necessary depending on the underlying DB version etc – 12c and possibly 11gR2 is different see doc id 225912.1
http://oracle-latest-technology.blogspot.com/2011/02/how-to-convert-character-set-of-oracle.html
Csscan output explained [ID 444701.1]
Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner) [ID 745809.1]