SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK EXPERT CONSOLIDATION IN ORACLE DATABASE 12C
SUMMARY
-
Items Found: 534
- Chapter 1: Consolidation as an industry trend
- Consolidation
- End of life announcements-Hardware
- Support policy for Oracle Software
- Different kinds of consolidation
- Virtualization
- Benefits of virtualization
- More virtualization options
- A stepping stone on the way to the cloud
- Cloud computing
- Infrastructure as a Service
- Software as a Service
- Platform as a Service
- The Public Cloud
- The Private Cloud
- Security in the cloud
- Use for the cloud hype
- Automation
- Processes with the potential for automation
- Auditing and securing automated processes
- The importance of standards for support
- Integrating acquisitions and mergers
- How much standardization is needed?
- Standardization of the full stack
- Potential storage standards
- Potential operating system standards
- Potential database standards
- Difficulties with the current operational model
- Changes in the hardware world
- The Linux operating (eco-) system
- A little bit of (UNIX) history
- Enter Linus
- Why is Linux so popular?
- Chapter 2: Oracle 12c New Features
- Changes for Developers
- The Quest for Security and Least Privilege
- Other Improvements
- Changes Relevant to Database Availability
- Brief Introduction to Real Application Clusters
- Brief Introduction to Automatic Storage Management
- Enhancements in the Cluster Layer
- Non-RAC Options to Increase Availability
- Data and Information Lifecycle Management
- Storage Tiers
- Partitioning
- Automatic Data Optimization in Oracle 12c
- Infrastructure Changes
- Database Resident Connection Pool Exposed to Middle Tier
- Copy-on-Write for Cloning Databases
- Deprecation of OEM DB Console
- Shaping of Network Traffic
- Threaded Architecture
- Chapter 3: Supporting Hardware
- Enabling Hardware
- Blades or Rack-Mounted?
- Changes in the Hardware World
- Thoughts About the Storage Backend
- Consolidation Features in Linux
- Non-Uniform Memory Architecture with Intel X86–64
- Control Groups
- Benchmarks
- FIO
- Oracle I/O numbers
- Silly little Oracle Benchmark
- Chapter 4: Supporting Software
- Enabling Software Solutions
- High Availability Considerations
- Disaster Recovery Considerations
- Virtualization Examples
- Oracle Solaris Zones
- Oracle VM Server for x86
- Final Thoughts on Virtualization
- High Availability Example
- Oracle Clusterware HA Framework
- Installing a Shared Oracle RDBMS Home
- Installing the Shared Database Binaries
- Creating the Database
- Registering the Database with Clusterware
- Managing the Database
- Chapter 5: Installing Oracle Linux
- Installing Oracle Linux 6
- Manual Installation
- Anaconda
- Choice of storage devices
- Network configuration
- Time zone settings and root password
- Partitioning
- Boot loader configuration
- Software installation
- Automated installation
- Preparing for PXE booting.
- Making the installation tree available
- Setting up the TFTP server
- Configuring the Dynamic Host Configuration Protocol server
- Considerations for the Kickstart file
- Testing the automated installation
- Preparing for the Oracle Database installation
- Installing additional packages
- Creating the operating system users and groups
- Checking kernel parameters
- The Oracle mount points
- Setting session limits
- Configuring large pages
- Introducing the oracle-rdbms-server preinstall package
- Configuring storage
- Partitioning LUNs
- Configuring dm-multipath
- Chapter 6: Installing the Oracle Database
- Preparing for the installation
- Staging the software
- Preparing your environment variables
- Configuring your graphical user interface
- Installing Oracle Restart
- Interactive installation of Oracle Restart
- Silent installation of Oracle Restart
- Automatic installation of Oracle Restart using RPM
- Installing the Oracle database
- Interactive installation of the RDBMS binaries
- Silent Installation of the Database Software
- Automatic Installation of the Database Software RPM
- Chapter 7: Pluggable Databases
- The consolidated hosting platform before Oracle 12.1
- Pluggable Databases to the rescue
- Guide to rest of chapter
- Implementation details for Pluggable Databases
- Physical structure of a CDB and PDB
- The Pluggable Database
- Creating a Container Database
- Memory considerations for CDBs
- Deciding about storing files
- Using Database Configuration Assistant to create a CDB
- Creating a CDB using scripts
- Exploring the new CDB
- Managing Pluggable Databases
- Creating a Pluggable Database
- Connecting to Pluggable Databases
- Moving within the CDB
- PDB-specific initialization parameters
- Considerations for hosted environments
- Opening and closing PDBs
- Users and roles in the context of a PDB
- Creating common users
- Creating local users
- Common roles
- Local roles
- Playing nicely with others
- Overview of Resource Manager in Oracle 12.1
- Resource Manager for the Container Database
- Resource Manager for the Pluggable Database
- Testing the Resource Plan
- Instance Caging
- Chapter 8: Monitoring the Hosting Platform
- Oracle Enterprise Manager
- Extending Functionality via Plugins
- The Role of the Agent
- The Oracle Management Service
- The Enterprise Manager Repository
- Who Should Look After Enterprise Manager?
- Sizing Considerations
- Installing Cloud Control
- Choosing the Operating System for the Management Host
- Preparing the Linux Operating System
- Installing Enterprise Manager
- The Initial Configuration Steps
- Creating and Managing Enterprise Manager Accounts
- Managing Database Targets
- Deploying an Agent to a New Host
- Getting Agent Software for Different Platforms
- The Manual Target Discovery Process
- Automatic Target Discovery Process
- Support for Pluggable Databases
- Standardized Monitoring
- Incident Management
- Chapter 9: Learning About Data Guard
- An introduction to Oracle Data Guard
- Standby databases: A historical perspective
- Types of standby databases
- The physical standby database
- The snapshot standby database
- The logical standby database
- The transient logical standby database
- The Active Data Guard Option
- Data protection modes
- Maximum Protection Mode
- Maximum Performance mode
- Maximum Availability mode
- Role transitions
- An in-depth view on Data Guard terminology
- New Data Guard features in 12.1
- Better separation of duties for log shipping
- Better support for cascaded destinations
- The Far Sync Standby Feature
- Ability to check for switchover readiness
- Broker configuration can be renamed in place
- Managing and administering Data Guard
- Managing using SQL*Plus
- Management using the Data Guard Broker
- Chapter 10: Implementing Data Guard
- Naming considerations
- Implementing Data Guard on a file system
- Configuring Data Guard with Oracle Managed Files
- Creating a Data Guard Broker configuration
- Listener configuration
- Standby file management
- Configuring redo application delay
- Enabling the configuration
- Changing the protection mode to maximum availability
- Enabling Flashback on the standby
- Completely removing the Broker configuration
- Performing a graceful switchover operation
- Performing a failover operation
- Performing an immediate failover
- Performing a complete failover
- Reinstating the old primary database
- Creating a lights-out configuration using the Broker
- Maintaining archived logs
- Data Guard specifics for Pluggable Databases
- Creating a new Pluggable Database on the primary database
- The effect of plugging in PDBs into the primary
- Unplugging PDBs from the primary
- Dropping a PDB from the primary
- Chapter 11: Backup and Recovery
- An introduction to Backups
- RMAN backups
- The database incarnation
- The Fast Recovery Area
- Logical backups
- Additional technology available
- Noteworthy new RMAN features in Oracle 12.1
- The SYSBACKUP role
- Ability to execute SQL directly in RMAN
- Enhanced over-the-network features
- Point-in-Time Table Recovery
- Taking RMAN backups
- Considerations for the Recovery Catalog
- Configuring the RMAN environment
- Technical aspects around RMAN backups
- Restore and Recovery
- Restoring the server parameter file
- Restoring the control file
- Restoring databases
- The need for testing
- Introduction to Querying RMAN metadata
- Refreshing an environment
- Chapter 12: Upgrading to Oracle 12c
- The upgrade path to Oracle database 12c
- Before you upgrade production
- Upgrading Oracle Restart on the same server
- The upgrade path for Oracle Restart
- Unsetting environment variables
- Performing the Upgrade
- Performing additional post-migration validation
- Using Oracle Restart 12c and previous database releases in parallel
- Upgrading the database
- High level steps
- Performing a database software-only installation
- Running the pre-upgrade tool
- Making a database available for a first test migration
- Performing the upgrade
- Performing necessary post-upgrade steps
- Upgrading the database with the Database Upgrade Assistant
- Consolidating migrated databases
- Updating the compatible parameter
- Checking compatibility
- Plugging the non-CDB into the CDB
- Moving the database into ASM
- Being able to downgrade
- Chapter 1: Consolidation as an industry trend
- Consolidation
- End of life announcements-Hardware
- Support policy for Oracle Software
- Different kinds of consolidation
- Virtualization
- Benefits of virtualization
- More virtualization options
- A stepping stone on the way to the cloud
- Cloud computing
- Infrastructure as a Service
- Software as a Service
- Platform as a Service
- The Public Cloud
- The Private Cloud
- Security in the cloud
- Use for the cloud hype
- Automation
- Processes with the potential for automation
- Auditing and securing automated processes
- The importance of standards for support
- Integrating acquisitions and mergers
- How much standardization is needed?
- Standardization of the full stack
- Potential storage standards
- Potential operating system standards
- Potential database standards
- Difficulties with the current operational model
- Changes in the hardware world
- The Linux operating (eco-) system
- A little bit of (UNIX) history
- Enter Linus
- Why is Linux so popular?
- Chapter 2: Oracle 12c New Features
- Changes for Developers
- The Quest for Security and Least Privilege
- Other Improvements
- Changes Relevant to Database Availability
- Brief Introduction to Real Application Clusters
- Brief Introduction to Automatic Storage Management
- Enhancements in the Cluster Layer
- Non-RAC Options to Increase Availability
- Data and Information Lifecycle Management
- Storage Tiers
- Partitioning
- Automatic Data Optimization in Oracle 12c
- Infrastructure Changes
- Database Resident Connection Pool Exposed to Middle Tier
- Copy-on-Write for Cloning Databases
- Deprecation of OEM DB Console
- Shaping of Network Traffic
- Threaded Architecture
- Chapter 3: Supporting Hardware
- Enabling Hardware
- Blades or Rack-Mounted?
- Changes in the Hardware World
- Thoughts About the Storage Backend
- Consolidation Features in Linux
- Non-Uniform Memory Architecture with Intel X86–64
- Control Groups
- Benchmarks
- FIO
- Oracle I/O numbers
- Silly little Oracle Benchmark
- Chapter 4: Supporting Software
- Enabling Software Solutions
- High Availability Considerations
- Disaster Recovery Considerations
- Virtualization Examples
- Oracle Solaris Zones
- Oracle VM Server for x86
- Final Thoughts on Virtualization
- High Availability Example
- Oracle Clusterware HA Framework
- Installing a Shared Oracle RDBMS Home
- Installing the Shared Database Binaries
- Creating the Database
- Registering the Database with Clusterware
- Managing the Database
- Chapter 5: Installing Oracle Linux
- Installing Oracle Linux 6
- Manual Installation
- Anaconda
- Choice of storage devices
- Network configuration
- Time zone settings and root password
- Partitioning
- Boot loader configuration
- Software installation
- Automated installation
- Preparing for PXE booting.
- Making the installation tree available
- Setting up the TFTP server
- Configuring the Dynamic Host Configuration Protocol server
- Considerations for the Kickstart file
- Testing the automated installation
- Preparing for the Oracle Database installation
- Installing additional packages
- Creating the operating system users and groups
- Checking kernel parameters
- The Oracle mount points
- Setting session limits
- Configuring large pages
- Introducing the oracle-rdbms-server preinstall package
- Configuring storage
- Partitioning LUNs
- Configuring dm-multipath
- Chapter 6: Installing the Oracle Database
- Preparing for the installation
- Staging the software
- Preparing your environment variables
- Configuring your graphical user interface
- Installing Oracle Restart
- Interactive installation of Oracle Restart
- Silent installation of Oracle Restart
- Automatic installation of Oracle Restart using RPM
- Installing the Oracle database
- Interactive installation of the RDBMS binaries
- Silent Installation of the Database Software
- Automatic Installation of the Database Software RPM
- Chapter 7: Pluggable Databases
- The consolidated hosting platform before Oracle 12.1
- Pluggable Databases to the rescue
- Guide to rest of chapter
- Implementation details for Pluggable Databases
- Physical structure of a CDB and PDB
- The Pluggable Database
- Creating a Container Database
- Memory considerations for CDBs
- Deciding about storing files
- Using Database Configuration Assistant to create a CDB
- Creating a CDB using scripts
- Exploring the new CDB
- Managing Pluggable Databases
- Creating a Pluggable Database
- Connecting to Pluggable Databases
- Moving within the CDB
- PDB-specific initialization parameters
- Considerations for hosted environments
- Opening and closing PDBs
- Users and roles in the context of a PDB
- Creating common users
- Creating local users
- Common roles
- Local roles
- Playing nicely with others
- Overview of Resource Manager in Oracle 12.1
- Resource Manager for the Container Database
- Resource Manager for the Pluggable Database
- Testing the Resource Plan
- Instance Caging
- Chapter 8: Monitoring the Hosting Platform
- Oracle Enterprise Manager
- Extending Functionality via Plugins
- The Role of the Agent
- The Oracle Management Service
- The Enterprise Manager Repository
- Who Should Look After Enterprise Manager?
- Sizing Considerations
- Installing Cloud Control
- Choosing the Operating System for the Management Host
- Preparing the Linux Operating System
- Installing Enterprise Manager
- The Initial Configuration Steps
- Creating and Managing Enterprise Manager Accounts
- Managing Database Targets
- Deploying an Agent to a New Host
- Getting Agent Software for Different Platforms
- The Manual Target Discovery Process
- Automatic Target Discovery Process
- Support for Pluggable Databases
- Standardized Monitoring
- Incident Management
- Chapter 9: Learning About Data Guard
- An introduction to Oracle Data Guard
- Standby databases: A historical perspective
- Types of standby databases
- The physical standby database
- The snapshot standby database
- The logical standby database
- The transient logical standby database
- The Active Data Guard Option
- Data protection modes
- Maximum Protection Mode
- Maximum Performance mode
- Maximum Availability mode
- Role transitions
- An in-depth view on Data Guard terminology
- New Data Guard features in 12.1
- Better separation of duties for log shipping
- Better support for cascaded destinations
- The Far Sync Standby Feature
- Ability to check for switchover readiness
- Broker configuration can be renamed in place
- Managing and administering Data Guard
- Managing using SQL*Plus
- Management using the Data Guard Broker
- Chapter 10: Implementing Data Guard
- Naming considerations
- Implementing Data Guard on a file system
- Configuring Data Guard with Oracle Managed Files
- Creating a Data Guard Broker configuration
- Listener configuration
- Standby file management
- Configuring redo application delay
- Enabling the configuration
- Changing the protection mode to maximum availability
- Enabling Flashback on the standby
- Completely removing the Broker configuration
- Performing a graceful switchover operation
- Performing a failover operation
- Performing an immediate failover
- Performing a complete failover
- Reinstating the old primary database
- Creating a lights-out configuration using the Broker
- Maintaining archived logs
- Data Guard specifics for Pluggable Databases
- Creating a new Pluggable Database on the primary database
- The effect of plugging in PDBs into the primary
- Unplugging PDBs from the primary
- Dropping a PDB from the primary
- Chapter 11: Backup and Recovery
- An introduction to Backups
- RMAN backups
- The database incarnation
- The Fast Recovery Area
- Logical backups
- Additional technology available
- Noteworthy new RMAN features in Oracle 12.1
- The SYSBACKUP role
- Ability to execute SQL directly in RMAN
- Enhanced over-the-network features
- Point-in-Time Table Recovery
- Taking RMAN backups
- Considerations for the Recovery Catalog
- Configuring the RMAN environment
- Technical aspects around RMAN backups
- Restore and Recovery
- Restoring the server parameter file
- Restoring the control file
- Restoring databases
- The need for testing
- Introduction to Querying RMAN metadata
- Refreshing an environment
- Chapter 12: Upgrading to Oracle 12c
- The upgrade path to Oracle database 12c
- Before you upgrade production
- Upgrading Oracle Restart on the same server
- The upgrade path for Oracle Restart
- Unsetting environment variables
- Performing the Upgrade
- Performing additional post-migration validation
- Using Oracle Restart 12c and previous database releases in parallel
- Upgrading the database
- High level steps
- Performing a database software-only installation
- Running the pre-upgrade tool
- Making a database available for a first test migration
- Performing the upgrade
- Performing necessary post-upgrade steps
- Upgrading the database with the Database Upgrade Assistant
- Consolidating migrated databases
- Updating the compatible parameter
- Checking compatibility
- Plugging the non-CDB into the CDB
- Moving the database into ASM
- Being able to downgrade
