Location of Listener Logs on AWS RDS Oracle database

0

Where can I find the listener logs for AWS RDS Oracle databases. I can only find alert logs and audit logs in the AWS console but not listener logs

raja
gefragt vor einem Jahr1404 Aufrufe
5 Antworten
0

Enter image description here

AWS
beantwortet vor einem Jahr
  • Thanks Naveen, yes I am able to see the listener logs in CloudWatch log groups.

0

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" ]

AWS
beantwortet vor einem Jahr
0

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.

raja
beantwortet vor einem Jahr
0

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

raja
beantwortet vor einem Jahr
0

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

AWS
beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen