This video presents the four important steps in the Oracle database startup sequence as well as list the commands used to startup the Oracle database.
- [Instructor] Let's talk about the Oracle Database…startup and shutdown sequence.…Yep, it's a sequence,…not a single on or off state.…There are actually multiple steps involved…each time you start up or shut down…your Oracle Database.…Let's start by talking about the startup sequence.…When your database is down, that is, offline,…it means there is no Oracle instance running on the server.…The database files are safe on your database storage,…but no one can access your data.…
When you issue an Oracle startup command,…our end goal is to get the instance up and running…so that it can read and write data…from the Oracle Database storage.…This is also known as an open state for the database.…The process of reaching an open state…for the Oracle Database is as follows:…First in the sequence of events leading to an open state,…is a nomount state.…This is when the Oracle instance…has been created in memory, that is,…you got the Oracle program running on your server.…
All of the SGA memory cache has been allocated,…and the background processes are all running.…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Fundamentals: Core Conceptswith Adam Wilbert2h 14m Beginner
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 58s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.