Charecter Set - upgrading 11gr2 database to 19c

Posted by satish on Apr 13, 2023; 9:22am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Charecter-Set-upgrading-11gr2-database-to-19c-tp11775.html

Dear Erman,

App version R12.1.3->Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (Doc ID 2580629.1)

We are upgrading 11gr2 database to 19c. We are at step 7 Create the CDB.


SQL> SELECT value AS db_charset FROM nls_database_parameters WHERE parameter = '                                                                                        NLS_CHARACTERSET';

 
DB_CHARSET
----------------------------------------
US7ASCII

 
SQL> SELECT value AS db_ncharset FROM nls_database_parameters WHERE parameter =                                                                                         'NLS_NCHAR_CHARACTERSET';


DB_NCHARSET
----------------------------------------
AL16UTF16


Click on the Character Sets tab and choose the Character Set and National Character Set to be the same as in the source database. If the appropriate Character Set does not show up, uncheck the "Show recommended character sets only" box.

We are going to enter the same values while creating database. Will there be any compatible issues with above values?

Thanks,
Satish