Oracle Faq (Oracle Character Set Problem)

1. When creating a database, catproc must be run; otherwise, the following character set errors may occur when using rman:
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-06553: PLS-213: package STANDARD noe
RMAN-04015: error setting target database character set to ZHS16CGB231280
If no problem occurs during database creation, you can Re-run catproc. SQL. This will in turn call the dbmsbkrs. SQL script which creates the dbms_backup_restore package.

2. Chinese Character Set description
ZHS16CGB231280 CGB2312-80 16-bit Simplified Chinese MB, ASCII
ZHS16GBK GBK 16-bit Simplified Chinese MB, ASCII, UDC
In short, ZHS16GBK is the superset of ZHS16CGB231280.
A unified East Asian ideographic character set (GBK) jointly developed by China, Japan, and South Korea ).

3. How to Avoid Chinese support problems
We always recommend that you make proper planning when creating a database so that there will be no problems in the future.
1) create database
Character set ZHS16GBK
National character set ZHS16GBK
2) environment variable: NLS_LANG = american_america.ZHS16GBK
Preferably export NL2004-10-20_FORMAT = 'yyyy-MM-DD HH24: MI: ss' specifies the date format;
3) If characterset in props $ is specified during database creation, it must be ZHSS16GBK:
NLS_CHARACTERSET ZHS16GBK
NLS_NCHAR_CHARACTERSET ZHS16GBK
If it is not possible to change with update, but this will have an impact on the existing data, and even cause the entire database to be unavailable. Therefore, it is verified after the database is created, A good DBA can avoid problems as much as possible, instead of waiting for a problem to be solved.

In this way, there will be no more issues with character sets and Chinese support. Is there any problem? Contact me :)