Oracle Faq (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. 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 commonly known as 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
Best export NL2004-10-20_FORMAT='YYYY-MM- DD HH24:MI:SS' specifies the date format;
3) If the characterset in props$ is specified when building the database, it 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 DBA can avoid problems as much as possible instead of waiting until problems occur. Put out fires.

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/314203.html

www.bkjia.com

truehttp: //www.bkjia.com/PHPjc/314203.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:...