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 file (alert.ora or alert.log) is the primary location for Oracle instance status information, recording startup/shutdown events, errors, and significant operational messages. The init.ora file contains initialization parameters, tnsnames.ora handles network configuration, and redo logs store transaction changes - none provide instance status.