在 Windows 下安装 Oracle 11g XE (Express Edition)
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了在 Windows 下安装 Oracle 11g XE (Express Edition),小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4640字,纯文字阅读大概需要7分钟。
内容图文
做为免费的 Oracle 数据库版本,XE 的限制是:
- 最大数据库大小为 11 GB
- 可使用的最大内存是 1G
- 一台机器上只能安装一个 XE 实例
- XE 只能使用单 CPU,无法在多CPU上进行分布处理
首先下载 Oracle 11g XE 并解压,解压后的DISK1目录中包含了 setup.exe 文件,双击启动安装程序,首先会显示一个协议信息,点击继续安装:
- 操作系统至少是 Windows XP
- 当前操作用户必须有管理员权限
- 当前机器尚未安装 XE
前面几步过后会显示一个安装概要信息,包含以下内容:
-
OracleServiceXE
This is the actual database engine. -
OracleXETNSListener
This service is responsible for listening incoming connections and passing successful connections to the database engine. Note, that if this service is down, you won’t be able to connect to the database remotely. Existing connections won‘t be affected. -
OracleJobSchedulerXE
This service is used when external jobs are run. By default it is disabled. If you plan to run external jobs (such as executables, batches etc), modify the account the service uses to use proper, low-privileged credentials and start the service. -
OracleXEClrAgent
On Windows platforms Oracle offers CLR integration. Since a CLR operation is run using anextproc
process, it’s normally done using a dedicated (single threaded)extproc
for a single session. This may not be the optimal way to handle CLR calls. ClrAgent provides a multi-threaded mechanism so that a singleextproc
process may serve several CLR calls. -
OracleMTSRecoveryService
This one is responsible of resolving in-doubt transactions when Oracle is participating in distributed transactions with Microsoft Transaction Server.
- Start and Stop Database are used to control the OracleServiceXE service
- Backup and Restore Database are scripts for backing up or restoring the
database data using
rman
- Run SQL Command Line opens a console based SQL*Plus which can be used to execute SQL commands or to run scripts against the database
- Get Started opens a web site used for investigating
- storage, the amount of disk space used by tablespaces or drill to segments
- current sessions and basic information about the sessions such as client and application information and active SQL statement
- parameters show current initialization parameter values.
一些附加的工具
ODP.NET, ODT and ODAC
ODP.NET (Oracle Data Provider for NET) is the Oracle supplied library to use in application development when Oracle connection is required. ODP.NET utilizes several Oracle specific features and because of this it’s much more powerful than for example OLEDB based connections.
ODT (Oracle Developer Tools for Visual Studio) is a set of Visual studio add-ins for Visual Studio that help application development. These add-ins include functionality such as automatic code generation, tuning tools, PL/SQL editor, AQ designers etc. Unfortunately, ODT cannot be used with Express Editions of Visual Studio because of the limitations of the Express Edition.
ODAC (Oracle Data Access Components) is a package which contains ODP.NET but also other connectivity libraries such as ODBC, OLEDB and tools like SQL*Plus. ODAC can be downloaded with or without ODT.
共有9个评论 (最后回答: 9个月前)
灰灰 2年前
还真没用过Oracle,觉得Windows下,SQL SERVER的效果不错。
评论(0)| 引用此评论|
举报
----------------------------------------------
神勇小白鼠 2年前
呦,11g XE
终于出来啦,可以把10gXE换掉了
地址:http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
评论(0)| 引用此评论| 举报
----------------------------------------------
hantsy
2年前
XE11g 比较奇怪, Windows 版本只有32位,linux 版本只有64位的
评论(0)| 引用此评论|
举报
----------------------------------------------
hantsy 2年前
最大数据库大小为
11 GB ? 10 才能支持到4G,现在放宽了?
评论(0)| 引用此评论|
举报
----------------------------------------------
51b 2年前
SQL Developer
和 SQL Developer Data Modeler 需要另外下载
SQL Developer :http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
SQL Developer Data Modeler :http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html
评论(0)| 引用此评论| 举报
----------------------------------------------
liuex
1年前
引用来自“hantsy”的答案
最大数据库大小为 11 GB ? 10 才能支持到4G,现在放宽了?
oracle官网上确实说是11G
评论(0)| 引用此评论|
举报
----------------------------------------------
Fangyu...
1年前
另外,必须使用本地管理员用户安装,不能使用windows域用户,否则安装不成功
评论(0)| 引用此评论|
举报
----------------------------------------------
wxmqwe
1年前
个人真心觉得还是用oracle的虚拟机联系oracle
评论(0)| 引用此评论|
举报
----------------------------------------------
烂泥行天下 9个月前
呵呵
这个还是前几天才知道呢 这几天正在学习呢
出处:http://www.oschina.net/question/12_27650
原文:http://www.cnblogs.com/mq0036/p/3640843.html
内容总结
以上是互联网集市为您收集整理的在 Windows 下安装 Oracle 11g XE (Express Edition)全部内容,希望文章能够帮你解决在 Windows 下安装 Oracle 11g XE (Express Edition)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。