Oracle Database Cloud Service

chirpskulkInternet and Web Development

Nov 3, 2013 (3 years and 7 months ago)

333 views

Copyright

©

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

Confidential
-

Oracle Restricted

1

Is Oracle Database Cloud
Right for You?

Guanglei

Bao

Oracle University Principal Instructor



Copyright

©

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

Confidential
-

Oracle Restricted

3

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.



Copyright

©

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

Confidential
-

Oracle Restricted

4

Program Agenda


Types of Cloud Computing


Public Database Cloud


Private Database Cloud


Copyright

©

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

Confidential
-

Oracle Restricted

5

Types of Cloud Computing


Copyright

©

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

Confidential
-

Oracle Restricted

6

Types of Cloud Computing

Taxonomy



IaaS


DBaaS


PaaS


SaaS

Copyright

©

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

Confidential
-

Oracle Restricted

11

Oracle Clouds

Public and Private


Copyright

©

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

Confidential
-

Oracle Restricted

12

Oracle Clouds


Public



Private


Copyright

©

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

Confidential
-

Oracle Restricted

13

Oracle Database Cloud Service


Copyright

©

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

Confidential
-

Oracle Restricted

14

Oracle Database Cloud Service


Primarily a
PaaS


Does not require operational effort for underlying Oracle Database


Very limited control over parameters and configurations


No standard SQL*Net connectivity



Attributes

Copyright

©

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

Confidential
-

Oracle Restricted

15

Oracle Database Cloud Service


Instant provisioning


Rapid application development (RAD)


Iterative development


Full power of SQL and PL/SQL


Instance business value

Benefits

Copyright

©

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

Confidential
-

Oracle Restricted

16

Oracle Database Cloud Service


Install with a few mouse clicks


Instant provisioning

Copyright

©

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

Confidential
-

Oracle Restricted

17

Oracle Database Cloud Service


Small set of packaged applications


Upper limit on storage


Isolated services

Limitations

Copyright

©

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

Confidential
-

Oracle Restricted

18

Oracle Database Cloud Service

Isolated services

Copyright

©

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

Confidential
-

Oracle Restricted

19

Oracle Database Cloud Service


Small set of packaged applications


Upper limit on storage


Isolated services


Migration costs

Limitations

Copyright

©

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

Confidential
-

Oracle Restricted

20

Oracle Database Cloud Service


Different security lockdown goals


Protect customers’ data


Protect integrity of the service


Prevent hackers from using service to launch attacks

Security precautions

Copyright

©

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

Confidential
-

Oracle Restricted

21

Oracle Database Cloud Service


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

Security precautions

Copyright

©

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

Confidential
-

Oracle Restricted

22

Oracle Database Cloud Service


Should be locked down by default to minimize attack surface


No operating system or file system access


Absolutely no cross schema access

Security precautions

Copyright

©

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

Confidential
-

Oracle Restricted

23

Oracle Database Cloud Service


Small set of packaged applications


Upper limit on storage


Isolated services


Migration costs


Limited access options

Limitations

Copyright

©

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

Confidential
-

Oracle Restricted

24

Oracle Database Cloud Service

Limited access options

Copyright

©

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

Confidential
-

Oracle Restricted

25

Oracle Database Cloud Service


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

Scenarios

Copyright

©

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

Confidential
-

Oracle Restricted

26

Oracle Clouds


Public



Private


Copyright

©

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

Confidential
-

Oracle Restricted

27

Private Database Cloud


Copyright

©

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

Confidential
-

Oracle Restricted

28

Private Database Cloud Model


Infrastructure Cloud


Database Cloud

Consolidation

Copyright

©

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

Confidential
-

Oracle Restricted

29

Private Database Cloud Model


Virtualization


“Push
-
button” deployment


Resource isolation


Not for I/O
-
intensive databases



Infrastructure Cloud

Copyright

©

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

Confidential
-

Oracle Restricted

30

Private Database Cloud Model


RAC One Node


RAC


Pluggable DB


By passing virtualization layer





Database Cloud

Copyright

©

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

Confidential
-

Oracle Restricted

31

Private Database Cloud Model

RAC One Node


Client connections

DB
-
A

DB
-
B

DB
-
C

DB
-
D

DB
-
E

Server 1

Server 2

Server 3

Copyright

©

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

Confidential
-

Oracle Restricted

32

Private Database Cloud Model

RAC One Node

DB
-
A

DB
-
C

DB
-
D

DB
-
E

Server 1

Server 3

DB
-
B

DB
-
B


Client connections

Server 2

Copyright

©

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

Confidential
-

Oracle Restricted

33

Private Database Cloud Model

RAC One Node

DB
-
A

DB
-
C

DB
-
D

DB
-
E

Server 3

DB
-
B

DB
-
B

Server 1

Server 2


Client connections

Copyright

©

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

Confidential
-

Oracle Restricted

34

Private Database Cloud Model


RAC


Extreme Schema Consolidation





Database Cloud

Copyright

©

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

Confidential
-

Oracle Restricted

35

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
;

New Clause:
ENABLE PLUGGABLE DATABASE

PDB

Copyright

©

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

Confidential
-

Oracle Restricted

36

Pluggable Database

Copyright

©

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

Confidential
-

Oracle Restricted

37

Container Database CDB1

root

PDB_test



PDB_hr

Listener/Service



PDB_dev

Listener/Service

Connection to Pluggable Database

PDB

Copyright

©

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

Confidential
-

Oracle Restricted

38

Common and Local Schemas / Users

Container Database CDB1

root




PDB_hr





PDB_test

USERNAME

COMMON

SYS

YES

SYSTEM

YES

CDBA

YES

C##U

YES

View

CDB_USERS

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.

View DBA_USERS

USERNAME

COMMON

SYS

YES

SYSTEM

YES

CDBA

YES

C##U

YES

HR

NO

USERNAME

COMMON

SYS

YES

SYSTEM

YES

CDBA

YES

C##U

YES

HR

NO

View

DBA_USERS

Tablespace

EXAMPLE

Tablespace

EXAMPLE

Tablespace

EXAMPLE

Copyright

©

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

Confidential
-

Oracle Restricted

39

Private Database Cloud Model


Extreme Schema Consolidation





Database Cloud with PDB

Copyright

©

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

Confidential
-

Oracle Restricted

40

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

“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.”

“Of the vendors evaluated, Oracle is most adept at
describing the value of training at multiple parts of the
technology deployment life cycle.”

Copyright

©

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

Confidential
-

Oracle Restricted

41

One of the World’s Largest Training Organizations

Worldwide classrooms:
200+ in 89 countries

Languages supported: 28

Students trained per year:

400,000+

Courses:
2000+

Classes per week:
600+, 90+ Virtual Classes

Global education partnerships:

500+

Oracle certified professionals:
1.6+ million

On Demand Courses:
100 and growing

Copyright

©

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

Confidential
-

Oracle Restricted

42

ROLE
-
BASED TRAINING

VALIDATED BY INDUSTRY
-
RECOGNIZED CERTIFICATIONS


Architects

Implementers

Developers

Administrators

Business Users

WHEN AND HOW YOU NEED IT


Training On Demand

In
-
Class

Live Virtual Class

Private

Training
& Certification for
the Entire
Stack

Oracle
Certified
Master


Oracle
Certified
Expert

Oracle
Certified
Professional

Oracle
Certified
Associate

Copyright

©

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

Confidential
-

Oracle Restricted

43

More than 2000 Courses Across 50+ Products

Database

Fusion Middleware

Applications


Server & Storage
Systems

Industries


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


Oracle Solaris


Oracle Solaris Cluster


Virtualization


Linux


Security


Enterprise Manager
Ops
Center


Sun Oracle Database
Machine


Sun Servers


Sun Storage and Tape


Communication
s


Life Sciences


Insurance


Retail


Utilities


Higher
Education


Copyright

©

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

Confidential
-

Oracle Restricted

44

160+ Certification Credentials Available

Products

Administrators, Developers & Architects

Implementers & Consultants


Database

PL/SQL
SQL

Oracle Database
MySQL

RAC & Grid Performance Tuning

Oracle Database Enterprise Manager

RAC Security

Data Warehousing

Middleware

Java Development Java Architecture

WebLogic

WebCenter

SOA Identity Management

Cloud Application Foundation

Server &

Storage Systems

Oracle Solaris Oracle Solaris Cluster

Linux Oracle VM

Exadata

Exalogic

Storage SPARC

Pillar Axiom

Applications

Siebel

Oracle Hyperion

Fusion Applications E
-
Business Suite

User Productivity Kit Oracle Hyperion

JD Edwards Siebel CRM

PeopleSoft Enterprise
PeopleTools

Primavera Oracle Cloud

Copyright

©

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

Confidential
-

Oracle Restricted

45

2013 LEADER
IN IT EDUCATION

education.oracle.com

Contact Oracle University at:

Telephone:
800 810 9931

or

Email:
OUChina_CN@oracle.com

Website:

www.oracle.com/cn/education

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