Oracle 11g XE is a free version of Oracle database that supports most features of the Standard Edition, and 11g XE offers Windows and Linux versions.
As a free Oracle database version, XE's limitations are:
- Maximum database size is one GB
- Maximum memory available is 1G
- Only one XE instance can be installed on a single machine
- XE can only use a single CPU and cannot be distributed on multiple CPUs
The following describes the installation process:
First download the Oracle 11g XE and unzip, the extracted DISK1 directory contains the Setup.exe file, double-click Start installation program, first displays a protocol information, click Continue to install:
- The operating system is at least Windows XP
- The current operation user must have administrator privileges
- XE is not installed on the current machine
Select the installation directory:
To set the database password:
An installation summary is displayed after the previous steps, including the following:
- Listener Port: 1521
- MTS Service Port: 2030
- HTTP Listening port: 8080
Let's see what XE has installed in our system.
Windows Services:
Service Detail list:
OracleServiceXE
This is the actual database engine.
OracleXETNSListener
This service was responsible for listening incoming connections and passing successful connections to the database engine. Note, if this service is down, you won ' t being able to connect to the database remotely. Existing connections won ' t be affected.
OracleJobSchedulerXE
This service was used when external jobs was run. By default it is disabled. If you plan to run external jobs (such as executables, batches etc), modify the account of the service uses to use proper, lo W-privileged credentials and start the service.
OracleXEClrAgent
On Windows platforms Oracle offers CLR integration. Since a CLR operation is the run using an extproc
process, it's normally done using a dedicated (single threaded) for extproc
a sin GLE session. This is the optimal to handle CLR calls. Clragent provides a multi-threaded mechanism so, a single extproc
process may serve several CLR calls.
OracleMTSRecoveryService
This one was responsible of resolving IN-DOUBT transactions when Oracle was participating in distributed transactions with M Icrosoft Transaction Server.
List of programs:
From the Start menu, you will find the newly installed Oracle program:
These procedures include:
- Start and Stop Database is used to control the Oracleservicexe service
- Backup and Restore Database is scripts for backing up or restoring the database data using
rman
- Run SQL Command Line opens a console based sql*plus which can is used to execute SQL commands or to run scripts against th E 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 Statem Ent
- Parameters show current initialization parameter values.
Some of the additional tools
SQL Developer
This is a graphical SQL editor that you can use to execute SQL commands, view result sets, create various database objects, and more. SQL Developer Data Modeler
This is a database modeling tool. Odp.net, ODT and ODAC
Odp.net (Oracle Data Provider for NET) are the Oracle supplied library to use in application development when Oracle Connec tion is required. Odp.net utilizes several Oracle specific features and because of this it's much more powerful than for example OLE DB based Connections.
The ODT (Oracle Developer Tools for Visual Studio) are a set of Visual Studio Add-ins for Visual Studio, so Help application D Evelopment. These add-ins include functionality such as automatic code generation, tuning tools, PL/SQL editor, AQ designers etc. Unfortunately, ODT cannot is used with Express Editions of Visual Studio because of the limitations of the Express Edition .
ODAC (Oracle Data Access components) are a package which contains odp.net but also other connectivity libraries such as ODB C, OLE DB and tools like Sql*plus. ODAC can downloaded with or without ODT.
A total of 9 comments (last reply: 9 months ago)
Grey Ash 2 years ago
It's really useless. Oracle, I think SQL Server works well under Windows.
Comments (0) | Quote this comment | Report
----------------------------------------------
Brave white rat 2 years ago
Yo, 11g XE is finally out, you can replace the 10gXE
Address: http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
Comments (0) | Quote this comment | Report
----------------------------------------------
Hantsy 2 years ago
XE11G is strange, the Windows version only 32 bits, Linux version only 64-bit
Comments (0) | Quote this comment | Report
----------------------------------------------
Hantsy 2 years ago
The maximum database size is one GB? 10 can support to 4G, now relaxed?
Comments (0) | Quote this comment | Report
----------------------------------------------
51b 2 years ago
SQL Developer and SQL Developer Data Modeler need to be downloaded separately
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
Comments (0) | Quote this comment | Report
----------------------------------------------
Liuex 1 years ago
Cite the answers from "Hantsy"
The maximum database size is one GB? 10 can support to 4G, now relaxed?
The Oracle official web site does say 11G.
Comments (0) | Quote this comment | Report
----------------------------------------------
Fangyu ... 1 years ago
In addition, you must be installed with a local administrator user, you cannot use a Windows domain user, or the installation is unsuccessful
Comments (0) | Quote this comment | Report
----------------------------------------------
Wxmqwe 1 years ago
I really feel like I'm still using Oracle's virtual machine to contact Oracle.
Comments (0) | Quote this comment | Report
----------------------------------------------
Slime row world 9 months ago
Oh this is still a few days ago know that these days are learning
Source: http://www.oschina.net/question/12_27650
Oracle one-off version graphic installation