OracleFaq (Oracle character set problem)_PHP tutorial

1. When building the database, catproc must be running, otherwise the following character set errors will 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 there is no problem when building the database, 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 Simply put, ZHS16GBK is a superset of ZHS16CGB231280. The unified East Asian ideographic character set jointly developed by China, Japan, and South Korea in 1990 is often called the National Standard Extended Code Character Set (GBK). 3. How to avoid Chinese support problems. Our consistent suggestion is to plan well when building the 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 It is best to export NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS to specify the date format; 3) If props$ is specified when building the database The characterset must be ZHSS16GBK: NLS_CHARACTERSET ZHS16GBK NLS_NCHAR_CHARACTERSET ZHS16GBK If not, you can use update to change it, but doing so will have an impact on the existing data, and may even cause the entire database to become unusable, so it is better to verify it after building the database. A good The DBA can try to avoid problems from happening instead of waiting until problems arise and then put out the fire. In this way, there will no longer be problems with character sets and Chinese support. Still have questions? Contact me :)

http://www.bkjia.com/PHPjc/532291.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/532291.htmlTechArticle1. When building the database, catproc must be running, otherwise the following character set errors will occur when using rman: RMAN-00554: initialization of internal recovery manager package failed RMAN-04005:...