This video lists the remaining three Oracle storage files and explains the function of the Oracle password file, the Oracle SPFILE, and the Oracle Alert Log.
- [Instructor] We have a few more database storage files…we need to talk about,…briefly, as we have already covered…most topics in this chapter.…Let's take a moment to talk about the database…Parameter File.…The database Parameter File also known as an SP file,…or server parameter file is a binary file that stores…the Oracle instance configuration parameters.…When you configure values for parameters that effect…your instance or your database,…parameters such as SJ max size or PGA aggregate target.…
Those parameters and their values are stored inside…the SP file.…Because the SP file is a binary file changing the values…for these or other parameters, needs to be done using…Oracle commands.…You can not edit the SP file directly.…If you lose your SP file, don't panic,…while you won't be able to start your database instance…without an SP file, as it contains all of the database…configuration options, you can simply recreate it.…
You will need to reconfigure all of the parameters,…recreate the SP file, and then you should be able…
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 Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
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 55s
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.