| Description |
1 online resource |
| Contents |
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 |
| Summary |
"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 configurations across IT frameworks of all types and sizes. Find out how to create databases, work with PDBs and CDBs, administer Oracle Net Services, and automate administrative tasks. Backup and recovery, security, and advanced multitenant options are covered in complete detail. Learn how to: - Build high-performance multitenant Oracle databases - Create single-tenant, multitenant, and application containers - Establish network connections and manage services - Handle security using authentication, authorization, and encryption - Back up and restore your mission-critical data - Work with point-in-time recovery and Oracle Flashback - Move data and replicate and clone databases - Work with Oracle's Resource Manager and Data Guard"-- Provided by publisher |
| Notes |
"Oracle." |
|
"Version 1.0." |
|
Print version record |
| SUBJECT |
Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760
|
|
Oracle (Computer file) fast |
| Subject |
Database management.
|
|
COMPUTERS -- Database Management -- General.
|
|
Database management
|
| Form |
Electronic book
|
| Author |
Špinka, Vít.
|
|
Pachot, Franck.
|
| LC no. |
2017000229 |
| ISBN |
9781259836107 |
|
125983610X |
|
