Oracle Database XE

2019独角兽企业重金招聘Python工程师标准>>>

软件下载网址:
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/其他资源/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.管理访问:

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>.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.连接报错

 

转载于:https://my.oschina.net/mengyoufengyu/blog/914025