oracle数据库修改用户字符集,Oracle修改数据库字符集

1.(Window：)cmd下输入set ORACLE_SID=你想进入的数据库的那个sid

(Linux：)切换到oracle用户：export  ORACLE_SID=你想进入的数据库的那个sid

2.输入 sqlplus /nolog

3.将数据库启动到RESTRICTED模式下做字符集更改：

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>startup mount

ORACLE instance started.

Total System Global Area  236000356 bytes

Fixed Size                   451684 bytes

Variable Size             201326592 bytes

Database Buffers           33554432 bytes

Redo Buffers                 667648 bytes

Database mounted.

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;