Erman Arslan's Oracle Forum › EBS 12.2

Charecter Set - upgrading 11gr2 database to 19c

Classic

List

Threaded

2 messages Options

satish

Charecter Set - upgrading 11gr2 database to 19c

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

ErmanArslansOracleBlog

Re: Charecter Set - upgrading 11gr2 database to 19c

Administrator

The statement is already clear -> "choose the Character Set and National Character Set to be the same as in the source database." . There is no additional condition or restriction about that either. So I don't see any problem about that.