Oracle DBA - Level 2

Oracle DBA - Level 2

Oracle Database Administration – subordinate level for configuration, securing, maintaining and protecting databases

 

Configuring Oracle Net Services

  • Using Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • Configuring the Oracle Net Listener
  • Connecting to an Oracle Database Instance
  • Comparing Dedicated and Shared Server Configurations
  • Administering Naming Methods

Managing Tablespaces and Datafiles

  • Viewing Tablespace Information
  • Creating, Altering and Dropping Tablespaces
  • Managing Table Data Storage
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files

Managing Undo

  • Understanding Transactions and Undo Data
  • Storing Undo Information
  • Configuring Undo Rentention
  • Comparing Undo Data and Redo Data
  • Understanding Temporary Undo

Creating CDBs and Regular PDBs

  • Configure and create a CDB
  • Create a new PDB from the CDB seed
  • Explore the structure of PDBs

Manage CDBs and PDBs

  • Manage PDB service names and connections
  • Manage startup, shutdown and availability of CDBs and PDBs
  • Change the different modes and settings of PDBs
  • Evaluate the impact of parameter value changes
  • Performance management in CDBs and PDBs
  • Control CDB and PDB resource usage with the Oracle Resource Manager

Backup and Duplicate

  • Perform Backup and Recover CDBs and PDBs
  • Duplicate an active PDB
  • Duplicate a Database

Upgrading and Transporting CDBs and Regular PDBs

  • Upgrade an Oracle Database
  • Transport Data

Manage Application PDBs

  • Explain the purpose of application root and application seed
  • Define and create application PDBs
  • Install, upgrade and Patch applications
  • Create and administer Application PDBS
  • Clone PDBs and Application containers
  • Plug and unplug operations with PDBs and application containers
  • Comparing Local Undo Mode and Shared Undo Mode

Manage Security in Multitenant databases

  • Manage Security in Multitenant databases
  • Manage PDB lockdown profiles
  • Audit Users in CDBs and PDBs
  • Manage other types of policies in application containers

Course Enquiry