Selenium Online training

Oracle DBA Online Training

United Trainings is best training center to Oracle DBA online training. Oracle DBA (Oracle database administrator) is a professional who is capable enough to do the job related to the creation and management of database. Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.

Demo Session:-

Course Content – Oracle DBA online training

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