Oracle 12cR2 Oracle Core Database, 核心数据库版本,Native Install for Core Database

oracle将针对Linux提出一个新的安装版本 Oracle Core Datbase ,该Core Database将使用Linux上的原生安装方式 例如rpm或其他package,这意味着你安装Oracle Core Database只需要一条命令 yum install oracle-core-database。这与之前Oracle发布过的Oracle Express版本 Oracle XE 看起来有些相似,但是和Oracle XE的有巨大的差别,因为Oracle XE是一个阉割的不能再阉割的一个版本,而Oracle Core Database不是,Oracle Core Database在Oracle数据库的基本功能上完全没有限制,仅仅限制了部分企业版的option。这意味着Oracle将其核心功能精简到一个Core Database中,并在Linux上以 rpm或其他package形式快速发布。”Oracle Core Database 12gR1 will be packaged as an RPM. RPM is considered the standard way to deploy packages on most Linux systems. Also, RPM was originally known as ‘Redhat Package Manager’ which is now updated and known as ‘RPMPackage Manager’.”

Oracle Core Database的提出显然是为了在12cR2 sharding的预言, Oracle Core Database版本将区别于Oracle EE enterprise edition企业版的较高价格,其本身的出现就是为sharding而设计的,为了让用户能从sharding中充分获得横向扩展能力,显然Oracle要在原有EE企业版的基础上搞出一个即易于安装部署、具备Oracle数据库的核心功能,又与Oracle原有EE企业版有功能差距的这么一个版本。在这个Core Database版本上,Oracle可以大幅降低其license 成本费用,达到Oracle EE企业版的几分之一乃至几十分之一的价格。 毕竟Oracle license许可证的价格是阻碍Oracle Sharding大规模横向扩展的唯一的瓶颈,Oracle真要搞sharding,那么其技术上几乎没有什么瓶颈。

 

Oracle Core Database与Oracle XE的另一些区别是:Oracle XE是免费的,没有官方支持也没有补丁。 而Oracle Core database 是需要license许可证,同时官方也提供支持和补丁。

Oracle Core database将支持的option :

Application Development, Language, andDatabase Features
SQL*Plus
PL/SQL stored procedures and triggers
PL/SQL server pages
PL/SQL native compilation
JDBC drivers
XML support in the database(no JNDI , or Servlet Support)
Native .NET data provider support
ASP.NET Providers
OLE DB support
ODBC support
.NET Stored Procedures
Microsoft Distributed Transaction Coordinator support
Large Page memory support
DML triggers
Database event triggers
Instead-of triggers
Index-organized tables
Temporary table
Objects and Extensibility
LOB (large object) support
Oracle Text
Oracle Locator
Function-based index
Regular Expressions
Sample Scan
SQL Model
SQL Analytic functions
Star query transformation (B-tree indexes only)
Globalization support (excluding Locale Data Customization)
Multiple block size support
Availability/BackupandRecovery Features
Drop column
Rename column, constraint
Flashback Query
Online Backup
Incremental backup and recovery ((no change tracking file or optimized incremental backup capability)
Oracle Logminer
Data Movement/Integration Features
Direct Path Load API
External tables
External procedures
Advanced Queuing
Basic Replication (read-only and updateable materialized view site only)
Distributed queries
Distributed transactions
Generic connectivity
Manageability Features
Automatic Datafile Management
Automatic Memory Management
Automatic Optimizer Statistics Management
Server-generated Alerts

 

 

在原计划中Oracle Core Database 也将分成EE 企业版 和 SE 标准版 2个版本:

 

 

Feature SE1 SE EE Core-EE Core-SE Comments
High Availability
Oracle Fail Safe Y Y Y N N
Oracle RAC One Node N N Y N N Extra Cost Option (EE only)
Oracle Data Guard N N Y N N
Oracle Active Data Guard N N Y N N Extra Cost Option (EE only)
Rolling Upgrades – Patchset, DB and OS N N Y N N
Online Index Rebuild N N Y Y N
Online Index-organized table organization N N Y Y N
Online table redefinition N N Y Y N
Duplexed backup sets N N Y Y N
Block change tracking for fast incremental backup N N Y Y N
Unused block compression in backups N N Y Y N
Block-level media recovery N N Y Y N
Lost-write protection N N Y Y N
Automatic Block Repair N N Y Y N
Parallel Backup and Recovery N N Y Y N
Tablespace point-in-time recovery N N Y Y N
Trial-Recovery N N Y Y N
Fast-start Fault Recovery N N Y Y N
Flashback Table N N Y Y N
Flashback Database N N Y Y N
Flashback Transaction N N Y Y N
Flashback Transaction Query N N Y Y N
Oracle Total Recall N N Y N N Extra Cost Option (EE only)
Scalability
Oracle Real Application

Clusters

N Y Y N N
Automatic Workload Management N Y Y N N
Client side Query Cache N N Y Y N
Query Results Cache N N Y Y N
Pl/SQL Function Result Cache N N Y Y N
In-Memory Database Cache N N Y N N Extra Cost Option (EE only)
Database Smart Flash Cache N N Y Y N Solaris and Oracle Linux only (EE only)
Support for Oracle Exadata N N Y N N

 

 

Feature SE1 SE EE Core-EE Core-SE Comments
Security
Advanced Security Option N N Y N N Extra Cost Option (EE only)
Oracle Label Security N N Y N N Extra Cost Option (EE only)
Virtual Private Database N N Y Y N
Fine-grained auditing N N Y Y N
Oracle Database Vault N N Y N N Extra Cost Option (EE only)
Secure External Password Store N N Y N N
Development Platform
SQLJ Y Y Y N N
Oracle Developer Tools for Visual Studio Y Y Y Y Y Separate download Windows only
Microsoft Distributed Transaction Coordinator support Y Y Y Y Y Windows only
Active Directory Integration Y Y Y Y Y Windows only

AD configuration for Net

 

 

Name Resolution not supported
Native .NET Data Provider – ODP.NET Y Y Y Y Y Windows only
.NET Stored Procedure Y Y Y Y (?) Y Windows only
Manageability
Oracle Change Management

Pack

N N Y N N Extra Cost Option (EE only)
Oracle Config Management Pack N N Y N N Extra Cost Option (EE only)
Oracle Diagnostics Pack N N Y N N Extra Cost Option (EE only)
Oracle Tuning Pack N N Y N N Extra Cost Option (EE only)
Oracle Provisioning and Patch Automation Pack N N Y N N Extra Cost Option (EE only)
Oracle Real Application Testing N N Y N N Extra Cost Option (EE only)
Database Resource Manager N N Y Y N
Instance Caging N N Y Y N
SQL Plan Management N N Y Y N

 

 

Feature SE1 SE EE Core-EE Core-SE Comments
VLDB, Data Warehousing, BI
Oracle Partitioning N N Y N N Extra Cost Option (EE only)
Oracle OLAP N N Y N N Extra Cost Option (EE only)
Oracle Data Mining N N Y N N Extra Cost Option (EE only)
Oracle Advanced Compression N N Y N N Extra Cost Option (EE only)
Basic Table Compression N N Y Y N
Deferred Segment Creation N N Y Y N
Bitmapped Index, bitmapped join index, and bitmap plan conversions N N Y Y N
Parallel Query/DML N N Y Y N
Parallel Statistics Gathering N N Y Y N
Parallel index build/scans N N Y Y N
Parallel Data Pump export/import N N Y Y N
In-memory parallel  execution N N Y Y N
Parallel  Statement Queuing N N Y Y N
Parallel Capture and Apply via XStream N N Y Y (?) N
Transportable tablespaces, including cross-platform N N Y Y N Import supported into SE1, SE, and Core-SE
Summary Management – Materialized View Query Rewrite N N Y Y N
Asynchronous Change Data Capture N N Y N N
Integration
Basic replication Y Y Y Y Y SE1/SE/Core-SE: read- only, updateable MV
Advanced Replication N N Y Y N Multimaster replication
Oracle Streams Y Y Y N N SE1/SE: no capture from redo
Database Gateways Y Y Y N N Separate product license(EE only)
Messaging Gateway N N Y N N
Networking
Oracle Connection Manager N N Y N N
Infiniband Support N N Y Y (?) N
Content Management
Oracle Spatial N N Y N N Extra Cost Option (EE only)
Semantic Technologies (RDF/OWL) N N Y N N Requires Oracle Spatial and Partitioning Option (EE only)
Spatial and Location Data
Parallel spatial index builds N N Y N N
Multimaster replication of SDO_GEOMETRY objects N N Y N N Need more evaluation if we need to support it
Partitioned Spatial Indexes N N Y N N Requires Oracle Partitioning (EE only)

 

1.1          Additional Feature Restrictions for Core DB (based on 11.2 features)

  • No Java in the

 

  • Only partial support of Oracle Context, same as XE version
    • English/French knowledge bases not supplied, nor are the following features: RULE_CLASSIFIER, SVM_CLASSIFIER and KMEAN_CLUSTERING
  • No support of Oracle interMedia and Ultra
  • Partial XML Support in DB
    • No XQuery, JNDI or servlet support
    • No https support for XDB http listener
  • No XDK
  • No support of Database Web Services
  • No pre-compilers support
  • No Assistants
    • DB creation using scripts
    • DB Upgrade using manual
  • Networking
    • LDAP naming configuration not
    • All configuration to be done manually, no tools
  • Security
    • LDAP over SSL not
    • Enterprise User Security and Wallet Manager not
    • No encryption support (SecureFiles, Backup).
  • ASM not
  • No JMS support for
  • Workspace Manager and OWB (Oracle Warehouse Builder) not
  • Perl and Bali libraries not
  • Application Express and SQL Developer not shipped with Core. But they can be installed on top of Core using separate packages available over
  • Oracle Administration Assistant for Windows not
  • No Locale

1.2          Feature Restrictions (based on 12.1 features)

 

  • All options (on top of EE) will be excluded by
  • All sub features added on top of 2 excluded feature list (listed in 1.1 and 1.2) are excluded.
  • DB Consolidation (Pluggable Databases) not
  • Global Service Management not
  • End-to-end Application Continuity not
  • DRDA Application Server for Oracle not
  • No support of these 1 enhancements: Auditing, Real Application Security, Encryption, ILM, XBRL, SQL Test Case Builder.

1.3          Open Issues

  • Need to evaluate the following:
    • Exclude .NET Stored Procedure Support and Infiniband support, if
    • Evaluate 1 RMAN backup enhancements and see what can be included.
    • Evaluate how Core DB can used as a pluggable

Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *