ORACLE DBA Online Training

ORACLE DBA Training Overview
Introduction
• 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