OracleFaq (Oracle Character Set Problem)

1. When creating a database, catproc must run, otherwise the following character set error occurs when using rman: RMAN-00554: initialization of internal renal 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 Characters Set description ZHS16CGB231280 CGB2312-80 16-bit Simplified Chinese MB, ASCII ZHS16GBK GBK 16-bit Simplified Chinese MB, ASCII, UDC simply said ZHS16GBK is the super set of ZHS16CGB231280. A unified East Asian ideographic character set (GBK) jointly developed by China, Japan, and South Korea ). 3. To avoid Chinese support problems, we always recommend that you plan your database so that no problem will occur in the future. 1) create database character set ZHS16GBK national character set ZHS16GBK 2) environment variable: NLS_LANG = american_america.ZHS16GBK preferably export NLS_DATE_FORMAT = YYYY-MM-DD HH24: MI: SS specifies the date format; 3) if characterset in props $ is specified at the time of database creation, it must be ZHSS16GBK: NLS_CHARACTERSET ZHS16GBK NLS_NCHAR_CHARACTERSET ZHS16GBK. If not, update can be used, but this will affect existing data, it may even cause the entire database to be unavailable. Therefore, the database should be verified after the database is created. A good DBA can avoid the problem as much as possible, rather than wait for the 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 :)