Shulou(Shulou.com)06/01 Report--

Today, when using PLSQL to import data through EXCEL, it is found that all Chinese are displayed as?

Confirm that the database character set is not set properly: compared with the normal database, it is found that NLS_CHARACTERSET is ZHS16GBK

SQL > select name,value$ from props$ where name like 'NLS%' NAME VALUE$---NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS. NLS_CHARACTERSET ZHS16GBKNLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICANNLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMNAME VALUE$- -NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY $NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSENLS_NCHAR_CHARACTERSET AL16UTF16NLS_RDBMS_VERSION 10.2.0.4.0

The method available on the Internet is to directly update the value of this column, but after update

SQL > update props$ set value$='AL32UTF8' where name='NLS_CHARACTERSET'

Take a look at the character set information for the current database, although the view shows that the modification was successful. But...

SQL > col value for a40SQL > Select * from NLS_DATABASE_PARAMETERS PARAMETER VALUE-- NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS. NLS_CHARACTERSET AL32UTF8NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICANNLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER VALUE-- -NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY $NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSENLS_NCHAR_CHARACTERSET AL16UTF16NLS_RDBMS_VERSION 11.2.0.1.0

An error message "ORA-06553: PLS-553" will appear when performing operations such as DDL:

CM-CFG-5029 Content Manager is unable to determine whether the content store is initialized.ORA-06552: PL/SQL: Compilation unit analysis terminatedORA-06553: PLS-553: character set name is not recognized

It can be determined that it is caused by a character set conflict. Check

ALTER DATABASE CHARACTER SET ZHS16GBK;ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK

An error message was also encountered when modifying:

ERROR at line 1:ORA-12719: operation requires database is in RESTRICTED mode [oracle@021Y-SH-BKAP ~] $oerr ora 1271912719, 00000, "operation requires database is in RESTRICTED mode" / / * Cause: This command can only be run when the database is in RESTRICTED mode// * Action: Ensure that the system is in RESTRICTED mode

Solution:

SHUTDOWN IMMEDIATE; STARTUP MOUNT EXCLUSIVE; ALTER SYSTEM ENABLE RESTRICTED SESSION

After confirming that the modification is successful, restart the database. Note that the work plan should also be closed before the production environment is restarted.

Show parameter job_queue_processes;show parameter aq_tm_processes;alter database set job_queue_processes=0

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.