Oracle 10g express edition (xe) Go to database homepage to solve Chinese garbled Problem

Oracle 10g express edition is a free version dedicated to small users. Oracle Xe is very small and easy to install and can be used by third-party software developers to deploy small applications.
However, Oracle Xe's current beta2 default installation character set is we8mswin1252, not a Chinese character set, and cannot be directly run through
Alter database character set al32utf8;
Because al32utf8 is not the superset of the default character set.
In the past, the widely spread method of directly modifying the props $ table under sys users also leaves many potential problems for character set changes.

However, after installing Oracle XE, you can modify the character set in sqlplus (Oracle Xe's run SQL command line) by performing the following operations:

Connect system/Oracle9i as sysdba

Select userenv ('language') from dual; -- View Character Set

Shutdown immediate

Startup Mount

Alter system enable restricted session;

Alter system set job_queue_processes = 0;

Alter system set aq_tm_processes = 0;

Alter database open;

Alter database character set internal_use al32utf8;

Shutdown immediate

Startup

This completes the modification of the character set.

Grant all privileges to system with admin option; grant the system permission to System

(2) solution for abnormal login and invalid login users:

Run cmd to enter the command line

Sqlplus/nolog

Conn system/Oracle9i as sysdba

Alter user system identified by "system ";

In this way, you can use system/system to log on to the database homepage normally.