Multiple choice technology databases

What file will give you Oracle instance status information?

  1. alert.ora

  2. init.ora

  3. tnsname.ora

  4. redolog
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The alert log (alert.log or alert.ora) is the primary file containing Oracle instance status information, errors, and significant events. It records startup/shutdown, errors, checkpoints, and other critical instance information. init.ora contains initialization parameters, tnsnames.ora has network connection strings, and redolog files contain redo data - none provide instance status.

Keep practicing — related questions