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

Source: Internet
Author: User
Tags dba memory usage sqlplus

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.