Amazon RDS Oracle Database and Alert and Listener Log

To see the oracle alert log and listener log data on Oracle RDS at Amazon RDS, we utilize sql.

For Alert Log:
select message_text from alertlog;

For listener log
select message_text from listenerlog;

Note: only last 10 MB of entries in these files are available since oracle is rotating them at 10mb interval so if you need history this might be a good candidate for nightly job.

More information can be found in AWS api rds-ug.pdf