1.安装共五步(等安装程序自己完成）
用户名：manager
密码： manager
2.完成后进DOS依次输入：
(1) > sqlplus system/manager
(2) SQL> connect system/manager as sysdba;
(3) SQL> shutdown immediate;
(4) SQL> startup mount;
(5) SQL> alter system enable restricted session;
(6) SQL> alter system set JOB_QUEUE_PROCESSES=0;
(7) SQL> alter system set AQ_TM_PROCESSES=0;
(8) SQL> alter database open;
(9) SQL> alter database character set internal_use ZHS16GBK; //设置成中文
(10)SQL> shutdown immediate;
(11)SQL> startup
3.注意不能输错，否则白装
4.安装完成后可以导入数据:
命令提示符下直接输入:IMP
按提示操作即可.数据源为:D:\oraclexe目录下的ss_shpd_epi0906.dmp
5.以下为实例
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\zlj>sqlplus system/manager
SQL*Plus: Release 10.2.0.1.0 - Beta on 星期三 9月 6 10:05:39 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
SQL> connect system/manager as sysdba;
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 146800640 bytes
Fixed Size 1246748 bytes
Variable Size 58722788 bytes
Database Buffers 83886080 bytes
Redo Buffers 2945024 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.
SQL> alter database character set internal_use ZHS16GBK;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 146800640 bytes
Fixed Size 1246748 bytes
Variable Size 58722788 bytes
Database Buffers 83886080 bytes
Redo Buffers 2945024 bytes
Database mounted.
Database opened.
SQL> exit;
D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora里是所有能登录到XE下的用户名
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = zhou-lijuan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) epicard = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sybsc) ) )
重点说明：
默认oracleXE 启动OracleXETNSListener和OracleServiceXE两个服务。
但是修改计算机名称。结果会导致OracleXETNSListener无法启动。
最好的解决方法：
修改：
%Oracle_
Home%\app\oracle\product\10.2.0\server\NETWORK\ADMIN 下
listener.ora
tnsnames.ora
修改这两个文件里指定计算机名称部分