About the Course
- Real Time Trainers with more than 9+yrs exp.
- Regular tracks & Fast tracks are available
- Week-end batches for working professionals
- Weekday early morning & evening batches
- Helps in cracking Certifications
- Real time projects discussion
- Resume preparation
- Mock Interviews
- Placement assistance
Topics CoveredOVERVIEW OF ORACLE
Roles and Responsibilites of DBA
Basics of SQL
Basics of Unix (required for DBA's)
ARCHITECTURE OF ORACLE
Importance of Oracle Database.
Importance of Orace Instance.
Importance of Memory Structrues.
Functionalities of Background processes.(pmon,smon,ckpt,dbwr,lgwr..etc).
Pre - installation checks.
setting up kernel parameters.
Installing oracle software.
Post - installation steps.
executing root.sh/oraInst.sh (importance of the scripts).
Setting up the environment variables.
Database Creation Using DBCA
Difference between Enterprise edition/standard edition and warehouse (custom ) database creation.
importance of oratab entry in database creation.
Setting up the environment variables using oratab.
STARTUP AND SHUTDOWN
ORACLE FILE SYSTEM
Important files in oracle binaries.
Importance of pfile/spfile.
Creating spfile from pfile and pfile from spfile.
Creating password file.
Creation/Spacemanagement/Dropping/extent management will be included in the tablespace management.
Day to Day issues in Tablespace management.
Explanations with ORA erros and solutions related to the tablespace.
Redo Log file Management.
importance of redo logfiles
creating redo log groups
creating redo log members
Multiplexing redolog members
Dropping Redo log groups.
Different Status of Redo log groups.
Enabling Database Archive log mode and its importance.
Moving Datafiles from one mount point to another mount to reduce I/O on file system.
Multiplexing Controlfiles for the high availibity.
Generating the controlfile trace.
Understanding Controlfile structure.
Scenarios on Controlfile version mismatch with ORA erros and solutions.
USERS AND ROLES MANAGEMENT
Assingning privileges to users and roles.
assigning Tablespace to users.
Real time issues and solutions of User Management.
What is Listener ?
Oracle Local Naming Methods.
Creation of Listener/Tnsnames using netca.
Real Time Issues and Solutions in oracle networking.
BACKUP & RECOVERY
Cold backup using manual method and tar backup method.
Hot Backup using begin backup method.
Hot Backup Using RMAN Method.
Rman Backup with Non Catalog.
Rman Backup With Catalog.
Normal Hot backup.
Hot Backup with Compression method.
Automating the Backups.
Real time issues and solutions of using RMAN
LOGICAL BACKUP using expdp/impdp
Remapping the schemas from one table to another table
Database full export and importing.
Table level export.
Schema level export.
Restoring the backups and creating duplicate database using cold backup.
Restoring the backups and creating duplicate database using hot backup.
Recovery using rman.(recovering the missing transactions by applying archives).
SCN based recovery.
Time Based Recovery.
Recovering a datafile.
FLASH BACK OF DATABASE
Creating Restore point and restoring the database to the old restore point.
Realtime scenarions on restore/recovery with ora errors and solutions.
What is Ora inventory how it works.
Pre-patch Analysis. (analysing the patches based on environment).
Bug fixing Patch.
Issues and Solutions while applying patches.
Basics of Performance Tuning
Generating ang gather AWR reports.
Using Explain Plan.
Generating sqlt report for analysing the long running requests.
Identifying the top resource consuming events using top and other methods and troubleshooting the same.
Basics of Partitioning.
Gather Schema stats.
Concepts of High Availability.
Introduction to ASM.
Normal redundancy in asm
External redundancy in asm
High redundancy in asm
Introduction to DATAGUARD
Dataguard Performance modes like : maximum protection/availabilty and performance modes.
Dataguard Background processes.
Introduction to RAC.(Real Application Cluster).
Split brain mechanism.
Introduction to Database Upgradation.
Preparing for the upgrade
Post upgradation process.
Working With Oracle Support.
Raising Service request with oracle.
Downloading the oracle products.
Working with Ticketing Systems. --
Hp Tool Center.
Remedy Ticketing system.
Day to Day Activities of DBA's In Real time.
Discussions on Most Common issues and solutions like:
ORA-12154: TNS:could not resolve the connect identifier specified (#1)
ORA-00600: internal error code, arguments: [%s], [%s],[%s], [%s], [%s]
ORA-03113: end-of-file on communication channel
ORA-01000: maximum open cursors exceeded
Real Time Case Studies from the DBA view point
1. Troubleshooting ORA-00321: log 1 of thread 1, cannot update log file header (ERROR WHILE OPENING DATABASE WITH RESETLOGS.).
2. RMAN CATALOG REGISTRATION FAILS WITH THE ERROR --- RMAN-03009: failure of full resync command on default channel
3.Recovering from Loss of Controlfile in database.
4. RECOVERING THE DATABASE IF SYSTEM DATAFILE IS LOST OR CORRUPTED
5. Recovering Undo tablespace with No Backup.
11g and 12c New Features
Discussion of 11g Features
Discussion of 12c Features
Preparation of Resume as per students requirments.
Discussion of Interview Questions
Tips for cracking the certififcation if student is taking any certification
Assistance to get interviews
Who should attend- Oracle PL/SQL Developers
- Professionals working on support with administration background
- Freshers passed out of the colleges..
- Working professionals who wants better opportunities
- Professionals who want to move to database field from their current domain
What you need to bringBook and Pen"""
Key Takeaways- many real time scenarios would be taught
- Deep understanding of the subject
- Relevant class notes
- Real time project related scenarios
- Tips for cracking the interviews
- Resume preparation points