Is it possible to configure or setup an alarm such that it gets fired when there is an entry (error or warning) in Oracle Alert Log file?
There are currently no alarm(s) that would be raised in response to errors or warnings in Alert log file. You would need to check the Alert Log for such details. You can view
the Alert Log by pressing (CTRL+N).
The Alert Log page shows the contents of the alert log file for Oracle databases. It contains a chronological list of messages and errors that have occurred for the database.
For a list of Oracle features that has Spotlight alarms, please refer to the Help menu and search for "spotlight on oracle alarms".