软件下载网址:

Oracle Database Express Edition 11g Release 2

简明教程下载网址:

http://www.google.com.hk/url?sa=t&rct=j&q=Oracle+Database+XE+简明教程&source=web&cd=4&ved=0CEcQFjAD&url=http://webclass.bhu.edu.cn/jpk/C34/其他资源/Oracle Database XE.doc&ei=h_qIT73UH47UmAW-3dy5CQ&usg=AFQjCNEQiQUCJRMHZ4sqKjVz5O6Loz7T2g&cad=rjt

安装前:

1.卸载原来已有的

2.检查环境变量,ORACLE_HOME和TNS_ADMIN是否存在,存在则删除

TNS_ADMIN=D:\apply\oracle11gxe\app\oracle\product\11.2.0\server\network\ADMIN

ORACLE_HOME=D:\apply\oracle11gxe\app\oracle\product\11.2.0\server

3.重启电脑

安装:

1.将下载的OracleXE112_Win32.zip解压到当前目录

2.选中DISK1目录下的setup.exe,(在win7上:右击菜单,选择"以管理员身份运行")执行 3.点击下一步,选择安装的目录,输入sys/system口令,因为自己学习使用,输入为system.然后等待安装完成. 4.显示内容: 目标文件夹: D:\apply\oracle11gxe\ Oracle 主目录: D:\apply\oracle11gxe\app\oracle\product\11.2.0\server\ Oracle 基目录:D:\apply\oracle11gxe\ 'Oracle 数据库监听程序' 的端口: 1521 'Oracle Services for Microsoft Transaction Server' 的端口: 2030 'Oracle HTTP 监听程序' 的端口: 8080

5.重启电脑

6.管理访问:

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

修改Oracle XE HTTP 监听程序端口

sqlplus "/ as sysdba"

exec   dbms_xdb.sethttpport('8070');

quit

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

启动8070端口监听,将listener.ora添加红色字体内容,然后重启主机

LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.102)(PORT = 1521))     )     (DESCRIPTION=       (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8070))(Presentation=HTTP)(Session=RAW)     )  )

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

  Error1.执行报错 sqlplus "/ as sysdba" Error 6 initializing SQL*Plus SP2-0667: Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory 原因是装过其他的oracle版本,ORACLE_HOME环境变量设置不对,修改为ORACLE_HOME=D:\apply\oracle11gxe\app\oracle\product\11.2.0\server 再次执行成功

Error2.连接报错

sqlplus system/password@XE

ERROR:

ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 将listener.ora添加红色字体内容 SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = D:\apply\oracle11gxe\app\oracle\product\11.2.0\server)       (PROGRAM = extproc)     )     (SID_DESC =       (SID_NAME = CLRExtProc)       (ORACLE_HOME = D:\apply\oracle11gxe\app\oracle\product\11.2.0\server)       (PROGRAM = extproc)     )     (SID_DESC =       (SID_NAME = XE)       (ORACLE_HOME = D:\apply\oracle11gxe\app\oracle\product\11.2.0\server)       (PROGRAM = extproc)     )  ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.102)(PORT = 1521))     )   ) DEFAULT_SERVICE_LISTENER = (XE) 保存后重新启动监听 Error3.连接报错 sqlplus system/password@XE ERROR: ORA-28547: 连接服务器失败, 可能是 Oracle Net 管理错误 将listener.ora添加红色字体内容注释掉,然后变为

SID_LIST_LISTENER =

  (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = D:\apply\oracle11gxe\app\oracle\product\11.2.0\server)       #(PROGRAM = extproc)    )     (SID_DESC =       (SID_NAME = CLRExtProc)       (ORACLE_HOME = D:\apply\oracle11gxe\app\oracle\product\11.2.0\server)       #(PROGRAM = extproc)    )     (SID_DESC =       (SID_NAME = XE)       (ORACLE_HOME = D:\apply\oracle11gxe\app\oracle\product\11.2.0\server)       #(PROGRAM = extproc)    )   ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.102)(PORT = 1521))     )   ) DEFAULT_SERVICE_LISTENER = (XE)

保存后重新启动监听

Error4.连接报错