loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Oracle core DBA Training

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you want to receive a call on.

Please enter the Pin Code.

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

Connect With Chethan H G

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com 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 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

Share

course photo

Oracle core DBA Training

Basavanagudi, Bangalore

15,500

1 Reviews
0 Interested

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

OVERVIEW 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).

INSTALLATION
Pre - installation checks.
User/Group Creation
rpm's installation.
setting up kernel parameters.
downloading softwares

Installation.
Installing oracle software.

Post - installation steps.
executing root.sh/oraInst.sh (importance of the scripts).
Setting up the environment variables.

DATABASE CREATION
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
shutdown normal.
shutdown transactional.
shutdown immediate.
shuddown abort.

startup nomount.
startup mount.
startup open.

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

TABLESPACE MANAGEMENT

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.

FILE MANAGEMENT
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.

USERS AND ROLES MANAGEMENT
Creating users.
Creating Roles
Assingning privileges to users and roles.
assigning Tablespace to users.

Real time issues and solutions of User Management.

ORACLE NETWORKING

What is Listener ?
Oracle Local Naming Methods.

Creation of Listener/Tnsnames using netca.

Real Time Issues and Solutions in oracle networking.


FUNDAMENTALS --2

BACKUP & RECOVERY
PHYSICAL BACKUP

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

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.

RESTORE/CLONING
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.

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.

PATCHING
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.
Indexing.
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).
Cachefusion
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

CASE STUDIES
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

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

Pre-requisites

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
Reviews

Recommendations & reviews from previous Customers:

Ranjani

"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. "

attended Oracle core DBA Training


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Ranjani

"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. "

attended Oracle core DBA Training


Date and Time

Not decided yet.

About the Trainer


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

www.sarlakg.com
Seats Left-

Students Interested 0

Course Id: 13125