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

First, view the character set

SQL > select * from v$version BANNER CON_ID -Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit Production 0PL/SQL Release 12.1.0.2.0-Production 0CORE 12.1.0.2.0 Production 0TNS for Linux: Version 12.1.0.2.0-Production 0NLSRTL Version 12.1.0.2.0-Production 0SQL > select * from nls_database_parameters PARAMETER VALUE---NLS_RDBMS_VERSION 12.1.0.2.0NLS_NCHAR_CONV_EXCP FALSENLS_LENGTH_SEMANTICS BYTENLS_COMP BINARYNLS_DUAL_CURRENCY $NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_SORT BINARYNLS_DATE_LANGUAGE AMERICANPARAMETER VALUE-- NLS_DATE_FORMAT DD-MON-RRNLS_CALENDAR GREGORIANNLS_NUMERIC_CHARACTERS. NLS_NCHAR_CHARACTERSET AL16UTF16NLS_CHARACTERSET AL32UTF8NLS_ISO_CURRENCY AMERICANLS_CURRENCY $NLS_TERRITORY AMERICANLS_LANGUAGE AMERICAN20 rows selected.

Second, modify the character set

SQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > startup mount;ORACLE instance started.Total System Global Area 1778384896 bytesFixed Size 2925408 bytesVariable Size 1627393184 bytesDatabase Buffers 134217728 bytesRedo Buffers 13848576 bytesDatabase mounted.SQL > alter session set sql_trace=true; Session altered.SQL > alter system enable restricted session; System altered.SQL > alter system set job_queue_processes=0; System altered.SQL > alter system set aq_tm_processes=0;System altered.SQL > alter database open;Database altered.SQL > ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK Database altered.SQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > SQL > startupORACLE instance started.Total System Global Area 1778384896 bytesFixed Size 2925408 bytesVariable Size 1627393184 bytesDatabase Buffers 134217728 bytesRedo Buffers 13848576 bytesDatabase mounted.Database opened.SQL > select userenv ('language') from dual USERENV ('LANGUAGE')-AMERICAN_AMERICA.ZHS16GBKSQL > select * from nls_database_parameters PARAMETER VALUE---NLS_RDBMS_VERSION 12.1.0.2.0NLS_NCHAR_CONV_EXCP FALSENLS_LENGTH_SEMANTICS BYTENLS_COMP BINARYNLS_DUAL_CURRENCY $NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_SORT BINARYNLS_DATE_LANGUAGE AMERICANPARAMETER VALUE-- NLS_DATE_FORMAT DD-MON-RRNLS_CALENDAR GREGORIANNLS_NUMERIC_CHARACTERS. NLS_NCHAR_CHARACTERSET AL16UTF16NLS_CHARACTERSET ZHS16GBKNLS_ISO_CURRENCY AMERICANLS_CURRENCY $NLS_TERRITORY AMERICANLS_LANGUAGE AMERICAN20 rows selected.- needs to be modified back to JOB_QUEUE_PROCESSES default 1000AQ_TM_PROCESSES default 10485760

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.