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