Solution : https://service.sap.com/sap/support/notes/102402 (SAP Service marketplace login required)
Summary :
When upgrading Oracle databases in SAP systems from release 8i onwards, it's often necessary to change the character set from US7ASCII to WE8DEC to support the enhanced character requirements of newer releases. SAP systems, from release 4.0, employ WE8DEC extensively. This shift is crucial when migrating from older systems that utilize US7ASCII to ensure compatibility and support for all languages, particularly multibyte languages such as Chinese, Japanese, and Korean. Key steps include backing up the database, executing SQL commands to change the character set, and adjusting the NLS_LANG parameters across SAP and Oracle environments. This procedure is specific to upgrades from US7ASCII and must follow a precise sequence to avoid database errors and ensure system stability and data integrity.
Key words :
sql> shutdown immediatesql> startup mountsql> alter system enable restricted session, sql> alter database character set we8dec, sql> alter system set job_queue_processes=0, sql> shutdown immediatesql> exit 3, sql> alter database open, utf8 unicode character set, -unicode database character set, multi-byte character sets, we8dec database back, database character set
Related Notes :
| 1113270 | 10g: "ThrtReadDBVersion: Db version overflow" w/ SAP start |
| 669902 | Setting the national character set to UTF8 |
| 606359 | FAQ: Oracle National Language Support (NLS) |
| 122252 | Installation procedure with database copy |
| 30211 | Japanese Oracle Database Support |