Table of Contents
- List of Figures
- Title and Copyright Information
- Preface
-
Part I Introduction to Enterprise Manager Lifecycle Management
- 1 Introduction to 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
- Deploying Agents on OCI Resources
- (Optional) Setting Up My Oracle Support
- (Optional) Configuring Self-Update
- (Optional) Setting Up E-mail Notifications
- (Optional) Setting Restricted Accesses for the Root Components
-
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
- 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 for 12c and 18c
- 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
-
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 Database High Availability REST API
- 16 Fast-Start Failover REST API
-
17
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
- Viewing the Execution Time of a Deployment Procedure
- Searching for a Step
- Downloading a Step Output
- Accessing the Job Summary Page
-
18
Customizing Deployment Procedures
- About Deployment Procedure Customization Types
-
Customizing a Deployment Procedure
- Editing the Rolling and Parallel Phase of a Deployment Procedure
- Editing a Job Step of a Deployment Procedure
- Editing a Directive Step of a Deployment Procedure
- Editing a Component Step of a Deployment Procedure
- Editing a File Transfer Step of a Deployment Procedure
- Editing a Host Command Step of a Deployment Procedure
- Editing a Manual Step of a Deployment Procedure
-
A Workflow Example for Assigning Values to Deployment Procedure Variables at Runtime
- Step 1: Creating a Perl Script to Assign Values to Deployment Procedure Variables at Runtime
- Step 2: Uploading TestPingAndDPvariable.pl to Software Library
- Step 3: Creating a Deployment Procedure
- Step 4: Launching the Deployment Procedure, and Providing the Variable Values at Runtime
- Step 5: Verifying the Deployment Procedure Variable Values
- Changing Deployment Procedure Error Handling Modes
- Setting Up email Notifications Regarding the Status of Deployment Procedures
- Copying Customized Provisioning Entities from One Enterprise Manager Site to Another
- A Workflow Example for Customizing a Directive
-
3
Overview of Database Provisioning
- Part III Database Upgrade
-
Part IV Patch Management
-
20
Database Fleet Maintenance
- About Database Fleet Maintenance
-
Getting Started with Fleet Maintenance
- Meeting the Prerequisites
- User Roles and Privileges for Fleet Maintenance
- Discovering Configuration Pollution
- Custom Pre and Post Scripts for Fleet Operations
-
Image and Subscription Tasks
- Creating a Gold Image
- Migrating Fleet Maintenance Gold Images between Enterprise Manager Deployments
- Retrieving a List of Available Gold Images
- Verifying if Image is Applicable
- Deleting an Image or Versions of an Image
- Subscribing the Targets to the Selected Image
- Verifying the Subscription
- Unsubscribing Targets from an Image
- Creating an Updated Version of the Image
- Changing Version Status to Current
- Fleet Maintenance Software Operations
- Database Fleet Maintenance - RESTful APIs
-
21
Patching Software Deployments
- Overview of the New Patch Management Solution
-
Setting Up the Infrastructure for Patching
- Meeting Basic Infrastructure Requirements for Patching
- Creating Administrators with the Required Roles for Patching
- Setting Up the Infrastructure for Patching in Online Mode (Connected to MOS)
- Setting Up the Infrastructure for Patching in Offline Mode (Not Connected to MOS)
- Analyzing the Environment and Identifying Whether Your Targets Can Be Patched
- Identifying the Patches to Be Applied
- Root Components for Fleet Maintenance
-
Applying Patches
- Creating a Patch Plan
- Accessing the Patch Plan
- Analyzing, Preparing, and Deploying Patch Plans
- Switching Back to the Original Oracle Home After Deploying a Patch Plan
- Saving Successfully Analyzed or Deployed Patch Plan As a Patch Template
- Creating a Patch Plan from a Patch Template and Applying Patches
- Patching Oracle Grid Infrastructure Targets
- Patching Grid Infrastructure and Databases on Oracle Exadata
- Patching Oracle Data Guard Targets
- Patching Oracle Identity Management Targets
- Patching Oracle Siebel Targets
- Patching Oracle Service Bus
- Rollback of Oracle Service Bus Patch
- Deploying WebLogic Patches Along with SOA or Oracle Service Bus Patches In A Single Patch Plan
- Diagnosing and Resolving Patching Issues
-
Additional Patching Tasks You Can Perform
- Viewing or Modifying a Patch Template
- Saving a Deployed Patch Plan as a Patch Template
- Downloading Patches from a Patch Template
- Deleting a Patch Plan
- Deleting a Patch Template
- Converting a Nondeployable Patch Plan to a Deployable Patch Plan
- Associating Additional Targets to a Patch in a Patch Plan
- Manually Staging the Patching Root Component
- Restricting Root User Access for Patching
- Resolving Patch Conflicts
- Analyzing the Results of Patching Operations
- Customizing Patching Deployment Procedures
- Pausing the Patching Process While Patching Targets in Rolling Mode
- Rolling Back Patches
- End-to-End Use Case: Patching Your Data Center
- Patching Database as a Service Pools
-
20
Database Fleet Maintenance
- Part V Database Migration
-
Part VI Manage Configuration, Compliance and Change
Management
-
26
Manage Configuration Information
- Configuration Management
- Comparisons
- 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
- Using Configuration Extensions as Blueprints
-
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
-
27
Manage Compliance
- Overview of Compliance Management
-
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
- Evaluate Compliance with Oracle Enterprise Manager 13c Release 4 Update 5 (13.4.0.5) and Above
- Investigate Real-time Observations
-
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
- Creating Like a Compliance Standard
- 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
- Viewing Real-time Monitoring Compliance Standard Warnings
- 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 a Real-time Monitoring 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
- Real-time Monitoring Facets
- Examples
- 28 Manage Database Schema Changes
- 29 Overview of Change Activity Planner
-
26
Manage Configuration Information
-
Part VII Database Security
- 30 Managing Oracle Audit Vault and Database Firewall
- 31 Using Oracle Data Redaction
- 32 Managing Oracle Database Vault and Privilege Analysis
- 33 Managing Oracle Transparent Data Encryption
- 34 Managing Enterprise Data Governance
-
A
Appendixes
- Checking Host Readiness Before Provisioning or Patching
-
Using Enterprise Manager Command Line Interface
- Overview
- Enterprise Manager Command Line Interface Verbs
- Prerequisites
-
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
- Patching Using EM CLI
-
WorkFlow Examples Using EM CLI Commands
- Provisioning Oracle Database Software
- Provisioning Oracle WebLogic Server
- Provisioning User Defined Deployment Procedure
- Patching WebLogic Server Target
- Creating a New Generic Component by Associating a Zip File
- Migrate and Remove a Software Library Storage Location
- Adding ATS Service Test from Using EM CLI
- Limitations of Using Enterprise Manager Command Line Interface
- Using emctl partool Utility
-
End-to-End Use Case: Patching Your Data Center
- The Challenge of Patching Your Data Center
- The Enterprise Manager Solution
-
Executing the Example Scenario
- Create Administrators with the Required Roles
- Set Up the Infrastructure
- Analyze the Environment and Identify Whether Your Targets Can Be Patched
- Identify the Relevant Patches
- Create a Patch Plan, Test the Patches, and Certify the Patches
- Create a Change Activity Plan to Roll Out the Patches
- Roll Out the Patches
- Check and Report the Status of the Change Activities
- Verify If the Targets Have Been Patched
-
Troubleshooting Issues
-
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
-
Troubleshooting Patching Issues
- Oracle Software Library Configuration Issues
- My Oracle Support Connectivity Issues
- Host and Oracle Home Credential Issues
- Collection Issues
- Patch Recommendation Issues
-
Patch Plan Issues
- Patch Plan Becomes Nondeployable and Fails
- Instances Not to Be Migrated Are Also Shown as Impacted Targets for Migration
- Cluster ASM and Its Instances Do Not Appear as Impacted Targets While Patching a Clusterware Target
- Recovering from a Partially Prepared Plan
- Error #1009 Appears in the Create Plan Wizard While Creating or Editing a Patch Plan
- Analysis Succeeds But the Deploy Button is Disabled
- Patch Plan Fails When Patch Plan Name Exceeds 64 Bytes
- Out-of-Place Patching Fails for 11.2.0.3 Exadata Clusterware
- Patch Plan Analysis Issues
- User Account and Role Issues
- Refreshing Configurations
- Reviewing Log Files
-
Troubleshooting Database Provisioning Issues
- Index