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 DBA

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With MindMajix Technologies

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 DBA

Ameerpet, Hyderabad

No Reviews Yet
0 Interested

About the Course


Oracle DBA is the best technology to get the job in MNC's with in short period.

Topics Covered

course content for oracle dba online training and class room

Introduction.
Types of Databases.
Duties of a DBA, Classifications of DBA.
Oracle Versioning and versions history.
Grid ? Advantages of Grid Computing.
What is Instance? What is Database? What is Database Server?
Users the DBA interacts with.
Supported OS.
Introduction to Linux OS.
Linux File Layout structure.

Installation of Linux OS.
OS Users.
Installation process.
Disk layout.
Different mount points used by oracle.
Swap Area.
Creation of User groups.
Oracle needed file layout.

Installation of Oracle Software
Fulfilling prerequisites for installation.
Setting up environment.
Installation.
Post Installation scripts.
Changes done to the OS files after installation is complete.
/etc directory, /home/oracle directory, global inventory, oracle home.

Database Creation
Database files introduction.
Tablespaces and Schemas.
Control files introduction.
PFile Introduction, Creation and default parameters(10g/11g).
Instance States.
Database Creation Manually and Using DBCA.

Background processes and Different stages of Database.
Instance Start, Mount and Open states.
Dynamic views related to database.
Oracle memory layout.
Background processes.
Instance states more detailed.
How to look for background processes.

Database objects and Tablespaces.
Introducing putty and VNC server(How it works in realtime environment).
Sys owned objects.
Data Dictionary.
User Created objects.
Sys Tablespaces.
User Tablespaces.
Dictionary Managed Tablespace, Locally managed tablespace.
Bigfile tablespace.
Managing tablespaces.
Managing datafiles.
Datafiles layout, Internal organization.
Tables and Fragmentation.

Threads and Redo log groups
Archive log, No Archive log.
Threads and Groups concepts.
Multiplexing Redo logs.
Log switching.
Different stages of Log files.
Processes related to online Redo logs.
Adding Threads, Groups.
Dropping Threads, Groups.

Oracle Memory architectureDifferent components of memory(10g/11g).
Dedicated Server and Shared Server.
SGA and PGA, Differences between them.
Different Stages of a query.
Parsing: Hard parsing and Soft parsing.
Different stages during an update statement.
Checkpointing.

Indexes
Different types of Indexes.
B-Trees.
Creation.
Views related to indexes.
Index reorganization.
Statistics collection on indexes.

Networking and Remote ConnectionsTNS.
Listeners.
Listener.ora file.
Tnsnames.ora file.

Views and Materialized views
Types of views.
Creation.
Database links.
Materialized views.
Refreshing materialized views.
Processes related to materialized views.
Problems with materialized views refresh.

Users, Privileges, Roles and Responsibilities
Security and Passwords(10g/11g).
User Creation.
Creating Roles.
Assigning Privileges, Roles and Responsibilities.
Dropping users.
Revoking privileges.
Password file. Remote sys connect.

Pfile and spfile
Types of parameters(static and dynamic).
Managing spfile.
Creating pfile from spfile and vice versa.
Changing parameters dynamically.

Control files
Multiplexing.
Details stored in controlfiles.
Creating, Backing up and Recreating controlfiles.
Scenarios when a controlfile needs to be created.
Changing the Instance name and Database name.

Backups
Types of Failures.
Types of backups.
Logical Backups using ImpDP, ExpDP(Data Pump).
Transportable tablespaces.
Physical backups.
Cold Backups and Hot Backups.
Generation of redo during hot backups. Fuzzy blocks.

Recovery.
Complete recovery using cold backups.
Complete recovery using hot backups.
Partial recovery using cold backups.
Partial recovery using hot backups.
Different scenarios in performing recoveries.
UNNAMED datafiles during recovery.

Cloning Databases
Cold cloning.
Hot cloning.

RMAN(1)
RMAN tool introduction.
Catalog mode No-Catalog mode.
Configurations of RMAN.
Hot backups using RMAN.
Backing up Databases, Archivelogs and Controlfiles.
Channels and Multiple copies.
Tuning RMAN backups process.
Retention policies.
Incremental backups, Cumulative backups.

RMAN(2).
Restoration using RMAN.
Recovery using RMAN.
Cloning databases using RMAN.
Migrating databases using RMAN.
Restoration from Incremental Backups and Cumulative Backups.

Automatic Storage Management(ASM).
Striping and Mirroring.
RAID concepts.
ASM concepts and file systems.
Background processes used by ASM.
CSS daemon.
Creating Disk groups and Redundancy.
RMAN backups in ASM.
Migrating a NON-ASM database to ASM.
Rebalancing.
ASMCMD command-line tool.
md_backup and md_restore.

Patching and Upgrades.
Patches and Patch sets.
Upgrading within releases.

Database Migrations between releases.
Migration from 10g to 11g.

Data Guard.
Standby databases.
Physical Standby databases and Logical Standby databases.
Different modes of Protection and Availability.
Creating Standby databases.
Managing Databases in a Data Guard Environment.
Switchover and Failover.
Data Guard Broker.

Performance Tuning.
Categories of tuning.
Areas of tuning.
SQL Tuning.
Memory Tuning.
Disk I/O tuning.
Tools used for tuning.
Waits and Contention.
Latches and Spins.
Locks and Lock Resolution.
AWR reports, ADDM reports.
Oracle Database Replay.

Oracle Enterprise Manager and Grid Control.
Maintaining everything for OEM.
RMAN from OEM.
Data Guard from OEM.
AWR Reports and ADDM.
Tuning from OEM.

Who should attend

Any graduate.

Pre-requisites

Oracle Basics.

What you need to bring

No need.

Key Takeaways

Best real time Knowledge.
Reviews
There are no Reviews yet. Be the First to Review
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


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Raju

Hadoop developer


He is having 7+ years of experience in real time currently he is in research and development.
Seats Left-

Students Interested 0

Course Id: 13289