Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle core DBA Training

1 Reviews

Basavanagudi, Bangalore

Course ID: 13125

Basavanagudi, Bangalore

Students Interested 0 (Seats Left 0)

1 Reviews

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 Covered

Roles and Responsibilites of DBA
Basics of SQL
Basics of Unix (required for DBA's)

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.
User/Group Creation
rpm's installation.
setting up kernel parameters.
downloading softwares

Installing oracle software.

Post - installation steps.
executing (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.

shutdown normal.
shutdown transactional.
shutdown immediate.
shuddown abort.

startup nomount.
startup mount.
startup open.

Important files in oracle binaries.
Importance of pfile/spfile.
Creating spfile from pfile and pfile from spfile.
Creating password file.


System Tablespace.
Sysaux Tablespace.
Users/Custom Tablespace.
Undo Tablespace.
Temp Tablespace.

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.

Datafile Management.
Moving Datafiles from one mount point to another mount to reduce I/O on file system.
Renaming Datafiles.
Resizing Datafiles.

Controlfile Management.
Multiplexing Controlfiles for the high availibity.
Generating the controlfile trace.
Understanding Controlfile structure.

Scenarios on Controlfile version mismatch with ORA erros and solutions.

Creating users.
Creating Roles
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.



Cold Backup.
Cold backup using manual method and tar backup method.

Hot Backup.

Hot Backup using begin backup method.

Hot Backup Using RMAN Method.


Rman Backup with Non Catalog.

Rman Backup With Catalog.
Catalog Creation.
Normal Hot backup.
Hot Backup with Compression method.
RMAN parameters.

Automating the Backups.
Cron jobs.

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.
InComplete Recovery.
Recovering a datafile.

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.
CPU Patching.
Upgradation Patches.

Issues and Solutions while applying patches.

Basics of Performance Tuning
Database locks.
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.
Voting disks.

Introduction to Database Upgradation.
Preparing for the upgrade
Upgradation process.
Post upgradation process.

Additional Topics
Working With Oracle Support.
Raising Service request with oracle.
Downloading the oracle products.

Working with Ticketing Systems. --
Phaseware tracker
Hp Tool Center.
Remedy Ticketing system.

Day to Day Activities of DBA's In Real time.
Client Architectures.
Code migrations.
File movements.
Data extractions.

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.
5. Recovering Undo tablespace with No Backup.

11g and 12c New Features
Discussion of 11g Features
Discussion of 12c Features

Interview Assistance
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


ANY Graduation
Basic SQL(little)

What you need to bring

Book 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

Date and Time

Not decided yet.

About the Trainer

4.81 Avg Rating

280 Reviews

301 Students

10 Courses

Visit Our Website and Justdial and search for Sarlakg Technologies, Bangalore

Student Feedback


Average Rating





Satisfied with the methodology used to teach the subject. Where real time examples are provided to understand the topics more easily. Assignments are given on regular basis which helps to enhance the understanding of the topics well.


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now


Submit your enquiry for Oracle core DBA Training

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With SarLakG Technologies

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more