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
Take a look at what XE has installed in our system.
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 do using a dedicated (single threaded) Extproc for a Single 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
This is a graphical SQL editor that you can use to execute SQL commands, view result sets, create various database objects, and more.
Oracle 11g XE is a free version of Oracle database
