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