Location of Listener Logs on AWS RDS Oracle database

You cannot view the listener log in the console. You have to enable the option to send the listener.log to Cloudwatch logs and then view the information from CloudWatch

Run this CLI command to find out what database logs are being sent to CW. You should see listener in the output of this command

aws rds describe-db-instances --db-instance-identifier <db name> | jq '.DBInstances[].EnabledCloudwatchLogsExports'

[ "listener" ]

CloudWatch Logs Export enabled for logs [audit, listener], but I still do not see listener logs, I checked the logs and events tab, I do not find them there. where are the listener logs exported after enabling the logs.

I also ran the query and did not find any data in there, is there anything else required to configure listener logs for AWS RDS Oracle database

SQL> select ORIGINATING_TIMESTAMP,MESSAGE_TEXT from listenerlog;

no rows selected

Search for your DB name in the CloudWatch log groups. I can see the listener entries for my DB in CloudWatch. I will try to find out if the query is supposed to work. It does not return any rows for my DB, so I'm not sure if that is supposed to work