Contact Us @ +1-210-503-7101

ORACLE DBA

Oracle DBA – Course Content

Purpose of the course:

Oracle is object-relational Database Management System created by Oracle. This Oracle DBA Training helps to provide you an in-depth understanding of the Oracle Database Server Administration. It includes various concepts like Oracle DBA Architecture, database structures, memory and process architecture, security, schema objects, data backup and recovery. DBA’s are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. They are also responsible for security, performance and availability of data to users and customers. Here we can learn how to operate the stored data and return meaningful results to analyze the data stored. You can also opt these courses to achieve Database administration certification.


How it can help a person for future:

Benefits of Oracle DBA for Businesses: Oracle dba holders perform at a higher level than non-dba employees. Enterprises employing Oracle DBAs enjoy increased systems performance. Companies that hire Oracle dba’s individuals are shown to have increased staff retention.


DURATION:
  • For General training - 30 Hours. (Theory: 10 hrs + Practical: 10 hrs. + Tutorial: 10 hrs.)

  • For Weekend training - 30 Hours. (Theory: 10 hrs + Practical: 10 hrs. + Tutorial: 10 hrs.)

  • For Fast track training - 30 Hours. (Theory: 10 hrs + Practical: 10 hrs. + Tutorial: 10 hrs.)


SYLLABUS OUTLINE
1) Chapter/Module -1:
  • 1.1 Infrastructure Setup:
    • 1.1.a Installation of Virtual workstation
    • 1.1.b Installation of OEL Operating system
    • 1.1.c OEL Oracle Enterprise Linux
    • 1.1.d Disk Druid configuration
    • 1.1.e Manual partitions
    • 1.1.f Assigning static ip to Ethernet
    • 1.1.g Time zone selection
    • 1.1.h Root user password configuration
    • 1.1.i Packages selection
    • 1.1.j Post installation configuration
    • 1.1.k Login to the OS
    • 1.1.l Installing Virtual tools
    • 1.1.m Sharing of Folders from host OS to virtual OS
    • 1.1.n Cloning of OS in virtual workstation
    • 1.1.o Start and Shut of OS
2) Chapter/Module -2:
  • 2.1 Linux Commands
  • 2.2 list
  • 2.3 creating file with cat
  • 2.4 appending file with cat
  • 2.5 view file contents with cat
  • 2.6 moving and renaming a file
  • 2.7 copy commands
  • 2.8 remove commands
  • 2.9 creation of Directory
  • 2.10 touch
  • 2.11 persistence
  • 2.12 visual editor
  • 2.13 time stamp
  • 2.14 Groups
  • 2.15 Users
  • 2.16 password configuration
  • 2.17 Normal user switching
  • 2.18 Xhost +
  • 2.19 hostname configuration
  • 2.20 netconfig
  • 2.21 neat
  • 2.22 service restarting
  • 2.23 Basic file permission
  • 2.24 Ownership
  • 2.25 Change directory
  • 2.26 change mod
  • 2.27 Present working directory
  • 2.28 Bash profile
  • 2.29 executing bash profile
  • 2.30 head
  • 2.31 tail

3) Chapter/Module -3:
  • 3.1 Installation and Database Creation
  • 3.2 Creating group
  • 3.3 Creating user
  • 3.4 Password assigning
  • 3.5 Create directory path
  • 3.6 Permissions
  • 3.7 Ownership
  • 3.8 Bash profile
  • 3.9 Executing bash
  • 3.10 XHOST +
  • 3.11 Switching user
  • 3.12 DBCA Method
  • 3.13 Manual DB creation

4) Chapter/Module -4:
  • 4.1 Connecting to Database
  • 4.2 SQLPLUS tool
  • 4.3 Verify database name
  • 4.4 Verify database status
  • 4.5 Verify control file location
  • 4.6 Verify data files location
  • 4.7 Verify redo log files location
  • 4.8 Verify flash recovery area location
  • 4.9 Verify Archive mode or No archive mode
  • 4.10 Shut database
  • 4.11 Startup database
  • 4.12 Nomount
  • 4.13 Mount
  • 4.14 Open stages

5) Chapter/Module -5:
  • 5.1 Parameter file
  • 5.2 Database startup process
  • 5.3 Database No mount stage
  • 5.4 SID and Parameter file
  • 5.5 PFILE location
  • 5.6 PFILE Name
  • 5.7 PFILE Configuration
  • 5.8 Verify PFILE OR SPFILE in DB
  • 5.9 SPFILE Name
  • 5.10 SPFILE Configuration
  • 5.11 SPFILE Memory option
  • 5.12 SPFILE Scope option
  • 5.13 SPFILE SPFILE option
  • 5.14 Create SPFILE from SPFILE
  • 5.15 Create PFILE from SPFILE
  • 5.16 Backup and Restoration of Parameter file

6) Chapter/Module -6:
  • 6.1 Controlfile Management
  • 6.2 ORACLE instance start up process
  • 6.3 DATABASE Mount Stage
  • 6.4 Control file characteristics
  • 6.5 Control file multiplexing
  • 6.6 Verify multiplexing

7) Chapter/Module -7:
  • 7.1 Redolog File management
  • 7.2 ORACLE Instance
  • 7.3 REDOLOG Algorithm
  • 7.4 REDOLOG multiplexing
  • 7.5 View Redo log Groups
  • 7.6 View Redo log members
  • 7.7 Redo log creation
  • 7.8 Drop Redo log group , member
  • 7.9 Adding member to Redo log group
  • 7.10 View status
  • 7.11 Manual Switching
  • 7.12 Drop members from group
  • 7.13 Configuring Database in Archive log mode
  • 7.14 Configuring database in no archive log mode
  • 7.15 Configure FRA
  • 7.16 Manual switching
  • 7.17 Verify

8) Chapter/Module -8:
  • 8.1 Tablespace Management
  • 8.2 Permanent table space
  • 8.3 Temporary table space
  • 8.4 Undo table space
  • 8.5 SYSTEM.dbf
  • 8.6 SYSAUX.dbf
  • 8.7 Users.dbf
  • 8.8 Temp.dbf
  • 8.9 Unodtbs.dbf
  • 8.10 Roll back
  • 8.11 Creating permanent table space with limited size
  • 8.12 Creating permanent table space with unlimited size
  • 8.13 Creating permanent table space with fixed size
  • 8.14 Adding data file to existing table space
  • 8.15 Resizing data file
  • 8.16 Table space online
  • 8.17 Table space offline
  • 8.18 Drop table space
  • 8.19 Auto extend feature
  • 8.20 View user table space
  • 8.21 Determine Database size
  • 8.22 Determine used database size
  • 8.23 Determine allocate data size
  • 8.24 Determine table space size
  • 8.25 Determine table size

9) Chapter/Module -9:
  • 9.1 Oracle Network services
  • 9.2 TCP IP Configuration
  • 9.3 Ping
  • 9.4 Listener
  • 9.5 Tns names
  • 9.6 Netca tool
  • 9.7 Port Range
  • 9.8 Location
  • 9.9 Listener services
  • 9.10 Bouncing services
  • 9.11 Stop service
  • 9.12 Start service
  • 9.13 status service
  • 9.14 Testing connection
  • 9.15 Client side tns configuration
  • 9.16 Linux to Linux setup

10) Chapter/Module -10:
  • 10.1 User Management and security
  • 10.2 Database user creation
  • 10.3 User connects to database
  • 10.4 Creating role
  • 10.5 Assigning privilege to role
  • 10.6 Assigning role to a user
  • 10.7 Revoking privilege from role
  • 10.8 View user roles
  • 10.9 View user privileges
  • 10.10 Password set for user
  • 10.11 User account lock
  • 10.12 User account unlock
  • 10.13 Drop a user
  • 10.14 User creation with Permanent table space
  • 10.15 User creation with Temporary table space
  • 10.16 Quota configuration
  • 10.17 Quota increase
  • 10.18 Quota decrease
  • 10.19 Quota revoke
  • 10.20 Quota unlimited
  • 10.21 Security Profile
  • 10.22 Security Password
  • 10.23 Security Kernel

11) Chapter/Module -11:
  • 11.1 Backup and Restoration
  • 11.2 Logical backup
  • 11.3 Physical backup
  • 11.4 Online backup
  • 11.5 Offline backup
  • 11.6 Import statement
  • 11.7 Export Statement
  • 11.8 Data pump technology
  • 11.9 Full database level backup
  • 11.10 Incremental level backup
  • 11.12 Cumulative level backup
  • 11.13 User level backup
  • 11.14 Table level backup

12) Chapter/Module -12:
  • 12.1 Patch and Upgradation
  • 12.2 What is a patch
  • 12.3 Understand Oracle version
  • 12.4 Installing Oracle software
  • 12.5 Creating database 10g
  • 12.6 Patch set procedure
  • 12.7 Unzip the patch set
  • 12.8 Apply patch
  • 12.9 scripts
  • 12.10 Verify invalid objects
  • 12.11 Recompile
  • 12.12 Verify Oracle version
  • 12.13 Understanding Pre requisite for upgrade
  • 12.14 Verify existing Oracle home location
  • 12.15 Verify existing Oracle Base location
  • 12.16 Installing 11g
  • 12.17 Verify pre upgrade script
  • 12.18 Modification of Parameter file values
  • 12.19 Upgrading database with 11g
  • 12.20 Verify invalid objects
  • 12.21 Recompile
  • 12.22 Verify Oracle version

13) Chapter/Module -13:
  • 13.1 Clone the database
  • 13.2 Cloning concept
  • 13.3 Online Cloning
  • 13.4 Pre requisite for online cloning
  • 13.4 online backup
  • 13.5 Generate control trace file
  • 13.6 Conversion of trace file
  • 13.7 Preparing client machine
  • 13.8 Cloning on client machine
  • 13.9 Recover data from archive log
  • 13.10 Verify cloning on client machine

14) Chapter/Module -14:
  • 14.1 ASM
  • 14.2 ASM Concept
  • 14.3 Pre requisite ASM
  • 14.4 Disk group creation
  • 14.5 ASM Instance configuration
  • 14.6 Local configuration add
  • 14.7 ASM disk
  • 14.8 Installing Oracle binaries
  • 14.9 RDBMS instance configuration
  • 14.10 Manual database creation on storage
  • 14.11 verify database creation

15) Chapter/Module -15:
  • 15.1 Data Guard
  • 15.2 Data Guard concept
  • 15.3 Feature of DG
  • 15.4 Implementing DG
  • 15.5 Pre requisite of DG
  • 15.6 DG configuration on Primary server
  • 15.7 DG configuration on secondary server
  • 15.8 Verify replication through manual switch log files

16) Chapter/Module -16:
  • 16.1 RMAN
  • 16.2 Pre requisite of RMAN
  • 16.3 RMAN configuration on server side
  • 16.4 RMAN configuration on client side
  • 16.5 connecting to idle catalog database
  • 16.6 create catalog database
  • 16.7 RMAN database register
  • 16.8 verify target server information
  • 16.9 RMAN statements
  • 16.10 Using RMAN backup

P.S: Additional brush up sessions will be for 2 days of 1 hour each where you can brush up all the topics covered and clear your doubts.

About Tutor

card image

US IT Training

This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.

US IT Training

This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.