Shulou(Shulou.com)06/01 Report--

1. (Window:) enter the sid of the database you want to access by typing set ORACLE_SID= under cmd

(Linux:) switch to oracle user: export ORACLE_SID= the sid of the database you want to access

two。 Enter sqlplus / nolog

3. Boot the database to RESTRICTED mode to make character set changes:

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

System altered.

SQL > alter database open

Database altered.

-- modified to Chinese character set

SQL > ALTER DATABASE character set INTERNAL_USE ZHS16GBK

-- modified to English character set

SQL > ALTER DATABASE character set INTERNAL_USE AL32UTF8

Database altered.

SQL > select * from v$nls_parameters

Slightly

19 rows selected.

Restart check to see if the changes are complete:

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup

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.

Database opened.

SQL > select * from v$nls_parameters

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.