Oracle Database/Introduction

From Wikibooks, open books for an open world
< Oracle Database
Jump to: navigation, search

Oracle RDBMS is a relational database system.

Installing Oracle[edit]

As with most software products, it must be installed; Windows, Linux and Unix versions are available for use, and there are four editions available.

  • The Express Edition is free but uses a slightly older version of the Oracle database engine, and has upper RAM and storage limits. It is not available for Unix.
  • Standard Edition One removes the basic limitations for storage, and will support multi-cpu systems.
  • Standard Edition provides additional features pertaining to cluster management, and may be run on systems containing additional CPUs.
  • Enterprise Edition has no limitations, and may also include optional features that are suitable to large corporations.

A summary of the product versions is found on the Oracle website at:

If you do not have a copy of Oracle RDBMS already, you can download the express edition without cost. However, you will need to register for an account on the Oracle website.


The express edition will display the default ports to access the server. In particular:

  • The web management utility is on port 8080. (You can access this utility's homepage by entering http://localhost:8080/apex in the browser if it is installed on your local machine. )