Oracle Licensing

Oracle Licensing

Why Oracle? Deepak Kharb   May 31, 2016

What is Licensing?

A digital permit containing descriptions of rights that can be applied to one or more pieces of content.

Why license is required?

Usage of software without violating copyrights.

Common flaws in using Oracle Licensing:-

• Extra usage like Options using that were not paid for or may be extending beyond the scope of the contractual terms.
• More users than licensed.
• More CPU's than licensed.
• Using Options/Packs/Features that need a separate license.
• Stand-by and back up servers also need license.

It is highly advisable to conduct a yearly audit of servers with a partner that understands Oracle licensing.

Oracle Database Editions:-

Oracle Database Standard Edition one(SE1):-

Availability:-From 12.1.0.1 or before, Oracle Database Standard Edition One and Oracle Database Standard Edition are available.
Features:-It is an affordable, full-featured database for servers with up to two sockets.

Oracle Database Standard Edition 2(SE2):-

Availability:-starting with Oracle Database 12c Release 1 (12.1.0.2)
Features:-Standard Edition is an affordable, full-featured database for servers with up to four sockets.

Oracle Database Enterprise Edition(EE)

Availability:-All version
Features:-offers industry-leading database solution without any restriction.

Oracle Database Express Edition(XE)

Availability:-All version
Features:-comes with certain restrictions;entry-level, small-footprint database that’s free;It can be installed on any size host machine with any number of CPUs

Oracle Database Personal Edition

Availability:-All version
Features:-Designed to provide software developers a cost effective, yet full featured Oracle Database environment without technical limits.

Feature Availability by Edition:-

Database Comparision

Database Comparision

Why Oracle? Deepak Kharb   May 25, 2016

Things to consider when deciding on a DBMS.

• Price.
• Operating System Support.
• Most important features (ACID, Referential Integrity support, Transactions support).
• Other important features (Indexes, materialized view support, trigger support).
• Scalability and security.
• Availability of support and software.

Comparison of five relational database management systems.

DB2 vs. Microsoft SQL Server vs. MySQL vs. Oracle vs. PostgreSQL.

Following tables are the comparison of relational database management systems in general and technical aspects.

Why Oracle?

Why Oracle?

Why Oracle? Deepak Kharb   May 23, 2016

• Less Integration, More Innovation.
• Scalability:- Available for wide range of operating systems like Microsoft Windows & Various flavor of Unix like IBM AIX,HP UX,Solaris etc.
• Complete Cloud.
• Improve System Performance.
• Big Data Integration.
• Internationalization.
• Various editions – Standard Edition One, Standard Edition, Enterprise Edition and Express Edition.
• Oracle VM.

Ocean of Oracle History

Ocean of Oracle History

Why Oracle? Deepak Kharb   May 19, 2016

Foundation:-

Founded in 1977.
Founded by Ellison, Bob Miner and Ed Oates.

Name History:-

1977-Software Development Laboratories (SDL).
1979-Relational Software, Inc (RSI).
1982-Oracle Systems Corporation.
1995-Oracle Corporation.

Database Version History:-