CourseForMe

Best Oracle 11g DBA Training institute in Bangalore

XchangeTechs - A C A D E M Y
XchangeTechs - A C A D E M Y

Detailed information

Oracle DBA11g Training in Bangalore
Oracle RAC Real Application Cluster Training in Bangalore
Oracle GoldenGate10g Training in Bangalore
Oracle Applications DBAR12 / AppsR12 DBA Training in Bangalore
Oracle Applications R12 Financials Training in Bangalore
Oracle Applications R12 HRMS Training in Bangalore
Oracle Applications SCM Training in Bangalore
Oracle PL/SQL Training in Bangalore
Microsoft Exchange Server 2013 Training in Bangalore
Microsoft SharePoint Administration Training in Bangalore
Microsoft MSBI Training in Bangalore
Microsoft SQL Server 2012 DBA Training in Bangalore
Oracle DBA11g Training in Bangalore
Oracle RAC training in Bangalore
Oracle Apps DBA
Cisco Certification Programs
CCNA
CCNP
OCA
OCP
Microsoft Certification
Authorised Training institute in Bangalore
Type:Certificate Programs
Method:In a classroom
Duration:45 Hour
Total hours of lesson:2
Requirements:All IT and CS students The best-fits are those with an undergraduate and master degree in Computer Science and a MBA in Information Systems. Employers need a DBA who can understand business systems areas (accounting, finance, marketing) and MBA's are a perfect fir for the DBA job role. The hard-working kids who have distinguished themselves by graduating from a top-tier university
Students per class:10

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

ORACLE 10g and 11g DBA CONTENTS

a) LINUX Administration basics
b) Oracle SQL and PL/SQL basics

ORACLE INSTALLATIONS
• Oracle Manual database Installations on Redhat Linux.

Oracle Database 10g &11g Architecture.
• Oracle Logical Storage Structures
• Oracle Logical Database Structures.
• Oracle Physical Storage Structures.
• Oracle Instance Architecture
• Shared and Dedicated Server processes
• Oracle Memory Structures
• Database Buffer Cache
• Redolog Buffer Cache
• Shared Pool
• Large Pool
• Java Pool
• Streams Pool
• Background Processes

Controlling the Database
• Creating and Configuring a listener.ora and tnsnames.ora file
• For Manual Installations as well as advanced and DBCA installations.
• Starting and Stopping Database Control
• Startup and Shutdown
• Starting Up a Database NOMOUNT
• Starting Up a Database MOUNT
• Starting Up a Database OPEN
• Shutting down the database.
• SHUTDOWN OPTIONS like Shutdown Normal, Shutdown Transactional, Shutdown Immediate and
Shutdown Abort

TableSpace Management
• Tablespaces and Data Files
• Space Management in Tablespaces
• Creating a New Tablespace
• Storage for Locally Managed Tablespaces
• Altering a Tablespace
• Actions with Tablespaces
• Dropping Tablespaces
• Viewing Tablespace Information

Control files management

• Multiplexing Control files
• How to recreate a controlfiles from the trace file.
• How to take backup of a controlfile

Redologfile Management
• How to multiplex redo log files.
• Creating Redo log groups
• How to drop redo log groups
• Adding Redolog Members to a Redolog Group
• Dropping a Redolog Member from a Group

Archivelog files management
• How to configure flash_recovery_area for manual database installations.
• How to configure flash_recovery_area size for manual database installations
• How to configure flash_recovery_area and flash_recovery_area size for basic, advanced and dbca
installations.
• How to enable Archivelogmode
• How to change database mode from noarchivelog mode to Archivelogmode
Security
• Users and Resource Control
o Creating New Users
o Modifying User Settings with the ALTER USER Statement
o Removing Users
• Introduction to Profiles
o Creating Profiles
o Managing Passwords
o Controlling Resource Usage
o Dropping a Profile
o Changing User, Profile, Password, and Resource Data
o System and Object Privileges
o Identifying System Privileges
o Using Object Privileges
• Managing System and Object Privileges
o Granting and Revoking System Privileges
o Granting and Revoking Object Privileges
• Database Roles
• How to Use Roles
• Using Predefined Roles
• Creating and Modifying Roles
• Creating and Assigning Privileges to a Role
• Assigning Roles to Users and to Other Roles
• Limiting Availability and Removing Roles
• Roles in the Enterprise Manager Console
• Quotas
o Assigning Quota to User
o Altering Quota to a User
o Assigning Unlimited Quota to a User







o Removing Entire Quota from a User
• Assigning Permanent and Temporary Tablespaces to a User

Oracle Net Services
• Creating and configure a listener in client server environment
• Starting the Listener Server Process
• Stopping a listener process
• Oracle Networking and Database Connectivity
• Establishing Oracle Connectivity
• Listener Control Utility
• Monitoring with Listener Control
• Local Naming
• Testing Oracle Net Connectivity
• Linux Server to Linux Server Communication (DBA)

Flashback Technologies
• Flashback Drop (Uses Recycle bin feature)
• Flashback Table (Uses undo data)
• Flashback Version Query (Uses undo data)
• Flashback Transaction Query (Uses undo data)

Logical Backups
• Logical backups using exp/imp
• Full Logical Backups, User Level Backups and Table level backups
• Logical backups
o The Data Pump Export/Import Process
• Using Data Pump Export and Import
o Creating a Directory
o Data Pump Export Options
o Starting a Data Pump Export job
• Data Pump Import Options
o Starting a Data Pump Import Job
o Comparing Data Pump Export/Import to Export/Import
• Logical Incremental backups using exp and imp
• Logical Incremental backups using data pump technologies i.e expdp and impdp

Physical Backups
• Cold backups or offline backups or Closed backups
• How to take cold backups for non-production environments like DEV, TST and STAGING
• Hot backups or Online Backups or Open Backups
• How to take Hot Backups for Production environments.

RMAN Backups and Recovery (Physical Backups)
• RMAN Features and Components
• RMAN vs. Traditional Backup Methods
• Backup Types
• RMAN commands and Options
• Configuring the RMAN Environment
• Setting up a Repository
• Registering a Database
• Controlfile Autobackup
o Backup Operations
o Full Database Backups
o Tablespace
o Datafiles
o Control File, SPFILE Backup
o Archived Redo Logs
o Incrementally Updated Backups
o Backup Compression
o Validating Backups
• Using the Recovery Catalog
• Making Backups with RMAN
• Maintaining RMAN Backups and the Repository
• Scripting RMAN
• Restoring a Control File
• Restoring a Tablespace
• Restoring a Datafile
• Restoring an Entire Database
• Validating Restore Operations
o Restore Preview
o Restore Validate
o Point in Time Recovery
o REPORT and LIST
• Performing Complete Recovery
• Performing Incomplete Recovery
• Performing Flashback Recovery
• Handling Online Redo Log Failures
• Tuning RMAN
• Troubleshooting RMAN
• Performing Backup and Recovery with Enterprise Manager (OEM)

Database Cloning
• Online Cloning for the Production Servers
• Offline Cloning for the Non-Production Servers

Patch Management
• What is a Patch?
• How to apply CPU (critical patch updates) to the Database.
• How to Apply Patches to the Database

Database Tuning
• Both Text based as well as OEM based
• Monitoring the Database Aspects
• Tuning the Database Areas
• Monitoring using the ADDM (Automatic Database Diagnostic Monitor)
• Managing AWR (Automatic Workload Repository)
• Accessing AWR through OEM
• Managing AWR using DBMS_WORKLOAD_REPOSITORY package
• Using OEM to View AWR Report.

Data Guard (Disaster and Recovery)
• Introduction to Oracle Data Guard

Automatic Storage Management (ASM)
• Introduction to Automatic Storage Management (ASM)

Course location

XchangeTechs - A C A D E M Y

XchangeTechs - A C A D E M Y was established in 2012 with a vision to contribute to the IT Industry by focusing on education in Information Technology. Since 2012, XchangeTechs has grown to become the largest independent IT training company!

XchangeTechs - A C A D E M Y provides comprehensive IT trainings for Individuals & Corporate trainings across India. Our mission is simple and straight forward. "To improve Personal and Organizational effectiveness and distribute knowledge to a large extent."

Course(s) Offered:

Oracle DBA 11g
Oracle RAC
Oracle Applications DBA R12
Oracle Applications Financials R12
Oracle Applications HRMS R12
Oracle Applications SCM R12
Oracle SOA11g
Microsoft Exchange Server 2013
Microsoft SharePoint Admin
Microsoft Windows Server Administration etc

Search similar to Oracle

Sponsored links