Oracle Database XE

来源：互联网发布：js 提示信息编辑：程序博客网时间：2024/05/07 14:45

软件下载网址:
Oracle Database Express Edition 11g Release 2
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

简明教程下载网址:

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/其他资源/OracleDatabaseXE.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.管理访问:

http://127.0.0.1:8070/apex/f?p=4950:1

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

修改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>.msbnot found
SP2-0750: You may need to set ORACLE_HOME to your Oracle softwaredirectory
原因是装过其他的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.连接报错

0 0

Oracle&nbsp;Database&nbsp;XE

Oracle Database XE