This video identifies the role of the database alert log file and locate it in our Linux server.
- [Narrator] The Oracle database error log file…is called the alert log.…It contains a chronological list of events,…errors, warnings, everything that has occurred…in the database since it was created.…It's the go to file when a DBA needs to troubleshoot…infrastructure problems of the Oracle database.…The alert log file is a plain text file…we can easily open with any text editor.…Let's start off by searching…for the location of the alert log.…
It's placed in a subdirectory inside…our Oracle base directory.…We can see the value of our Oracle underscore base directory…by typing echo $Oracle_BASE…into the Linux prompt.…Remember environment variables such as Oracle base…as well as others need to be configured by the DBA.…So let's go and open the Oracle base directory.…
Cd /u01/app/oracle.…Inside the Oracle base directory,…we have a sub directory called diag short for diagnostics.…Let's go into that directory.…Under the diag directory,…we will need to go into the RDBMS subdirectory…because we are looking for the error log…
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
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.