- Basic knowledge of Introduction to SQL
- Basic knowledge of Linux Operating System
Students can use this training to prepare for majority of the topics required to pass the Oracle Database 12c Administration 1Z0-062 examination towards Oracle OCA certification (Oracle Certified Associate). The same training course can be used for preparation towards the Oracle Database 11g: Administration I 1Z0-052 examination as well. Additionally, students can also use this training to prepare for some topics required to pass the Oracle Database 12c: Advanced Administration 1Z0-063 exam that is required for acquiring the Oracle Certified Professional (OCP) designation.
Audience: Oracle 12c training is meant for Database Administrators, Data Warehouse Administrators, Database Designers, Technical Administrators and Support Engineers.
ORACLE Linux Installation
Basic Linux commands
ORACLE 12C Database Installation
Bash file Configuration
Manage Database Instance
Parameter file Configuration
Creating a New Database
Typical and Custom Install
Planning Database Files Locations
Operating System Environment
DB Configuration Assistant (DBCA)
Using Silent Method, Understanding TS
Changing Initialization parameters – SGA size
Processes, TS Naming Conventions
Block Sizes Type of DB Dropping a Database.
Maintaining the Control File, Redo Log File and Archive Log Files
Importance, Role, Sizing, Contents, Multiplexing and Backing up of the Control File Purpose of and how online redo log files work with their associated Background Processes Controlling log switches and checkpoints, Multiplexing and Archiving online redo log files.
Managing Tablespaces and Datafiles
Creating and Altering Tablespaces, adding, resizing, renaming and relocating a Datafile. Tablespace offline, online, readonly, readwrite, Temporary tablespace groups, multiple blocks Creating and Managing a Tablespace when using OMF and the advantages of OMF feature Extent management- Dictionary Managed and Locally Managed Tablespaces (AUTOALLOCATE, UNIFORM) and advantages of locally managed over dictionary managed tablespaces Big File Tablespace, Temporary Tablespace Group.
Managing Undo Segments
Understanding ORACLE Undo Segments
Undo Data versus Redo Data
Switching Undo Tablespace
Managing Oracle Network
Oracle Net Services Server-side Configuration
Oracle Net Services Client-Side Configuration
Use tnsping to test Oracle Net connectivity
Managing Backups and Recovery
Physical Backups – Hot, Cold
Exports & Imports
User Managed – RMAN Backups and Recovery
RMAN Incremental Backups
Redo log file lost
Restoring archives etc,.
Working with Support
Use the Enterprise Manager Support Workbench
Work with Oracle Support
Log service requests (SR)