Modifying oracle databases and character sets

 

SQL & gt; select userenv ('language') from dual;

USERENV ('language ')

----------------------------------------------------

AMERICAN_AMERICA.WE8ISO8859P1

SQL & gt; select userenv ('language') from dual;

USERENV ('language ')

----------------------------------------------------

AMERICAN_AMERICA.WE8ISO8859P1

SQL & gt; shutdown immetiate;

SP2-0717: illegal SHUTDOWN option

SQL & gt; shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL & gt; startup mount;

ORACLE instance started.

Total System Global Area 1828716544 bytes

Fixed Size 2021536 bytes

Variable Size 419432288 bytes

Database Buffers 1392508928 bytes

Redo Buffers 14753792 bytes

Database mounted.

SQL & gt; alter system enable restricted session;

System altered.

SQL & gt; alter system set job_queue_processes = 0;

System altered.

SQL & gt; alter system set aq_tm_processes = 0;

System altered.

SQL & gt; alter database open;

Database altered.

SQL & gt; alter database character set internal_use AL32UTF8;

Database altered.

SQL & gt; select userenv ('language') from dual;

USERENV ('language ')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

SQL & gt; select userenv ('language') from dual;

USERENV ('language ')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

SQL & gt; shutdown immetiate;

SP2-0717: illegal SHUTDOWN option

SQL & gt; shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL & gt; startup;

ORACLE instance started.

Total System Global Area 1828716544 bytes

Fixed Size 2021536 bytes

Variable Size 419432288 bytes

Database Buffers 1392508928 bytes

Redo Buffers 14753792 bytes

Database mounted.

Database opened.

SQL & gt; select userenv ('language') from dual;

USERENV ('language ')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

This article is from the "wangyue Feiyu" blog