- Instructor: admin
- Lectures: 196
- Students: 36
- Duration: 4 weeks
Categories: Data Base
Tags: Oracle DBA
- Oracle Database Architecture:
An 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. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.
The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.
- What is Oracle database used for?
Oracle is One of the DATABASE language its used for Create database,tables,records…etc… An 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.
- What is Oracle database and how it works?
Oracle database is a collection of physical operating system files or disks (in the simplest terms). Oracle instance is set of Oracle background processes or threads and a shared memory area, which is memory that is shared across those threads or processes running on a single computer.
- Is Oracle a SQL database?
Oracle database is an RDMS system from Oracle Corporation. The software is built around the relational database framework. It allows data objects to be accessed by users using SQL language. Oracle is a completely scalable RDBMS architecture which is widely used all over the world.
- What are the benefits of Oracle?
The following are the advantages of choosing Oracle Database.
Portability. …
Market Presence. …
Version Changes. …
Backup and Recovery. …
Performance. …
Cursor Support. …
SQL Dialect. …
Multiple Database Support.
-
Basic Linux commands
-
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
-
Installing ORACLE And Database creation
-
Connecting to Database
-
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
-
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
-
Redo Log file management
-
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
-
Table space Management
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Related Courses
Sap Hana
SAP HANA ADMINISTRATOR COURSE SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. In SAP HANA, HANA stands for High-Performance Analytic Appliance. SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud.…
Leave feedback about this