ORACLE 10G Modify character encoding no hyper-character limit _oracle

ORACLE 10G modified character encoding, no longer troublesome, no super character set limit, you can directly modify the string you want, but may already exist before the data may be displayed incorrectly, you need to re-import

The modification method is as follows:

$sqlplus/nolog

Sql>conn/as Sysdba;

Then execute the following command: Sql>startup MOUNT;

If you are prompted not to share the memory usage command

Ora-27125:unable to create shared memory segment
[Oracle@yans1 ~]$ ID Oracle
uid=500 (Oracle) gid=502 (oinstall) groups=502 (Oinstall), 501 (DBA)
[Oracle@yans1 ~]$ More/proc/sys/vm/hugetlb_shm_group
0
Below, use root to add the DBA group to the system kernel by executing the following command:
# echo 501 >/proc/sys/vm/hugetlb_shm_group

Sql>alter SYSTEM ENABLE restricted session;

Sql>alter SYSTEM SET job_queue_processes=0;

Sql>alter SYSTEM SET aq_tm_processes=0;

Sql>alter DATABASE OPEN;

Sql>alter DATABASE CHARACTER SET internal_use ZHS16GBK

Sql>shutdown IMMEDIATE;

Sql>startup

Quit Exit Sqlplus and start listening lnsrctl start.

Lnsrctl Start is a system command and cannot be used in Sqlplus