oracle11ex版本图⽂安装
Oracle 11g XE 是 Oracle 数据库的免费版本，⽀持标准版的⼤部分功能，11g XE 提供 Windows 和 Linux 版本。
做为免费的 Oracle 数据库版本，XE 的限制是：
最⼤数据库⼤⼩为 11 GB
可使⽤的最⼤内存是 1G
⼀台机器上只能安装⼀个 XE 实例
XE 只能使⽤单 CPU，⽆法在多CPU上进⾏分布处理
下⾯介绍安装过程：
⾸先下载 Oracle 11g XE 并解压，解压后的DISK1⽬录中包含了 ⽂件，双击启动安装程序，⾸先会显⽰⼀个协议信息，点击继续安装：
操作系统⾄少是 Windows XP
当前操作⽤户必须有管理员权限
当前机器尚未安装 XE
选择安装⽬录：
设置数据库密码：
前⾯⼏步过后会显⽰⼀个安装概要信息，包含以下内容：
侦听器端⼝: 1521
MTS 服务端⼝: 2030
HTTP 侦听端⼝: 8080
接下来看看 XE 在我们的系统中安装了什么？
Windows服务：
服务详细列表：
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 an extproc 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 single extproc 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.
程序列表：
在开始菜单中，你会发现 Oracle 新安装的程序：
这些程序包括：
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 comm
ands 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.
⼀些附加的⼯具
SQL Developer
这是⼀个图形化的 SQL 编辑器，可⽤来执⾏ SQL 命令、查看结果集、创建各种数据库对象等等。
SQL Developer Data Modeler
这是⼀个数据库建模⼯具。
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.
linux系统安装oracle11gODAC (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个⽉前)
评论(0)| 引⽤此评论| 举报
----------------------------------------------
hantsy 2年前
XE11g ⽐较奇怪, Windows 版本只有32位，linux 版本只有64位的
评论(0)| 引⽤此评论| 举报
----------------------------------------------
hantsy 2年前
最⼤数据库⼤⼩为 11 GB ？ 10 才能⽀持到4G，现在放宽了？
评论(0)| 引⽤此评论| 举报
----------------------------------------------
51b 2年前
SQL Developer 和 SQL Developer Data Modeler 需要另外下载
评论(0)| 引⽤此评论| 举报
----------------------------------------------
liuex 1年前
引⽤来⾃“hantsy”的答案
最⼤数据库⼤⼩为 11 GB ？ 10 才能⽀持到4G，现在放宽了？
oracle官⽹上确实说是11G
评论(0)| 引⽤此评论| 举报
----------------------------------------------
< 1年前
另外，必须使⽤本地管理员⽤户安装，不能使⽤windows域⽤户，否则安装不成功
评论(0)| 引⽤此评论| 举报
----------------------------------------------
wxmqwe 1年前
个⼈真⼼觉得还是⽤oracle的虚拟机联系oracle
评论(0)| 引⽤此评论| 举报
----------------------------------------------
烂泥⾏天下 9个⽉前
呵呵这个还是前⼏天才知道呢这⼏天正在学习呢

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。