1 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Is Oracle Database Cloud Right for You?

Guanglei Bao Oracle University Principal Instructor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle ’s products remains at the sole discretion of Oracle.

3 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Program Agenda



Types of Cloud Computing



Public Database Cloud



Private Database Cloud

4 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Types of Cloud Computing

5 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Types of Cloud Computing

Taxonomy  PaaS  IaaS 6 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted  DBaaS  SaaS

Oracle Clouds Public and Private

11 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Clouds

 Private 12 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted  Public

Oracle Database Cloud Service

13 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Attributes  Primarily a PaaS  Does not require operational effort for underlying Oracle Database  Very limited control over parameters and configurations  No standard SQL*Net connectivity 14 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Benefits  Instant provisioning  Rapid application development (RAD)  Iterative development  Full power of SQL and PL/SQL  Instance business value 15 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Instant provisioning  Install with a few mouse clicks 16 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Limitations  Small set of packaged applications  Upper limit on storage  Isolated services 17 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Isolated services 18 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Limitations  Small set of packaged applications  Upper limit on storage  Isolated services  Migration costs 19 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Security precautions  Different security lockdown goals – Protect customers’ data – Protect integrity of the service – Prevent hackers from using service to launch attacks 20 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Security precautions  Strictly enforced schema/tenant isolation – Fewer database options are installed – No Spatial, Context, Multimedia – – Performance and resource caging using Resource Manager Further security lockdown – Restricted access to many PL/SQL packages 21 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Security precautions  Should be locked down by default to minimize attack surface – No operating system or file system access – Absolutely no cross schema access 22 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Limitations  Small set of packaged applications  Upper limit on storage  Isolated services  Migration costs  Limited access options 23 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Limited access options 24 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Database Cloud Service

Scenarios  Need an environment for a new application  Want to migrate an existing Oracle database, but not application  Want to migrate an existing non-Oracle database, but not application  Want to migrate existing Oracle database and application  Need a test/dev environment  Need a Cloud platform for development 25 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Oracle Clouds

 Private 26 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted  Public

Private Database Cloud

27 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

Consolidation  Infrastructure Cloud  Database Cloud 28 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

Infrastructure Cloud  Virtualization  “Push-button” deployment  Resource isolation  Not for I/O-intensive databases 29 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

Database Cloud  RAC One Node  RAC  Pluggable DB  By passing virtualization layer 30 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

RAC One Node  Client connections

Server 1 Server 2 Server 3 DB-A DB-B DB-C DB-D DB-E

31 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

RAC One Node  Client connections

Server 1 Server 2 Server 3 DB-A DB-B DB-B DB-C DB-D DB-E

32 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

RAC One Node

Server 1

 Client connections

Server 2 Server 3 DB-A DB-B DB-B DB-C DB-D DB-E

33 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

Database Cloud  RAC  Extreme Schema Consolidation 34 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

New Clause: ENABLE PLUGGABLE DATABASE

PDB

SQL> CONNECT / AS SYSDBA SQL> STARTUP NOMOUNT SQL> CREATE DATABASE cdb2 2 USER SYS IDENTIFIED BY p1 USER SYSTEM IDENTIFIED BY p2 3 EXTENT MANAGEMENT LOCAL 4 DEFAULT TEMPORARY TABLESPACE temp 5 UNDO TABLESPACE undotbs 6 DEFAULT TABLESPACE users 7 ENABLE PLUGGABLE DATABASE ;

35 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Pluggable Database

36 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Connection to Pluggable Database

PDB

Container Database CDB1 root PDB_test PDB_hr PDB_dev

Listener/Service Listener/Service 37 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Common and Local Schemas / Users

Container Database CDB1 View CDB_USERS

USERNAME COMMON SYS SYSTEM CDBA C##U YES YES YES YES

root

Tablespace EXAMPLE

View DBA_USERS

USERNAME SYS SYSTEM CDBA C##U HR COMMON YES YES YES YES NO

PDB_test

Tablespace EXAMPLE

View DBA_USERS

USERNAME COMMON SYS SYSTEM CDBA C##U HR YES YES YES YES NO

PDB_hr

Tablespace EXAMPLE A common user involves adding a description of that user in the root and in every PDB.

A local user is a traditional user, known only in its own PDB. 38 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Private Database Cloud Model

Database Cloud with PDB  Extreme Schema Consolidation 39 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

2013 LEADER IN IT EDUCATION

According to Industry Analyst Firm IDC

“With an ever-expanding portfolio of tools and applications, Oracle University is strongly oriented toward the individual learner.” “Of the vendors evaluated, Oracle is most adept at describing the value of training at multiple parts of the technology deployment life cycle.” “This decentralized control [of the curricula development] helps maximize the relevance of the training offering to the elements that are most useful to end users.” 40 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

One of the World’s Largest Training Organizations

Worldwide classrooms: 200+ in 89 countries Languages supported: 28 Courses: 2000+ Classes per week: 600+, 90+ Virtual Classes On Demand Courses: 100 and growing Students trained per year: 400,000+ Global education partnerships: 500+ Oracle certified professionals: 1.6+ million 41 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Training & Certification for the Entire Stack

ROLE-BASED TRAINING

Architects Implementers Developers Administrators Business Users

WHEN AND HOW YOU NEED IT

In-Class Live Virtual Class Training On Demand Private

VALIDATED BY INDUSTRY-RECOGNIZED CERTIFICATIONS

Oracle Certified Associate Oracle Certified Professional Oracle Certified Expert Oracle Certified Master

42 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

More than 2000 Courses Across 50+ Products

Database Fusion Middleware Applications

• • • • • • • • • • • • • • • Oracle Database 11

g,

Database 10

g,

12

c

Real Application Clusters Grid Infrastructure Enterprise Manager for Database SQL and PL/SQL MySQL Data Warehousing Exadata and Engineered Systems Database Security Data Guard Application Express Embedded Database In-Memory Database Cache Spatial Secure Enterprise Search • • • • • Java Application Server and Infrastructure Exalogic Exalytics Service-Oriented Architecture and Process Management • • • • • • • • WebCenter Business Intelligence Identity Management Developer Tools Data Integration Transaction Processing Enterprise Management Oracle Cloud Services • • • • • • • • • • • • • • • • • • • Fusion Applications Oracle E-Business Suite PeopleSoft Enterprise Siebel JD Edwards EnterpriseOne Hyperion Primavera Application Integration Architecture User Productivity Kit Oracle CRM On Demand JD Edwards World Governance, Risk, and Compliance Management Agile Product Lifecycle Management AutoVue Enterprise Visualization Oracle Policy Automation Demantra ATG Commerce Suite Transportation Management Tutor

Server & Storage Systems

• • • • • • • • • Oracle Solaris Oracle Solaris Cluster Virtualization Linux Security Enterprise Manager Ops Center Sun Oracle Database Machine Sun Servers Sun Storage and Tape

Industries

• • • • • • Communication s Life Sciences Insurance Retail Utilities Higher Education 43 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

160+ Certification Credentials Available

Products Database Administrators, Developers & Architects PL/SQL SQL Oracle Database MySQL RAC & Grid Performance Tuning Middleware Java Development Java Architecture Server & Storage Systems Oracle Solaris Oracle Solaris Cluster Linux Oracle VM Applications Siebel Oracle Hyperion Implementers & Consultants Oracle Database Enterprise Manager RAC Security Data Warehousing WebLogic WebCenter SOA Identity Management Cloud Application Foundation Exadata Exalogic Storage SPARC Pillar Axiom Fusion Applications E-Business Suite User Productivity Kit Oracle Hyperion JD Edwards Siebel CRM PeopleSoft Enterprise PeopleTools Primavera Oracle Cloud

44 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

Contact Oracle University at: Telephone:

800 810 9931 2013 LEADER

or Email:

[email protected]

IN IT EDUCATION

Website:

education.oracle.com

www.oracle.com/cn/education

45 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

46 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted

47 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Confidential - Oracle Restricted