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 to start up your instance. However, it's often times easier to just include the SP file as part of your normal database backups. I mean why work hard when it's not required, right? Next in line is the database Password File. The database Password File stores the password for the Oracle administrator user, also known as the SYSDBA user.
This is basically the most powerful user in the Oracle database. This user has the privileges to do, well, anything. Access all the data that is stored in the database, modify all configuration options, everything. The Password File is created when you set up your Oracle database for the first time and supply a password for this very powerful SYSDBA user. Note that you can the password for the SYSDBA user anytime you want, that in turn will also modify the password inside the password file.
Oh, and one more important thing to remember, the Password File only stores the password for the SYSDBA user, not for any of the other database users, such as application users. These users and their password are stored inside the Oracle database, specifically as part of the Oracle Data Dictionary which is contained inside the system table space. And last but definitely not least the Oracle Alert Log File, or alert file, or just log file.
It's basically the name of the Oracle arrow log file. The Oracle alert log file contains a chronological list of messages, alerts, errors, and basically anything that happened to your database since it was initially created. It contains any errors that might prevent your database from functioning properly, so this is your go-to file in case you're trying to troubleshoot a problem with your database. That's another way of saying that the alert file is a DBA's best friend.
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