ORACLE DataBase 10g Express Edition是ORACLE推出的免费版本,也叫XE版,
可用于初步的开发和学习。有齐全的API。但是有一些限制:只能使用一个
处理器,最多只能存取4G的数据库数据,使用1G的内存。
此版本很小巧,个人学习没有问题的。
可以安装一个第三方的开发工具pl/sql developer来连接服务器,使用很方便。
==================================================================
下载地址:
http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
Oracle 11g XE 是 Oracle 数据库的免费版本,支持标准版的大部分功能,11g XE 提供 Windows 和 Linux 版本。
做为免费的 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.
相关推荐
Oracle Database 10g Express Edition,本人用于学习。
Oracle Database 21c Express Edition安装指导文件,英文原版。
Oracle Database Express Edition Online Documentation 10g Release 2 (10_2).从官方下载的英文文档,希望对大家有帮助。
高山Oracle数据库11g快捷版Docker映像该映像基于Alpine GNU C库映像( ),该映像仅为5MB映像,并为Oracle Database 11g第2版Express Edition提供了docker映像。先决条件如果要构建此映像,则需要下载 。 Oracle ...
Oracle Database 10g Express Edition,轻量级oracle数据库,适合学习、开发、小型业务系统。
Oracle Database Express Edition Installation Guide/ 甲骨文免费版本数据库 安装指南 说明书 (Database XE)
docker-oracle-xe-11g:Oracle Database Express Edition 11g第2版的Dockerfile
Oracle Database Express Edition 11g容器 这为Oracle XE 11g提供了一个Docker容器。用法基本用法由于许可问题,我们无法分发oracle RPM。 但这并不意味着设置过程必须非常复杂。 只需创建一个扩展该docker文件的新...
Ubuntu 18.04 LTS上的Oracle Express Edition 11g第2版 该Dockerfile是的。 自2019年2月13日(情人节前夕)起,由于版权拥有者(Oracle)的Docker DMCA移除通知,该Docker镜像已被DockerHub删除。 情人节快乐! ...
struts2+spring2.5+hibernate3整合的完整示例,数据库为Oracle Database 10g Express Edition
Oracle Database Express Edition (XE) is a community supported edition of the Oracle Database family. Please go to the Oracle Database XE Community Support Forum for help, feedback, and enhancement ...
Three types of popular databases are covered and discussed in detail with practical sample examples: Microsoft Access, SQL Server 2008, and Oracle Database 10 g Express Edition (XE). 7. The various...
Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, ...
Oracle 10g Express Edition是Oracle专门为小型用户提供的免费版本。Oracle XE十分小巧,安装简单,可供第三方软件开发商部署较小的应用。 不过Oracle XE目前的beta2缺省安装的字符集是WE8MSWIN1252,不是中文...
APEX is an entirely Web-based framework that comes built into every edition of Oracle Database—its backbone is Oracle’s powerful PL/SQL language, alongside the most advanced Web development ...
Oracle XE备份脚本 此存储库包含用于执行Oracle XE数据库热备份的脚本。 安装 在Oracle XE中打开ARCHIVELOG模式 您需要在Oracle中启用ARCHIVELOG模式,... Oracle Database 11g Express Edition Release 11.2.0.2.0 -
介绍如何最大化地发挥oracle数据库、oracle databasevault、oracle identity management、oracle application express以及oracle business intelligence suite的安全特性。本书通过独家的权威资源,为您提供经过验证...
description: Oracle Database Express Edition (XE) is a community supported edition of the Oracle Database family. Please go to the Oracle Database XE Community Support Forum for help, feedback, and ...
Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle Features more than fifty sample projects with detailed illustrations and explanations...
OSM缓冲区服务器代理服务器使用Oracle数据库服务器,所以必须安装Oracle Database 11g Express Edition服务器。 此外,您必须安装 Oracle SQL Developer 开发环境,您需要借助该环境创建适当的数据库。 安装数据库...