Oracle

Oracle’s latest database cloud innovations help more businesses than ever leverage industry-leading enterprise capabilities while simplifying access for IT and developers. New data management capabilities enable companies of all sizes to confidently and easily migrate workloads to the cloud. Its massive cloud scalability and rapid analytics help deliver faster time to insights, greater agility, and real cost savings advantages.

Whether you are developing applications or looking to migrate data management to the cloud, you now have instant access to enterprise-grade database capabilities. Oracle Database Cloud drives real business value with its ability to support a true hybrid cloud deployment strategy: 100 percent compatibility. Count on the same experience, whether on-premises or in the cloud.

Each database requires at least one database administrator (DBA). An Oracle Database system can be large and can have many users. Therefore, database administration is sometimes not a one-person job, but a job for a group of DBAs who share responsibility.

A database administrator's responsibilities can include the following tasks:

  • Installing and upgrading the Oracle Database server and application tools

  • Allocating system storage and planning future storage requirements for the database system

  • Creating primary database storage structures (tablespaces) after application developers have designed an application

  • Creating primary objects (tables, views, indexes) once application developers have designed an application

  • Modifying the database structure, as necessary, from information given by application developers

  • Enrolling users and maintaining system security

  • Ensuring compliance with Oracle license agreements

  • Controlling and monitoring user access to the database

  • Monitoring and optimizing the performance of the database

  • Planning for backup and recovery of database information

  • Maintaining archived data on tape

  • Backing up and restoring the database

  • Contacting Oracle for technical support

Slash Networks provides training for database administrators to empower them to master working with the entire Oracle 12c suite. The topics covered include:

Overview of Oracle Database Administration

  • Relational Databases (RDBMS): Introduction
  • What is SQL?
  • Roles & Responsibilities of DBA
  • Oracle Architecture
  • Process Architecture
  • Physical and Logical structures of Database
  • Types of files(Control file, REDO LOG FILE and Data file)
  • Different types of Data files
  • Instance
  • SGA(SYSTEM GLOBAL AREA) and Background Process

Database Creation

  • Using Oracle Universal Installer
  • Installation Prerequisites
  • Setting Environment Variables
  • Installing the Oracle Database Software: Steps
  • Using the Database Configuration Assistant (DBCA)
  • Different Startup Modes
  • Different Shutdown Modes
  • Types of Database Creation
  • Introduction to Table space
  • Types of Table space

Configuring the Oracle Network Environment 

  • Tools for Configuring and Managing the Oracle Network
  • Using the Listener Control Utility
  • Connecting to an Oracle Database
  • Oracle Net: Naming Methods
  • Using Oracle Net Manager to Configure Local Naming
  • Tnsnames.ora
  • Network default location
  • Introduction to Database Links

Managing the Oracle Instance

  • Oracle Instance Management
  • Oracle Processes
  • Oracle Memory Structures
  • Starting the Instance and Opening the Database
  • Shutting Down an Oracle Database Instance
  • Viewing and Modifying Initialization Parameters
  • Managing Memory Components
  • Viewing the Alert Log

Storage Parameters

  • Oracle Database Structures
  • Exploring the Storage Structure of the Oracle Database
  • What are segments?
  • What are extents?
  • What is Blocks?
  • Dictionary Managed Table space
  • Locally Managed Table space
  • Storage Parameters(Initial, Next, Min Extents, Pctincrease)
  • Managing Undo Data

 User Management

  • Who are Database Users?
  • Why to create a User?
  • Creation of Users
  • Assigning Privileges
  • Creating and granting Roles
  • Assigning default table space for the Users
  • Setting Profiles for the Users
  • Levels of Authentication

SPFile & PFile Managment

  • What is spfile?
  • Difference between spfile and pfile
  • Advantages of spfile

Redo-Log & Control File Management

  • Introduction to Redo log
  • Status of Redo logs
  • Multiplexing the Redo log files
  • Introduction/Multiplexing the Control file

Logical Backup/Restore

  • What is a logical backup
  • Why it is required
  • Export/import Utility
  • Data Pump
  • Difference between Data Pump and Traditional Export/import

Managing Oracle Database & Software

  • Managing the Oracle database –proactive checks
  • Understanding Software Management and Patch Releases
  • Patching Oracle Database Software
  • Using the Database Upgrade Assistant to Upgrade the Database

 Creating backups with RMAN

  • RMAN backup types
  • Creating and Using the RMAN backups
  • RMAN restore and recovery process

RMAN – Duplicating a Database

  • Purpose and Methods of Cloning a Database
  • Using RMAN to Create a Duplicate Database

 Performance Management

  • Performance Monitoring
  • Managing Memory Components
  • Invalid and Unusable Objects
  • Automatic Workload Repository Baselines
  • V$ Views, Statistics and Metrics

 Working with Oracle Support

  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches

 Mvoing Data / Data Migrations

  • Describe ways to move data
  • General architecture
  • Use Data Pump export and import to move data
  • Tools to data migrate

 Introduction to ASM & RAC

  • Introduction of Oracle ASM
    Introduction to Oracle RAC

 Miscellaneous

  • Database Best Practices & Scripts
  • Oracle features