Oracle 11g XE Installation
Overview
Oracle's eXpress Edition database is free to develop, test and deploy. Below is the essential information to get it up and running.
Links
- Download
- XE Version limitations.
- Support forum.
Installation
Tested on Windows 2008 64-bit R2.
0. Run setup.exe 1. Welcome [Next] 2. License Agreement (x) Accept [Next] 3. Destination Folder C:\app\oraclexe 4. Password Enter Password: ******** Confirm Password: ******** 5. Summary a. With the Windows Snippet Tool take snapshot of the displayed settings for future reference. b. [Install] [Finish]
64 Bit OS Issue
If installing on a 64-bit system you may get an error similar to:
C:\Users\...\KEY_XE.reg
To fix:
- Open the corresponding Windows Explorer folder.
Example: C:\Users\admini~1\AppData\Local\Temp\2\
{60712028-B7B0-4EC3-9C28-663111EC954A} - Copy the file OracleMTSRecoveryService.reg to KEY_XE.reg
- Return to the Oracle Installer and click OK on the error message box.
The installer will continue to run then indicate it is complete.
Post Install Actions
- Set environment vars (ORACLE_HOME, ORACLE_SID).
- Create SQLPlus shortcut:
C:\oraclexe\app\oracle\product\11.2.0.server\bin\sqlplus sys/Password@XE as sysdba - Confirm Installation OK.
- Ensure services started: OracleServiceXE & OracleXETNSListener
- Run SQLPlus and ensure connection and database OK.