Oracle database 12c release 2 multitenant /

"Govern a scalable, extensible, and highly available enterprise database environment using the practical information contained in this Oracle Press guide. Written by a team of Oracle Masters, Oracle Database 12c Release 2 Multitenant shows, step-by-step, how to deploy and manage multitenant con...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Els, Anton (Oracle Database certified master)
Otros Autores: Špinka, Vít, Pachot, Franck
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2017]
Temas:
Oracle (Computer file)
Database management.
Bases de données > Gestion.
COMPUTERS > Database Management > General.
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Title Page
  • Copyright Page
  • Dedication
  • About the Authors
  • Contents at a Glance
  • Contents
  • Introduction
  • PART I What Multitenant Means
  • 1 Introduction to Multitenant
  • History Lesson: A New Era in IT
  • The Road to Multitenant
  • Schema Consolidation
  • Table Consolidation
  • Server Consolidation
  • Virtualization
  • Multiple Databases Managed by One Instance
  • Summary of Consolidation Strategies
  • The System Dictionary and Multitenant Architecture
  • The Past: Non-CDB
  • Multitenant Containers
  • Multitenant Dictionaries
  • Working with Containers
  • What Is Consolidated at CDB Level
  • Data and Metadata at CDB Level
  • Summary
  • 2 Creating the Database
  • Creating a Container Database (CDB)
  • What About OMF?
  • CDB Creation Options
  • Creating a Pluggable Database
  • Create a New PDB from PDBSEED
  • Create a New PDB Using the Local Clone Method
  • Create a PDB Using SQL Developer
  • Create a PDB Using the DBCA
  • Create a PDB Using Cloud Control
  • Using the catcon.pl Script
  • Summary
  • 3 Single-Tenant, Multitenant, and Application Containers
  • Multitenant Architecture Is Not an Option
  • Non-CDB Deprecation
  • Noncompatible Features
  • Single-Tenant in Standard Edition
  • Data Movement
  • Security
  • Consolidation with Standard Edition 2
  • Single-Tenant in Enterprise Edition
  • Flashback PDB
  • Maximum Number of PDBs
  • Using the Multitenant Option
  • Application Containers
  • Consolidation with Multitenant Option
  • Summary
  • PART II Multitenant Administration
  • 4 Day-to-Day Management
  • Choosing a Container to Work With
  • Managing the CDB
  • Create the Database
  • Database Startup and Shutdown
  • Drop the Database
  • Modify the Entire CDB
  • Modify the Root
  • Managing PDBs
  • Create a New PDB
  • Open and Close a PDB
  • View the State of PDBs
  • View PDB Operation History
  • Run SQL on Multiple PDBs
  • Modify the PDB
  • Drop a PDB
  • Patching and Upgrades
  • Upgrade CDB
  • Plugging In
  • Patching
  • Using CDB-Level vs. PDB-Level Parameters
  • CDB SPFILE
  • PDB SPFILE Equivalent
  • SCOPE=MEMORY
  • Alter System Reset
  • ISPDB_MODIFIABLE
  • Container=ALL
  • DB_UNIQUE_NAME
  • Summary
  • 5 Networking and Services
  • Oracle Net
  • The Oracle Net Listener
  • The LREG Process
  • Networking: Multithreaded and Multitenant
  • Service Names
  • Default Services and Connecting to PDBs
  • Creating Services
  • Create a Dedicated Listener for a PDB
  • Summary
  • 6 Security
  • Users, Roles, and Permissions
  • Common or Local?
  • What Is a User?
  • CONTAINER=CURRENT
  • CONTAINER=COMMON
  • Local Grant
  • Common Grant
  • Conflicts Resolution
  • Keep It Clear and Simple
  • CONTAINER_DATA
  • Roles
  • Proxy Users
  • Lockdown Profiles
  • Disable Database Options
  • Disable Alter System
  • Disable Features
  • PDB Isolation
  • PDB_OS_CREDENTIALS
  • PATH_PREFIX
  • CREATE_FILE_DEST
  • Transparent Data Encryption
  • Setting Up TDE
  • Plug and Clone with TDE
  • TDE Summary
  • Summary

Ejemplares similares