In Oracle Database Administration course you will learn how to perform all activities related to maintaining a successful database environment. Typically a DBA responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use.
Oracle DBA Training at Data Intellect has been designed as per latest industry trends and keeping in mind the advanced Oracle DBA course content and syllabus based on the professional requirement of the student; helping them to get placement in Multinational companies and achieve their career goals.
Solid Knowledge in SQL and PL/SQL is a pre-requisite for this course.
This course will cover:
Introduction to Database
Different type of Database
Popular database management system (DBMS) software and why Oracle DBMS.
History and Current trends of DBMS and Database Administration.
Oracle database market share and about its current competitive landscape.
Tasks of a Database Administrator.
Career as a Oracle Database Administrator
Oracle Certification for DBA
Oracle Enterprise Architecture
Connecting to a Server
Oracle Database Server Architecture: Overview
Instance: Database Configurations
Connecting to the Database Instance
Oracle Database Memory Structures
Database Buffer Cache
Redo Log Buffer
Java Pool and Streams Pool
Program Global Area (PGA)
Database Writer Process (DBWn)
Log Writer Process (LGWR)
Checkpoint Process (CKPT)
System Monitor Process (SMON)
Process Monitor Process (PMON)
Archiver Processes (ARCn)
Process Startup Sequence
Database Storage Architecture
Logical and Physical Database Structures
Oracle Database, Control files,
Redo log files, data files, Oracle Server.
Identify system requirements
The optimal flexible architecture (ofa)
Identify system requirements
Download Required software
Installing oracle Database
Installing Xmin (windows X)
Installing SQL Developer
Establish Client Server configuration
Creating an oracle database
Create a new database
Configure an existing database
Drop a database
Manage dbca templates
Manually create a database
Managing the database instance
starting & stopping database control
starting & stopping the database listener
starting & stopping the database instance
more about the database files
Calling a SQL *Plus script
Calling SQL *Plus from a Shell script
Oracle Net Services
Oracle Net Listener
Establishing Net Connections
Establishing a Connection
Tools for Configuring and Managing the Oracle Network
Listener Control Utility
Listener Control Utility Syntax
Using SRVCTL to Start and Stop the Listener
Listener Home Page
Net Services Administration Page
Creating a Listener
Adding Listener Addresses
External Naming Method
Configuring Service Aliases
Advanced Connection Options
Testing Oracle Net Connectivity
User Sessions: Dedicated Server Process
User Sessions: Shared Server Processes
Configuring Communication Between Databases
Connecting to Another Database
Manage database storage structures
How Table Data Is Stored
Database Block: Contents
Explonng the Storage Structure
Creating a New Tablespace
Storage for Tablespaces
Tablespaces in the Preconfigured Database
Altering a Tablespace
Actions with Tablespaces
Viewing Tablespace Information
Viewing Tablespace Contents
Oracle-Managed Files (OMF)
Enlarging the Database
Managing undo data
about undo space management
configure automatic undo management
guarantee undo retention
monitor undo space
use the undo advisor
Administering user security
create & manage database accounts
grant & revoke database privileges
resource limits via profiles
password management via profiles
about role-based security
with admin option
alter user…default role
enhanced default security settings
control file options
using the em interface
Export & import
manage directory objects
about the data pump architecture
data pump export
data pump import
data pump data dictionary views
using the em interface
Database maintenance & performance management
the management & advisory framework
manage the automatic workload repository
automatic database diagnostic monitor
use metrics & alert thresholds
automatic maintenance tasks
Managing concurrency & locks
about latches & locks
manage & monitor latches
manage & monitor locks
dba_blockers & dba_waiters
dba_dml_locks & dba_ddl_locks
Type of users,
creating database users,
Authentication methods (local authentication, OS authentication, network authentication).
Managing privileges and different types of privileges such as object level privileges and system level privileges.
Using Roles for privilege management,
Identifying assigned privileges using views for a given user.
Understanding profiles and implementing profiles.
button Understanding UNDO tablespace features like read consistency,
flashback options such as flashback query,
flashback version query,
flash back transaction query,
flashback data archive.
Setting up FRA area and the purpose.
Rollback segments, Pending offline status.
sizing UNDO tablespaces,
addressing ORA-01555 snapshot too old issues.
Backup and Database Patching procedures
Backup procedures provided by Oracle,
Logical backups and purpose,
Physical backupâ€™s architecture,
understanding complete recovery vs. incomplete recovery,
online recovery vs. offline recovery.
Purpose of cold backup.
HOT backups architecture.
button RMAN architecture and best practices in corporate world.
Different types of recoveries such as complete recovery,
incomplete recovery, online recovery and
offline recovery. Dynamics of recoveries. Recovery Manager Backups (RMAN),
RAMN setup and configuration, with catalog or out catalog. Corporate standards for RMAN backups.
Catalog database, Target databases and Auxiliary databases.
Performing backups and recoveries using all the methods (logical, physical and RMAN).
RMAN Command reference such as list, report, delete etc.
Database cloning using RMAN with database duplication as industry standard.
ASM (Automated storage management) concepts.
Different storage options for database files like file system files,
OMF and ASM. ASM architecture,
background processes, creating disk groups,
mounting disk groups.
Using ASMCMD and asmca GUI tool to manage ASM instances.
Grid Infrastructure software installation and configuring ASM for standalone database for its storage.
button Purpose of Data Guard, Architecture,
Physical Standby database setup,
Active data guard features.
Various protection modes such as Max Performance, Max Availability and Max Protection.
Best practices, requirements, different levels of performance tuning.
Sharing real world personal experiences on tuning techniques.
OS level base line statistics, database level maintenance methods with best practices,
database level statistics, indexes,
optimization methods, Row chaining and migration, DOP (parallelism),
monitoring and configuring parallelism related parameters.
Explain plans; enabling trace at session level understanding performance statistics during tracing.
Understanding TKPROF output.
Memory tuning, Automated shared memory management (SGA, SGA+PGA),
different types of caches for performance improvement such as keep cache,
recycle cache and result cache.
Oracle database upgrades
Introduction to Oracle versions and how to understand a version.
How to upgrade from a previous release to Oracle 12c.
How to upgrade from one patchset to another patchset within a release. What is slip-streaming ?
What are one-off/interim patches.
What are quarterly CPU patches (Cumulative Patch Updates).
Learn about Oracle Interim Patch Installer (OPATCH).
Upgrade a database using dbua (database upgrade assistant) GUI tool.