oracle database 12c release 2 -...
TRANSCRIPT
Oracle Database 12c Release 2
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Bob ZeollaOracle Education & Research
Confidential – Oracle Internal/Restricted/Highly Restricted
Oracle Database 12c (12.1.0.1)
� Oracle Multitenant
� Oracle Automatic Data Optimization
� Data Guard Far Sync
Application Continuity
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
� Application Continuity
� Data Redaction
Oracle Database 12c (12.1.0.2)
• Oracle Database In-memory
• Oracle Database for the
Developer (JSON)
Oracle Big Data SQL
• Performance Improvements
• Advanced Index Compression
• Full Database Caching
• Zone Maps and Attribute
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Oracle Big Data SQL
• Oracle Multitenant
Improvements
• Oracle Key Vault
• AWR Warehouse
• Zone Maps and Attribute
Clustering
• Approximate Count Distinct
• Zero Data Loss Recovery
Appliance
• Rapid Home Provisioning
Oracle Database 12cR2 (12.2.0.1)
Performance Improvements
• Oracle Database In-memory
• In-memory on Active Data Guard
• In-memory JSON Queries
Security Improvements
• Online Tablespace Encryption
• DB Vault Simulation Mode
• Key Vault - Hybrid Cloud Key
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• In-memory JSON Queries
• In-memory Fast Start
• Index Compression High
• Key Vault - Hybrid Cloud Key
Management
Oracle Database 12cR2 (12.2.0.1)
For Developers
• Case Insensitive DB Support
• Long Identifiers (up to 128 bytes)
• Globalization Support (AL32UTF8 is default
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Globalization Support (AL32UTF8 is default
character set)
• Real Time MVs
• JSON DataGuide – Automatic Schema Inference
• Oracle SODA (Simple Oracle Document Access)
Oracle Database 12cR2 (12.2.0.1)
Multitenant Improvements
• PDBs per Container increased (252 to 4096!)
• Memory resource prioritization in addition to CPU
and I/O
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
and I/O
• PDB Hot Clone
• PDB Incremental Refresh
• PDB Relocate
• Application Container
Database Support Roadmap
Today 6/15/2017
End of 11gR2 Free ES 12/2018
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
End of 12cR1 Free ES 7/2019
End of 12cR2 Premier Support 3/2022
“C” = Cloud!
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Common Higher Education Use Cases
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Big Data & Business
Intelligence
Big Data & Business
IntelligenceDisaster RecoveryDisaster Recovery Tiered StorageTiered StorageApplicationsApplicationsDev & TestDev & Test
• Automate: Utilize tooling to build
templates for effortless provisioning of
Environments
• Scale elastically: Meet student needs
during peak utilization windows such as
Improve Existing Process and Capacity
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
during peak utilization windows such as
Registration and Add/Drop
• Effective Dev and Test: Quickly and
efficiently create non-production copies
of production for QA, Dev, Test and
Training
• Easy Adoption: Compatible with all
existing Banner customizations and
baseline code modifications
• Real time Reporting: Maintain access
to your data to make business decisions
Reduce Time to Value
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
to your data to make business decisions
on your own terms
• Integrations: Continue to support
communication with other third party
systems
Infrastructure as a Service (IaaS)
• Bring your own license (BYOL)
Platform as a Service (PaaS)
• Included in the subscription cost:
Licensing and Support Cloud Considerations
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Included in the subscription cost:
– Database licenses and support costs
– Database options such as: Real
Application Clusters, Advanced
Security, Multitenant, Partitioning,
Active Dataguard, Real Application
Testing and EM packs
Database
Oracle Cloud Services Portfolio
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Oracle Cloud Services Portfolio
Oracle Cloud Reference Architecture
SaaS
Applications
Platform Services
Applications
Middleware
On PremisePublic Cloud
Enterprise Resource Planning
Human Capital Mgmt
Customer Experience
Enterprise Perf Mgmt
SocialSupply Chain Mgmt
Java Process Mobile BIBig Data
Discovery
Ide
ntity
an
d S
ecu
rity S
erv
ices
En
terp
rise
& C
lou
d
Se
rvic
e M
an
ag
em
en
t
MessagingCloud Service
IntegrationServices
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
PaaS
IaaS
Infrastructure Services
Databases
Infrastructure
Discovery
Database Cloud Service
Big Data Cloud Service
Compute Storage Network
Exadata Cloud
Service
Big Data Appliance
Cloud Service
Ide
ntity
an
d S
ecu
rity S
erv
ices
En
terp
rise
& C
lou
d
Se
rvic
e M
an
ag
em
en
t
IntegrationCloud Service
IntegrationServices
Oracle IaaS – Compute
RavelloContainer
ServiceEngineered Sys.,
Cloud@ CustomerDedicated
Compute, SPARCGeneral Purpose
ComputeBare Metal Cloud
Services
Multiple OS
Bare Metal, VMs
On-Premise
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Public Cloud
Compute
Multiple OSOn-Premise
Extensive choice of compute options, including Bare Metal, VMs, Containers and Dedicated Compute
Oracle IaaS – Storage
Bulk Data Transfer Services
Storage Cloud Software Appliance
Database BackupArchive StorageObject Storage
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Extensive choice of Object, Block, Archival and Backup storage solutions
POSIX NFS
SMB
WebDav
Near Local NAS
Oracle PaaS
DATA MANAGEMENT
• Database• NoSQL Database• Big Data• Big Data SQL
• Big Data Preparation• Database Backup• Exadata
IT OPERATIONS MANAGEMENT
• IT Analytics• Log Analytics
APPLICATION DEVELOPMENT
• Java • Application Container
(Node, Java SE)
• Application Builder• Developer• Mobile
INTEGRATION
• Integration• SOA• API Manager
• Internet of Things• GoldenGate• ETL
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Log Analytics• Application Performance Monitoring
IDENTITY MANAGEMENT & SECURITY
• Identity
CONTENT & PROCESS
• Documents• Social
• Process• Sites
• API Manager • ETL
MOBILE
• Mobile• Integration
• Internet of Things
BUSINESS ANALYTICS
• Data Visualization• Business Intelligence• Big Data Discovery
• Big Data Preparation• Internet of Things
• CASB
Sample Architecture
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Sample Architecture
Banner 9/XEApplication Server Tier
Weblogic/Tomcat
Banner 8Application Server Tier
Internet Native Banner (INB) Self-Service Banner (SSB)
Host 1 Host 2 Host 3 Host 4
Central Authentication Services (CAS)
Sample Ellucian Banner ArchitectureAncillary Services Core Infrastructure
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Application Server TierLegacy
Data Tier
Oracle Forms and Reports WebLogic OFM 11.1.2.1, 11.1.2.2
Oracle Application Server WebLogic OFM 11.1.1.7 , 11.1.1.9
Banner Database
Job Submission
DB Standby
Needs Analysis
Banner 9/XEApplication Server Tier
Weblogic/Tomcat
Banner 8Application Server Tier
Internet Native Banner (INB) Self-Service Banner (SSB)
Host 1 Host 2 Host 3 Host 4
Central Authentication Services (CAS)
Sample Ellucian Banner ArchitectureAncillary Services Core Infrastructure
IaaSIaaS
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Application Server TierLegacy
Data Tier
Oracle Forms and Reports WebLogic OFM 11.1.2.1, 11.1.2.2
Oracle Application Server WebLogic OFM 11.1.1.7 , 11.1.1.9
Banner Database
Job Submission
DB Standby
Needs Analysis
Banner 9/XEApplication Server Tier
Weblogic/Tomcat
Banner 8Application Server Tier
Internet Native Banner (INB) Self-Service Banner (SSB)
Host 1 Host 2 Host 3 Host 4
Central Authentication Services (CAS)
Sample Ellucian Banner ArchitectureAncillary Services Core Infrastructure
PaaSPaaS
IaaSIaaS
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Application Server TierLegacy
Data Tier
Oracle Forms and Reports WebLogic OFM 11.1.2.1, 11.1.2.2
Oracle Application Server WebLogic OFM 11.1.1.7 , 11.1.1.9
Banner Database
Job Submission
DB Standby
Needs Analysis
Deployment Scenarios
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Deployment Scenarios
Run all workloads from the Cloud
• Elasticity for peak loads like add/drop and registration
• Easily scale with you
• Facilitates upgrades
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• No substantial conversion requirements
• Compatible with all existing tools and integrations
Non-Prod in the CloudProduction on Premise
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Maintain existing production environment on premise
• Relocate or Rebuild non-production tiers in OPC
• Reduce physical footprint in on premise datacenters
• Take advantage of cloning and orchestrations to facilitate DevOps
• Quickest MTTR: Failover to live standby
environment, rather then restoring from tape,
finding resources, and recovering databases.
• Secure: Support for encryption on the wire and
at rest.
Disaster Recovery in OPC
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Switchover: Transition to the cloud and back as
needed.
• Manageability: Continue to administer from a
single pain of glass (Enterprise Manager) without
the need for third party tools.
Replication
Dblink/Materialized Views, Active Dataguard, GoldenGate
Hybrid for ReportingIf latency/bandwidth is a concern, consider a hybrid approach with
and active Dataguard standby remaining on premise.
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Oracle Public Cloud
Primary Banner OLTP
Optional Bi-Directional
Client Reporting Access
On Premise Data Center
Reporting Instance/ODS
Pa
aS
4 OCPUs/30GB Memory
Database CS - EE
Sample Banner in Oracle Public CloudProduction BannerProduction Banner
1 OCPUs/7.5GB Memory
Database CS - EE High Perf
NonNon--Prod BannerProd Banner
6 x 1 OCPUs/7.5GB Memory
Java CS – Weblogic EE
WeblogicWeblogic App tierApp tier
Pa
aS
4 x 1 OCPUs/15GB Memory
1 OCPUs/7.5GB Memory
Database CS - EE High Perf
1 OCPUs/7.5GB Memory
Java CS – Weblogic EE
Banner App tierBanner App tier
WeblogicWeblogic App tierApp tier
Production BannerProduction Banner
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Iaa
S
6 x 2 OCPUs/15GB Memory
6 x 2 OCPUs/15GB Memory
Elastic Compute
Primary @ Primary @
Reston, VA DCReston, VA DC
VPN Encrypted TrafficVPN Encrypted Traffic
Banner App tierBanner App tier
Java CS – Weblogic EE
3TB a mon
Object Storage CS
Iaa
S
4 x 1 OCPUs/15GB Memory
Elastic Compute
DR @DR @
Chicago DCChicago DC
3TB a mon
Object Storage CS
BackupsBackups
BackupsBackups
On Campus @On Campus @
Your Institution
Deployment TimelineSample Banner Implementation Schedule
1-3 months 3-6 months 6-9 months 9+ months
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Initial IaaS/PaaS Config
• VPN Setup
• Establish Cloud based
DR using Dataguard
• Solution Manager
Configuration
• XE Module Testing
• Non-production
Environment Migration
to OPC
• Production
Deployment
• Switchover DG roles for
Standby on premise
Migration Paths
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Migration Paths
Ellucian Solution Manager Compatible
• ESM and Jenkins deployments are compatible with Oracle Compute
• Utilize “OS Installed” methodology for provisioning New Environments
• OPC Compute Orchestrations for rapid deployment of new hosts with customer package lists, storage, security lists
Os Installed Method
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
OPC Compute Orchestrations for rapid deployment of new hosts with customer package lists, storage, security lists
• Ephemeral Snapshots for guest for quick backup and restores
• Storage volume snapshots for important volumes (eg. Banner Home tree)
Migrating Ellucian Banner to OPC – Best Practices
1. Deploy Ellucian Solution Manager to Compute
2. Deploy Remaining Compute shapes
3. Deploy Seed environment from ESM to Compute
Deployment Guide Coming Soon
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
3. Deploy Seed environment from ESM to Compute
4. Copy Banner Home from On Premise to OPC based jobsub server
5. Copy any modified fmb/fmx for INB
6. Copy and modified html, css, javascript for SSB
7. Lift and Shift Data – expdp, pdb unplug/plug, rman duplicate
8. Test
Image Import Method
• Create OVM from existing hosts on premise
• Create expdp from existing database host
• Instantiate new Compute guests from imported images
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
• Install database home
• Impdp database
• Modify values similar to standard Prod -> Non-prod refresh mechanism
• Test and Verify
Higher Education Adoption Testimonials
Valdosta State University – Student Retention Short Long
Shawnee State University – Modernization
Shawnee State University – Student Retention
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
San Bernardino Community College System – Business Process Improvement
Concordia University – PaaS DBCS and JCS Adoption
Boise State University – BI Cloud for Student Retention
Rutgers University – SaaS Modernization
Higher Education Adoption Example
Stanford University
Use Case:
• Uses PeopleSoft Campus Solutions and
Enterprise Portal
• Needed to ensure that the application
systems function flawlessly during peak
demand (registration)
Solution:
• A single cloud based-solution to help them to
more quickly detect, isolate and recover from
application performance issues.
• Oracle Cloud Management Services
• Application Performance Monitoring
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
demand (registration)
• Use complex clustered system to handle
load
• Used a variety of tools to monitor and
troubleshoot components of the
technology stack
• Without adequate perspective of end
user experience
• Application Performance Monitoring
• Log Analytics
• Improved visibility on application usage,
availability and performance from an end-
user's perspective.
• OMC's unified data platform with machine
learning also delivers rapid, end-to-end
diagnosis for their student- and staff-facing
applications.