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
posta un anno fa1401 visualizzazioni
5 Risposte
0

Enter image description here

AWS
con risposta un anno fa
  • 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
con risposta un anno fa
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
con risposta un anno fa
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
con risposta un anno fa
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
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande