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
已提問 1 年前檢視次數 1528 次
5 個答案
0

Enter image description here

AWS
已回答 1 年前
  • 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
已回答 1 年前
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
已回答 1 年前
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
已回答 1 年前
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
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南