Table of Contents
- List of Figures
- Title and Copyright Information
- Preface
-
Part I Introduction to Enterprise Manager Database Lifecycle Management
- 1 Introduction to Database Lifecycle Management
-
2
Setting Up Your Infrastructure
- Getting Started with Setting Up Your Infrastructure
- Setting Up Oracle Software Library
- Setting Up Credentials
- Creating Enterprise Manager User Accounts
- (Optional) Setting Up My Oracle Support
- (Optional) Configuring Self-Update
- (Optional) Setting Restricted Accesses for the Root Components
- (Optional) Deploying Agents on OCI Resources
- (Optional) Setting a PAM User Account
-
Part II Database Provisioning
-
3
Overview of Database Provisioning
- Introduction to Database Provisioning
- Supported Use Cases and Targets Provisioned Using Database Provisioning Procedures
-
Setting Up Database Provisioning
- Meeting Basic Infrastructure and Host Requirements
- Understanding Administrator Privileges for Provisioning Database
- Prerequisites for Designers
- Prerequisites for Operators
- Creating Database Provisioning Profiles
- Viewing, Creating, and Deleting Database Provisioning Profiles Using EMCLI
- Creating Installation Media
- Creating Database Templates
- Uploading Database Templates to Software Library
- Pre/Post Scripts for Database Provisioning
- Creating Database Provisioning Entities
- Downloading Cluster Verification Utility
-
4
Creating and Provisioning Oracle Databases
- Oracle Database Topology
- Creating Databases
- Provisioning Databases
- 5 Provisioning Oracle Grid Infrastructure for Oracle Databases
-
6
Provisioning Oracle Grid Infrastructure for Oracle Real Application Clusters Databases
- Getting Started with Provisioning Grid Infrastructure for Oracle RAC Databases
- Oracle Real Application Clusters Database Topology
- Oracle Flex Clusters and Flex ASM
- Provisioning Grid Infrastructure with Oracle Real Application Clusters Database and Configuring Database with Oracle Automatic Storage Management
- Provisioning Oracle Real Application Clusters Database with File System on an Existing Cluster
- Provisioning Oracle Real Application Clusters Database with File System on a New Cluster
- Using No Root Credentials for Provisioning Oracle Real Application Clusters (Oracle RAC) Databases
- 7 Provisioning Oracle Real Application Clusters One (Oracle RAC One) Node Databases
-
8
Provisioning Oracle Real Application Clusters
- Getting Started with Provisioning Oracle Real Application Clusters for 12c and 18c
- Core Components Deployed When Provisioning Oracle RAC
- Cloning a Running Oracle Real Application Clusters
- Provisioning Oracle Real Application Clusters Using Gold Image
- Provisioning Oracle Real Application Clusters Using Archived Software Binaries
- Provisioning Oracle Real Application Clusters (Oracle RAC) Databases Using No Root Credentials
- 9 Extending Oracle Real Application Clusters
- 10 Deleting or Scaling Down Oracle Real Application Clusters
- 11 Provisioning Oracle Database Replay Client
-
12
Provisioning Oracle Standby Databases
- Overview of Creating a Standby Database
-
Creating a New Physical Standby Database (single-instance only)
- Step 1: Determine the backup type
- Step 2: Set up the backup options
- Step 3: Select the Oracle home in which to create the standby database
- Step 4: Set up the location for standby database files
- Step 5: Provide standby database configuration parameters
- Step 6: Review the information before clicking Finish
-
Creating a New Logical Standby Database (single-instance only)
- Step 1: Determine the backup type
- Step 2: Set up the backup options
- Step 3: Select the Oracle home in which to create the standby database
- Step 4: Set up the location for standby database files
- Step 5: Provide standby database configuration parameters
- Step 6: Review the information before clicking Finish
- Managing an Existing Standby Database with Data Guard Broker
- Creating a Primary Database Backup Only
- Data Guard
- Fast-Start Failover REST API
-
13
Managing Pluggable Databases Using Enterprise Manager
- Getting Started With Managing Pluggable Databases Using Enterprise Manager
- Overview of Managing Pluggable Databases Using Enterprise Manager
- Provisioning Pluggable Databases Using Enterprise Manager
- Relocating Pluggable Databases Using Enterprise Manager
- Removing Pluggable Databases Using Enterprise Manager
- Viewing Pluggable Database Job Details Using Enterprise Manager
- Administering Pluggable Databases Using Enterprise Manager
- 14 Cloning Oracle Databases and Pluggable Databases
-
15
About Deployment Procedures
- Overview of the Provisioning Page
- Granting Roles and Privileges to Administrators
- Components of a Procedure
- Creating a Procedure
-
Managing Deployment Procedures
- Viewing, Editing, Deleting a Procedure
- Editing and Saving Permissions of a Procedure
- Tracking the Procedure Execution and Status of Deployment Procedures
- Rescheduling a Procedure
- Reverting a Procedure
- Setting Step Level Grace Period
- Creating, Saving, and Launching User Defined Deployment Procedure (UDDP)
-
Procedure Instance Execution Page
- Comparison Between the Existing Design and the New Design for Procedure Instance Execution Page
- Overview of the Procedure Instance Execution Page
- Investigating a Failed Step for a Single or a Set of Targets
- Retrying a Failed Step
- Creating an Incident Dump
- Viewing the Execution Time of a Deployment Procedure
- Searching for a Step
- Downloading a Step Output
- Accessing the Job Summary Page
-
3
Overview of Database Provisioning
-
Part III Database Maintenance: Updates (Patching) and Upgrades
- 16 Database Maintenance Concepts
-
17
Getting Started with Updates (Patching) and Upgrades
- Overview of Updates and Upgrades
-
Before you begin: Meeting the Prerequisites
- Meeting Basic Infrastructure Requirements for Patching
- User Roles and Privileges for Fleet Maintenance
- Preferred Credential Support for Fleet Maintenance
- Searching for Patches on My Oracle Support
- Search and View Patches in Oracle Software Library
- Downloading Patch Recommendations and Patches
- Security Models for running Root scripts
- Prerequisites for performing Fleet Maintenance on Windows
-
18
Database Updates and Upgrades Using Fleet Maintenance
- Get Organized With Standardization Advisor
- Use Fleet Maintenance Hub to get to Patch Compliance
- Patch Recommendations
- Image Maintenance
- Update Operations
- Fleet Maintenance Automation
- Patch History
- 19 Upgrade databases and Grid Infrastructure Using Fleet Maintenance
- 20 Oracle Fleet Patching and Provisioning and Enterprise Manager Integration
- 21 Patch Exadata PDBs Using Fleet Maintenance
- 22 Patching End-to-End Use Cases
-
Part IV Manage Configuration, Compliance and Change
Management
-
23
Manage Configuration Information
- Configuration Management
-
Comparisons
- About Comparisons
-
Get Started Using Comparisons
- Creating or Editing a Comparison Template
- Set Up a Comparison Template
- Managing Comparison Templates
- Considerations Before Creating a Comparison
- Set Up a Drift or Consistency Comparison
- Create Notifications for Comparisons
- Exclude Target To Be Compared In a Template
- Exclude Target To Be Compared From Reference Target
- Oracle Home Consistency With Target Properties
- Get Started Using Rules
- Work with Comparison Results
- Comparisons and Drift Management with Oracle Enterprise Manager
- Compare Configurations with Scripts
- Configuration Searches
- Configuration Browser
- Configuration History
-
Configuration Extensions and
Collections
-
Working with Configuration Extensions
- Creating a Custom Target Type
- Creating or Editing a Configuration Extension
- Using the Files & Commands Tab
- Using the SQL Tab
- Setting Up Credentials When Creating a Configuration Extension
- Setting Up Rules
- Managing Configuration Extensions
- About Configuration Extensions and Versioning
- About Configuration Extensions and Privileges
- About Configuration Extensions and Deployment
- Extending Configuration Data Collections
-
Working with Configuration Extensions
-
Configuration Topology Viewer
- About Configuration Topology Viewer
- Examples of Using Topology
- Viewing a Configuration Topology
- Determining System Component Structure
- Determining General Status of Target's Configuration Health
- Getting Configuration Health/Compliance Score of a Target
- Analyzing a Problem and Viewing a Specific Issue in Detail
- About Dependency Analysis
- About Impact Analysis
- Creating a Custom Topology View
- Deleting a Custom Topology View
- Excluding Relationships from a Custom Topology View
- Including Relationships to a Target in a Custom Topology View
- Creating a Relationship to a Target
- Deleting a Relationship from a Target
- Controlling the Appearance of Information on a Configuration Topology Graph
-
Parsers
- Managing Parsers
- About XML Parsers
-
About Format-Specific Parsers
- Database Query Parser Parameters
- Database Query Paired Column Parser Parameters
- Directory Parser Parameters
- E-Business Suite Parser Parameters
- Galaxy CFG Parser Parameters
- MQ-Series Parser Parameters
- Siebel Parser Parameters
- Unix Installed Patches Parser Parameters
- Unix Recursive Directory List Parser Parameters
- About Columnar Parsers
- About Properties Parsers
- Using Parsed Files and Rules
- Relationships
-
24
Manage Compliance
- Overview of Compliance Management
-
Configure Compliance Management
- About Compliance Frameworks
-
Operations on Compliance Frameworks
- Creating a Compliance Framework
- Creating Like a Compliance Framework
- Editing a Compliance Framework
- Deleting a Compliance Framework
- Exporting a Compliance Framework
- Importing a Compliance Framework
- Browsing Compliance Frameworks
- Searching Compliance Frameworks
- Browsing Compliance Framework Evaluation Results
- Searching Compliance Framework Evaluation Results
- Browsing Compliance Framework Errors
- Searching Compliance Framework Errors
- Verifying Database Targets Are Compliant with Compliance Frameworks
- About Compliance Standards
-
Operations on Compliance Standards
- Creating a Compliance Standard
- Associating a Compliance Standard
- Self Update for Compliance Standards
- Create Like for Compliance Standards
- Editing a Compliance Standard
- Deleting a Compliance Standard
- Exporting a Compliance Standard
- Importing a Compliance Standard
- Browsing Compliance Standards
- Searching Compliance Standards
- Browsing Compliance Standard Evaluation Results
- Searching Compliance Standard Evaluation Results
- Browsing Compliance Standard Errors
- Searching Compliance Standard Errors
- Associating a Compliance Standard with Targets
- Associating a Compliance Standard with a Group Target
- Enabling Security Metrics
- Considerations When Creating Compliance Standards
- About Compliance Standard Rule Folders
- About Compliance Standard Rules
-
Operations on Compliance Standards Rules
- Creating a Repository Compliance Standard Rule
- Creating an Agent-side Rule
- Creating a Manual Rule
- Creating a Missing Patches Compliance Standard Rule
- Creating a Configuration Consistency Rule
- Creating Configuration Drift Rule
- Creating Like a Compliance Standard Rule
- Editing a Compliance Standard Rule
- Deleting a Compliance Standard Rule
- Exporting a Compliance Standard Rule
- Importing a Compliance Standard Rule
- Browsing Compliance Standard Rules
- Searching Compliance Standard Rules
- Using Corrective Actions
-
Evaluate Compliance
- Access Compliance Statistics
- View Compliance Summary Information
- View Target Compliance Evaluation Results
- View Compliance Framework Evaluation Results
- Manage Violations
- Investigate Compliance Violations and Evaluation Results
- Investigate Evaluation Errors
- Analyze Compliance Reports
- Overview of Compliance Score and Importance
- About the Compliance Dashboard
- Examples
- 25 Manage Database Schema Changes
-
23
Manage Configuration Information
-
Part V Database Security
- 26 Managing Oracle Audit Vault and Database Firewall
- 27 Using Oracle Data Redaction
- 28 Managing Oracle Database Vault and Privilege Analysis
- 29 Managing Oracle Transparent Data Encryption
- 30 Managing Enterprise Data Governance
-
A
Appendixes
- Checking Host Readiness Before Provisioning or Patching
-
Using Enterprise Manager Command Line Interface
- Overview
-
Provisioning Using EM CLI
- Creating the Properties File to Submit a Deployment Procedure
- Using Properties File from an Existing Execution of a Deployment Procedure
- Launching a Procedure using an Existing Saved Procedure
- Provisioning Pluggable Databases
- WorkFlow Examples Using EM CLI Commands
- Using emctl partool Utility
-
Troubleshooting Issues
- Troubleshooting Patching Issues
- Oracle Fleet Patching and Provisioning: Diagnostic and Troubleshooting
-
Troubleshooting Database Provisioning Issues
- Grid Infrastructure Root Script Failure
- SUDO Error During Deployment Procedure Execution
- Prerequisites Checks Failure
- Oracle Automatic Storage Management (Oracle ASM) Disk Creation Failure
- Oracle ASM Disk Permissions Error
- Specifying a Custom Temporary Directory for Database Provisioning
- Incident Creation When Deployment Procedure Fails
- Reading Remote Log Files
- Retrying Failed Jobs
- Refreshing Configurations
- Reviewing Log Files
- Index