Oracle DBA Course Content

                                                                                Infrastructure setup
  •  Installation of Virtual workstation
  •  Installation of OEL Operating system
  •  OEL Oracle Enterprise Linux
  •  Disk Druid configuration
  •  Manual partitions 
  •  Assigning  static ip to Ethernet
  •  Time zone selection
  •  Root user password configuration
  •  Packages selection
  •  Post installation configuration
  •  Login to the OS
  •  Installing Virtual tools
  •  Sharing of Folders from host OS to virtual OS
  •  Cloning of OS in virtual workstation
  •  Start and Shut of OS 
Basic Linux commands
  • list 
  • creating file with cat
  • appending file with cat
  • view file contents with cat
  • moving and renaming a file
  • copy  commands
  • remove commands
  • creation of Directory
  • touch 
  • persistence
  • visual editor
  • time stamp 
  • Groups
  • Users
  • password configuration
  • Normal user switching
  • Xhost + hostname configuration
  • netconfig
  • neat
  • service restarting
  • Basic file permission
  • Ownership 
  • Change directory
  • change mod
  • Present working directory
  • Bash profile
  • executing bash profile
  • head
  • tail
Pre Installation Configuration
  •  Creating group
  •  Creating user
  •  Password assigning
  •  Create directory path
  •  Permissions
  •  Ownership
  •  Bash profile 
  •  Executing bash 
  •  XHOST +Switching user
Installing ORACLE And Database creation
  • Basic Installation method
  • Advance Installation method
  • DBCA Method
  • Manual Database creation
Connecting to Database
  • SQLPLUS  tool
  • Verify  database name
  • Verify database status
  • Verify  control file location
  • Verify data files location
  • Verify redo log files location
  • Verify flash recovery area location
  • Verify Archive mode or No archive mode
  • Shut database
  • Startup database

Parameter file management
  • Database startup process
  • Database No mount stage 
  • SID and Parameter file
  • PFILE  location 
  • PFILE Name
  • PFILE Configuration
  • Verify PFILE OR SPFILE in DB
  • SPFILE Name
  • SPFILE Configuration
  • SPFILE  Memory option
  • SPFILE Scope option
  • SPFILE  SPFILE  option
  • Create SPFILE from SPFILE
  • Create PFILE from SPFILE
  • Backup and Restoration of Parameter file

Control file management
  • ORACLE instance start up process
  • DATABASE  Mount Stage
  • Control file characteristics
  • Control file multiplexing
  • Verify multiplexing
Redo Log file management
  • ORACLE Instance
  • REDOLOG Algorithm
  • REDOLOG multiplexing
  • View Redo log Groups
  • View Redo log members 
  • Redo log creation
  • Drop Redo log group , member
  • Adding member to Redo log group
  • View status
  • Manual Switching 
  • Drop members from group
 Archive Log And Flash Recovery Area
  • Configuring Database in Archive log mode
  • Configuring database in no archive log mode
  • Configure FRA
  • Manual switching
  • Verify 

Table space Management
  • Permanent table space
  • Temporary table space
  • Undo table space
  • SYSTEM .dbf
  • SYSAUX.dbf
  • Users.dbf
  • Temp.dbf
  • Unodtbs.dbf
  • Roll back 
  • Creating permanent table space with limited size
  • Creating permanent table space with unlimited size
  • Creating permanent table space with fixed size
  • Adding data file to existing table space
  • Resizing data file
  • Table space online
  • Table space offline
  • Drop table space 
  • Auto extend feature
  • View user table space
  • Determine Database size
  • Determine used database size
  • Determine allocate data size
  • Determine table space size
  • Determine table size
User Management And Security
  • Database user creation
  • User connects to database
  • Creating role
  • Assigning privilege to role
  • Assigning role to a user
  • Revoking privilege from role
  • View user roles
  • View user privileges
  • Password set for user
  • User account lock
  • User account unlock
  • Drop a user
  • User creation with Permanent table space
  • User creation with Temporary table space
  • Quota configuration
  • Quota increase
  • Quota decrease 
  • Quota revoke
  • Quota unlimited
  • Security Profile  
  • Security Password
  • Security Kernel

Oracle Network Services
  • TCP IP Configuration
  • Ping 
  • Listener
  • Tns names 
  • Netca tool
  • Port Range
  • Location
  • Listener services
  • Bouncing services
  • Stop service
  • Start service
  • status service
  • Testing connection
  • Client side tns configuration 
  • Linux to Linux setup

Backup  And Restoration
  • Logical backup
  • Physical backup
  • Online backup
  • Offline backup
  • Import statement
  • Export Statement
  • Data pump technology
  • Full database level backup
  • Incremental level backup
  • Cumulative level backup
  • User level backup
  • Table level backup

Patch Management
  • What is a patch 
  • Understand Oracle version
  • Installing Oracle software
  • Creating database 10g
  • Patch set procedure
  • Unzip the patch set
  • Apply patch 
  • scripts
  • Verify invalid objects
  • Recompile
  • Verify Oracle version

Up gradation from 10g to 11g
  • Understanding Pre requisite for upgrade
  • Verify existing Oracle home location
  • Verify existing Oracle Base location
  • Installing 11g 
  • Verify pre upgrade script
  • Modification of Parameter file values
  • Upgrading database with 11g
  • Verify invalid objects
  • Recompile
  • Verify Oracle version

Cloning
  • Cloning concept
  • Online Cloning
  • Pre requisite for online cloning
  • online backup 
  • Generate control trace file
  • Conversion of trace file
  • Preparing client machine
  • Cloning on client machine
  • Recover data from archive log
  • Verify cloning on client machine

Automatic Storage Management
  • ASM Concept
  • Pre requisite ASM
  • Disk group creation
  • ASM Instance configuration
  • Local configuration add 
  • ASM disk
  • Installing Oracle binaries
  • RDBMS instance configuration
  • Manual database creation on storage
  • verify database creation

Data Guard - Disaster Recovery solution
  • Data Guard concept
  • Feature of DG
  • Implementing DG
  • Pre requisite of DG
  • DG configuration on Primary server
  • DG configuration on secondary server
  • Verify replication through manual switch log files

Recovery Manager Infrastructure setup
  • Pre requisite of RMAN
  • RMAN configuration on server side
  • RMAN configuration on client side
  • connecting to idle catalog database
  • create catalog database
  • RMAN database register
  • verify target server information
  • RMAN statements
  • Using RMAN backup