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: http://www.oracle.com/database/product_editions.html

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.

Configuration[edit]

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. )