Oracle DBA
Oracle DBA
-
Basic Linux commands 0/24
-
Lecture 1.1• List
-
Lecture 1.2• View file contents with cat
-
Lecture 1.3• Moving and renaming a file(mv)
-
Lecture 1.4• Copy commands(cp)
-
Lecture 1.5• Remove commands(rm)
-
Lecture 1.6• Creation of Directory(mkdir)
-
Lecture 1.7• Touch
-
Lecture 1.8• Visual editor(vi)
-
Lecture 1.9• Time stamp(date
-
Lecture 1.10• Groups
-
Lecture 1.11• Users
-
Lecture 1.12• Password configuration
-
Lecture 1.13• Normal user switching
-
Lecture 1.14• Xhost + hostname configuration
-
Lecture 1.15• netconfig
-
Lecture 1.16• neat
-
Lecture 1.17• service restarting
-
Lecture 1.18• Basic file permission
-
Lecture 1.19• Ownership
-
Lecture 1.20• change mod
-
Lecture 1.21• Present working directory
-
Lecture 1.22• executing bash profile
-
Lecture 1.23• head
-
Lecture 1.24• tail
-
-
Pre-Installation Configuration 0/9
-
Installing ORACLE And Database creation 0/4
-
Connecting to Database 0/10
-
Lecture 4.1• SQLPLUS tool
-
Lecture 4.2• Verify database name
-
Lecture 4.3• Verify database status
-
Lecture 4.4• Verify control file location
-
Lecture 4.5• Verify data files location
-
Lecture 4.6• Verify redo log files location
-
Lecture 4.7• Verify flash recovery area location
-
Lecture 4.8• Verify Archive mode or No archive mode
-
Lecture 4.9• Shut database
-
Lecture 4.10• Startup database
-
-
Parameter file management 0/15
-
Lecture 5.1• Database startup process
-
Lecture 5.2• Database No mount stage
-
Lecture 5.3• SID and Parameter file
-
Lecture 5.4• PFILE location
-
Lecture 5.5• PFILE Name
-
Lecture 5.6• PFILE Configuration
-
Lecture 5.7• Verify PFILE OR SPFILE in DB
-
Lecture 5.8• SPFILE Name
-
Lecture 5.9• SPFILE Configuration
-
Lecture 5.10• SPFILE Memory option
-
Lecture 5.11• SPFILE Scope option
-
Lecture 5.12• Create SPFILE from SPFILE
-
Lecture 5.13• Create PFILE from SPFILE
-
Lecture 5.14• SPFILE SPFILE option
-
Lecture 5.15• Backup and Restoration of Parameter file
-
-
Control file management 0/5
-
Redo Log file management 0/11
-
Lecture 7.1• ORACLE Instance
-
Lecture 7.2• REDOLOG Algorithm
-
Lecture 7.3• REDOLOG multiplexing
-
Lecture 7.4• View Redo log Groups
-
Lecture 7.5• View Redo log members
-
Lecture 7.6• Redo log creation
-
Lecture 7.7• Drop Redo log group , member
-
Lecture 7.8• Adding member to Redo log group
-
Lecture 7.9• View status
-
Lecture 7.10• Manual Switching
-
Lecture 7.11• Drop members from group
-
-
Archive Log And Flash Recovery Area 0/5
-
Table space Management 0/24
-
Lecture 9.1• Permanent table space
-
Lecture 9.2• Temporary table space
-
Lecture 9.3• Undo table space
-
Lecture 9.4• SYSTEM .dbf
-
Lecture 9.5• SYSAUX.dbf
-
Lecture 9.6• Users.dbf
-
Lecture 9.7• Unodtbs.dbf
-
Lecture 9.8• Temp.dbf
-
Lecture 9.9• Roll back
-
Lecture 9.10• Creating permanent table space with limited size
-
Lecture 9.11• Creating permanent table space with unlimited size
-
Lecture 9.12• Creating permanent table space with fixed size
-
Lecture 9.13• Adding data file to existing table space
-
Lecture 9.14• Resizing data file
-
Lecture 9.15• Table space online
-
Lecture 9.16• Table space offline
-
Lecture 9.17• Drop table space
-
Lecture 9.18• Auto extend feature
-
Lecture 9.19• View user table space
-
Lecture 9.20• Determine Database size
-
Lecture 9.21• Determine used database size
-
Lecture 9.22• Determine allocate data size
-
Lecture 9.23• Determine table space size
-
Lecture 9.24• Determine table size
-
-
User Management And Security 0/22
-
Lecture 10.1• Database user creation
-
Lecture 10.2• User connects to database
-
Lecture 10.3• Creating role
-
Lecture 10.4• Assigning privilege to role
-
Lecture 10.5• Assigning role to a user
-
Lecture 10.6• Revoking privilege from role
-
Lecture 10.7• View user roles
-
Lecture 10.8• View user privileges
-
Lecture 10.9• Password set for user
-
Lecture 10.10• User account lock
-
Lecture 10.11• User account unlock
-
Lecture 10.12• Drop a user
-
Lecture 10.13• User creation with Permanent table space
-
Lecture 10.14• User creation with Temporary table space
-
Lecture 10.15• Quota configuration
-
Lecture 10.16• Quota increase
-
Lecture 10.17• Quota decrease
-
Lecture 10.18• Quota revoke
-
Lecture 10.19• Quota unlimited
-
Lecture 10.20• Security Profile
-
Lecture 10.21• Security Profile
-
Lecture 10.22• Security Kernel
-
-
Oracle Network Services 0/15
-
Lecture 11.1• TCP IP Configuration
-
Lecture 11.2• Ping
-
Lecture 11.3• Listener
-
Lecture 11.4• Tns names
-
Lecture 11.5• Netca tool
-
Lecture 11.6• Location
-
Lecture 11.7• Port Range
-
Lecture 11.8• Listener services
-
Lecture 11.9• Bouncing services
-
Lecture 11.10• Stop service
-
Lecture 11.11• Start service
-
Lecture 11.12• status service
-
Lecture 11.13• Testing connection
-
Lecture 11.14• Client side tns configuration
-
Lecture 11.15• Linux to Linux setup
-
-
Backup And Restoration 0/12
-
Lecture 12.1• Logical backup
-
Lecture 12.2• Physical backup
-
Lecture 12.3• Online backup
-
Lecture 12.4• Offline backup
-
Lecture 12.5• Import statement
-
Lecture 12.6• Export Statement
-
Lecture 12.7• Data pump technology
-
Lecture 12.8• Full database level backup
-
Lecture 12.9• Incremental level backup
-
Lecture 12.10• Cumulative level backup
-
Lecture 12.11• User level backup
-
Lecture 12.12• Table level backup
-
-
Patch Management 0/11
-
Lecture 13.1• What is a patch
-
Lecture 13.2• Understand Oracle version
-
Lecture 13.3• Installing Oracle software
-
Lecture 13.4• Creating database 10g
-
Lecture 13.5• Patch set procedure
-
Lecture 13.6• Unzip the patch set
-
Lecture 13.7• Apply patch
-
Lecture 13.8• scripts
-
Lecture 13.9• Verify invalid objects
-
Lecture 13.10• Recompile
-
Lecture 13.11• Verify Oracle version
-
-
Up gradation from 11g to 12c 0/10
-
Lecture 14.1• Understanding Pre requisite for upgrade
-
Lecture 14.2• Verify existing Oracle home location
-
Lecture 14.3• Verify existing Oracle Base location
-
Lecture 14.4• Installing 11g
-
Lecture 14.5• Verify pre upgrade script
-
Lecture 14.6• Modification of Parameter file values
-
Lecture 14.7• Upgrading database with 12c
-
Lecture 14.8• Verify invalid objects
-
Lecture 14.9• Recompile
-
Lecture 14.10• Verify Oracle version
-
-
Cloning 0/10
-
Lecture 15.1• Cloning concept
-
Lecture 15.2• Online Cloning
-
Lecture 15.3• Pre requisite for online cloning
-
Lecture 15.4• online backup
-
Lecture 15.5• Generate control trace file
-
Lecture 15.6• Conversion of trace file
-
Lecture 15.7• Preparing client machine
-
Lecture 15.8• Cloning on client machine
-
Lecture 15.9• Recover data from archive log
-
Lecture 15.10• Verify cloning on client machine
-
-
Recovery Manager Infrastructure setup 0/9
-
Lecture 16.1• Pre requisite of RMAN
-
Lecture 16.2• RMAN configuration on server side
-
Lecture 16.3• RMAN configuration on client side
-
Lecture 16.4• connecting to idle catalog database
-
Lecture 16.5• create catalog database
-
Lecture 16.6• RMAN database register
-
Lecture 16.7• verify target server information
-
Lecture 16.8• RMAN statements
-
Lecture 16.9• Using RMAN backup
-
This content is protected, please login and enroll course to view this content!