Precautions for installing Oracle10g and modifying the character set encoding of Oracle databases
Precautions for installing Oracle 10 GB and modifying the character set encoding of Oracle databases
Precautions for installing Oracle 10 GB:
1. disable network connection
2 .......
Modify the character set encoding of an Oracle database:
Modified at creation:
Follow the normal steps to create a database
Then select
Character encoding.
Code modification method:
Log on to SQLPLUS with system and password, and then:
1. log on to oracle with sys
Connect sys/password as sysdba; (Can I directly log on to sqlplus using sys ?)
2. start modifying the encoding.
Shutdown immediate; stop oracle services and listen. This parameter can be omitted if the service is stopped.
Startup mount;
Alter system enable restricted session;
Alter system set job_queue_processes = 0; initialize the job
Alter database open;
Alter database character set internal_use utf8; set the Encoding
Shutdown immediate;
Startup;
Now the encoding is complete.
,