To change the Oracle character set on a virtual machine

Modify the character set on top of Oracle, you need to use the DBA database administrator's permissions, and then modify the character set to note that the modified character set can only be larger (for example: The current character set is GBK, then you can modify the UTF-8 that the latter can only be larger than the former, Not small. Because the character sets are backwards compatible)

Steps:

First step: Log in with DBA

Log in by bypassing the log first

　　　　

In a

　　　　

Then use the command to close the database

　　　　

　　　　

1>shutdown immediate;

2>startup Mount;

3>alter system enable restricted session;

4>alter system set job_queue_processes=0;:

5>alter system set aq_tm_processes=0;

6>alter database open;

7.1>alter Database Character Set UTF8

7.2>alter database character set Internal_use UTF8;

8>shutdown immediate;

9>startup;

1: (the database was stopped)

2: (Re-open the database to change the situation)

3: Open limit session mode (Alter system disable restricted session;

4:job_queue_processes=0: The value range is 0 to 1000, and the total number of job processes that can be created is determined by the job_queue_processes parameter.

When you set this value to 0, the job created in any way will not run

5: When we modify the character set, we will set 4, 52 processes parameters to 0, and the fifth command is only 0; (they prevent the task from automatically starting to execute, generally do not do that action is OK)

6:oracle Database Startup three steps

Nomount,mount, open;

Startup is the start of the database from the start phase, need to go through the above three steps;

　　　　　　ALTER DATABASE Open is the command to open the database from Mount state in the Mount State

7.1: Modifying the character set of the database

7.2: Error occurs when the new character set must be a superset of the character set, use this method: Skip over superset detection

8: (the database was stopped)

9: Run the database

(This is a synthesis of the answers of many great gods: hope to help those who are like me)

　　　　

To change the Oracle character set on a virtual machine