Call :+91 8055223360
Menu
Call :+91 8055223360
Dba are the highest paid professional in IT industry. As major Database share in industry is Oracle, picking up Oracle DBA carrier would be lucrative today and in future. Covers each topics with Real Time Examples . Covers More than 250+ Real Time Scenarios which is divided into Admin 1 (Basic) + Admin2 + 12C (which is why we called it a combo course). Trainer from Real Time Industry .This is completely hands-on training , which covers 70% Practical And 30% Theory .Specail attention / session for interview preparation after the course is done.We give examples and exposure to real time scenarios to make sure all the candidate will get at least 5+ Year experience knowledge in Oracle DBA after attending this course.Covers 11G +12C topics in Details from the very basic to advanced level . Complete OCA and OCP Exam Preparations.Appear for OCA/OCP Certification Exam at any time After the course . At your convenient time , you can book and appear for exam at our place as we are Pearson certified institute.
Students can first take up the Oracle 11g DBA then move on to become Advanced DBA by doing 11g RAC DBA, which will include Data guard Concepts and Implementations as well. Oracle Apps DBA course is designed keeping practical focused for those DBA’s who would like to go for Oracle Apps DBA career path, which is in great demand today.
Students have an option to reach out to the faculty over a phone call for 1 month support to get them established in their new job as DBA.Mock Interview Sessions for all the courses at the end of the course Guidance to students for Books References, Obtain Support, Work with Oracle Corp & Right material reference to become an Expert DBA eventually – today we lack this in industry. Students can avail extra practice hours for implementations.
There are no formal prerequisites for this course; however, previous operating system administration experience will be very beneficial.
Duration of Training: 10 weekends
Linux Installation
Learn to install Linux with relevant packages.
1) Understand HDD partitioning
2) Primary Verses Extended Partitioning
3) Physical Volumes / Logical Volumes / Luns
Understanding RAID / Storages / DNS / DHCP / iscsi utilities
1) Different levels of Raid
2) Installation of configuration of DNS.
3) Installation and configuration of DHCP
4) tgtd and iscsi utilities
Installing 11g and 12c Oracle Software
1) Install and configure 11g and 12c Oracle Database Software
Creating 11g and 12c databases (manual)
1) Creating 11g Database and 12c Database manually
11g and 12c Architecture.
1) Thorough understanding of 11g and 12c architecture
Oracle Administration and management.
1) starting databases
2) understanding control files / redo log files / archive files
3) understanding Server parameter file and password files
4) Automatic memory management
5) Different components in SGA and PGA
Tablespaces / segments / extents and blocks
1) Dictionary managed versed locally managed tablespaces.
2) Automatic Segment space management
3) Understanding Segments / extents and blocks
4) Block utilization parameters
5) Understanding row chaining and migration
6) Different block Sizes
12c Multitenant Database concepts and new features
1) Understanding multitenant architecture
2) Overviews of Pluggable databases
Oracle networking and shared process overview
1) Configuring and maintaining listeners
2) Configured Dispatchers and Shared servers
3) Understanding tnsnames.ora / sqlnet.ora and Ez Connect
ASM overview and benefits
1) Complete Overview of ASM
2) Understand the need of ASM
3) ASM instance parameters
Rman and conventional Backup / Recovery
1) Defining backup strategy
2) Complete understanding of RMAN and conventional backups
Rman and Conventional Cloning
1) Cloning database using conventional methods
2) Cloning database using rman
Applying patches
1) Different types of Patches
2) How to apply patch to database
Database upgrade
1) Upgrade Database from 11g to 12c
2) Coverting 12c noncdb to 12c pluggable database
Physical and logical Standby/ Data guard
1) Configure physical standby database
2) Understanding logical and snapshot standby database
Oracle Shell Scripting overview.
1) understanding cronjob
2) writing basic scripts
AWR reports / ADDM reports / ASH report
1) Understand how to read the AWR / ADDM / ASH reports
Sql loader / external tables
1) Using sql loader to load data into tables
2) External tables and its benefits
Partitioning concepts
1) Understanding different types of partitioning
2) Creating and altering partitions
expdp / impdp backups
1) Taking logical backups using expdp
2) Data pump usage and scenarios
Tracing utilities ( oradebug / sql trace / tkprof ) and sql tuning
1) Using utilities for tracing
2) How to read SQL explain plan
3) SQL performance considerations
Scenarios:
Loss of a Control File
Loss of a Redo Log File
Loss of a Data File in NOARCHIVELOG Mode
Loss of a Noncritical Data File in ARCHIVELOG Mode
Loss of a System-Critical Data File in ARCHIVELOG Mode
Oracle Recovery Manager
Oracle Recovery Catalog maintenance
Backups using Oracle Recovery Manager
Recovery using Oracle recovery manager
Database Cloning using RMAN
Tablespace Point in time recovery
Incomplete recovery
Monitoring and Resolving Lock Conflicts
Locks
Locking Mechanism
Data Concurrency
DML Locks
Enqueue Mechanism
Lock Conflicts
Possible Causes of Lock Conflicts
Detecting Lock Conflicts
Resolving Lock Conflicts
Deadlocks
Performance Monitoring
Performance Monitoring
Monitoring Methodologies
Database and Instance Metrics
Data Dictionary Metrics
Optimizer Statistics
Schedule Optimizer Statistics Collection
Dynamic Performance Views
Viewing Metric Information
Reacting to Performance Issues
Reacting to Performance Issues
Proactive Maintenance
Server Generated Alerts
Thresholds
Setting Thresholds
Baseline Measurements
Tuning and Diagnostic Advisors
SQL Tuning and Access Advisors
Memory Advisors
Segment Advisor
Automatic Workload Repository (AWR)
Managing the AWR
Automatic Database Diagnostic Monitor (ADDM)
Topics covered
1. VMware Install
2. Linix Installation
3. Networking (Neat)
4. OS user create , group , password
5. File share from windows os to Linux os
6. Oracle Installation
7. Database Create
8. NETCA,NETMGR
a. Listener
i. Lsnrctl utility
b. Services
9. SGA
10. User Management
11. Profile
12. Roles
13. Tablespace
a. Create,drop,alter tablespace
b. Create datafiles
c. Small datafile
d. Big datafile
e. Quota
f. Tablespace online , offline
g. Default tablespace
h. Extent management
i. Memory allocation
14. Undo Management
15. Database Startup types
16. Database Shutdown types
17. Physical files
18. Backup, Restore and Recovery
a. Physical Backup
i. Cold Backup
ii. Hot Backup
b. Data Pump
i. Exp,Imp
ii. Impdp, Expdp
c. RMAN
19. Flashback
1 .Oracle Database Architecture
Databases and instances overview
Multitenant architecture
Sharding architecture
Architecture diagram on the OHC
Physical storage structures
Logical storage structures
Logical and physical storage structures
Data storage-segments, extents, blocks
Types of segments
Deferred segment creation
Block structure
Tablespaces and datafiles
Processes
Memory structures
Overview of Oracle Net Services
Overview of the Listener
Dedicated and shared server processes
2. Creating and Administering an Oracle Database
Use the Database Server Architecture lesson of the Oracle Database Architecture module
Connecting to an Oracle Database instance
Overview of Oracle Database tools
Prepare to create the database
Determine the character set to be used
Create a Multitenant Oracle Database (CDB)
Using DBCA in silent mode
Create a Multitenant Oracle Database (CDB)
Shut down the database instance and start the database instance/open the database
Open and close PDBs
Investigating Initialization Parameter Files
Viewing Initialization Parameters by Using SQL*Plus
Modifying Initialization Parameters by Using SQL*Plus
Viewing Diagnostic Information
3. Configuring and Administering Oracle Net Services
CourseLab
Use the Oracle Net Services Architecture lesson of the Oracle Database Architecture module.
Naming methods
Define service names so users can connect to the database
19c Easy Connect Syntax Improvements (76634-2)
Create listeners
Configure listeners for dynamic or static service registration
Implement failover and load balancing features
Configure shared server architecture
Implement session multiplexing and access control features
Configure the cman.ora file on the Oracle Connection Manager computer.
Configure the clients with the protocol address of the Oracle Connection Manager listener.
Configure the database server for session multiplexing.
Configure the cman.ora File to set up Oracle Database Cloud Traffic Manager.
4. Creating and Administering Pluggable Databases
Create PDBs from seed
Clone a regular PDB
Unplug and plug or clone a non-CDB
Unplug and plug a regular PDB
Perform hot cloning
Perform near-zero downtime PDB relocation
Create and use a proxy PDB
Use DBCA to clone and relocate PDBs, and duplicate CDBs
Change PDB mode
Modify PDB settings
Rename a PDB service
Drop a PDB
5. Creating and Managing Database Storage
Use the Database Storage Structures lesson of the Oracle Database Architecture module.
Create tablespaces to store database objects
Implement Oracle Managed Files (OMF)
View tablespace information
Drop a tablespace
Increase the size of the database (add datafiles, extend tablespaces, etc.)
Move or rename datafiles
Proactively monitor and manage tablespace space usage
Define default permanent tablespaces
Define a default temporary tablespace for a PDB
Save space by using compression
Reclaim wasted space from tables and indexes by using the segment shrink functionality
Manage resumable space allocation
Configure undo retention
Enable and disable temporary undo
Use local undo
6.Managing Users and Securing the Database
Create database users
Create common users in the CDB root and application root
Create local users in regular PDBs and application PDBsAssign quota to database users
Authentication
Oracle-defined schema only accounts
Provide users with access to the database (privileges/roles)
Create common roles in the CDB root and application root
Create local roles in regular PDBs and application PDBs
Grant privileges/roles commonly in the CDB root and application root
Grant privileges/roles locally in regular PDBs and application PDBs
Create profiles to control user security and resource utilization
Create common profiles in the CDB root and application root
Create local profiles in regular PDBs and application PDBs
Audit the use of the database (objects, privileges, etc.)
Audit actions in the CDB and PDBs
7. Loading and Transporting Data
Load data (Data Pump, SQL*Loader)
Utilities to load/maintain data in the database
Use SQL*Loader to load data
Use SQL*Loader with PDBs
Use Data Pump to transport (move) data
Move data from one database to another database
Use Data Pump with PDBs
Use the full transportable export/import feature to move an entire database to a different database instance
Use the transportable tablespaces feature to move a set of tablespaces between databases
Use the transportable tables feature to move a set of tables, partitions, and sub-partitions between databases
Use external tables as a data source
8. Managing Automated Maintenance Tasks
Overview of automated maintenance tasks
Overview of maintenance windows
Configure automated maintenance tasks
Enable and disable maintenance tasks
Create a maintenance window
Modify a maintenance window
Remove a maintenance window
Reduce or increase resource allocation to the automated maintenance tasks
9. Monitoring and Tuning Database Performance
Performance management activities
Performance planning
Performance tuning methodology
Automatic performance tuning features (AWR, ADDM, advisors)
PDB-level ADDM
Monitor database instance performance
Monitor database errors and alerts to prevent, detect, and solve problems (alert log, trace files, server-generated alerts)
Set metric thresholds
Monitor locks and wait events
Configure memory management
Set optimizer statistics preferences
Identify and tune SQL statements that are using the most resources
Tune a workload
Manage automated tuning tasks
Course completion certificate and Global Certifications are part of our all Master Program
Course completion certificate and Global Certifications are part of our all Master Program
Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.
Radical Technologies is a recognized leader in training of Administrative and Soft ware Development courses since 1995 to empower IT individuals with competitive advantage of exploiting untapped jobs in IT sector
