To troubleshoot issues when using the OEM_AGENT option with your RDS for Oracle instance, review the OEM agent logs after exporting these logs to Amazon CloudWatch. For more information on OEM_AGENT prerequisites, see Oracle Management Agent for Enterprise Manager Cloud Control. Make sure that the firewall between OMS and RDS allows traffic on both the DB listener port and OEM Agent port.Īfter you complete these checks, check if OEM_AGENT upload is working. Verifying the configurations rules out the possibility of blockers or an explicit deny.ĥ. Check your network configurations, including network access control lists (ACLs) and route tables. Run a telnet test from the Oracle Management Service (OMS) server to your DB instance on the OEM agent port and database port to check connectivity.Ĥ. The security group of your DB instance must allow OMS_HOST to listen to the OEM_AGENT port (default is 3872) and the RDS port (default is 1521).ģ. Check your DB instance's network configuration. If the events indicate an issue with the installation of the OEM_AGENT option or network configuration, then be sure that the succeeding prerequisites are met.Ģ. You can also use the AWS CLI command describe-events. You can verify the installation status of the OEM_AGENT option by reviewing the Events section of your Amazon RDS DB instance from the AWS Management Console. If the option group status is INVALID, then the OEM_AGENT isn't installed successfully due to issues with the network configuration setup and other prerequisites. "OptionGroupName": "custom-oracle-option", If the option group status is in-sync, then you get the following output: [ Verify the output to be sure that the option group status is in-sync. Note: If you receive errors when running AWS CLI commands, make sure that you’re using the most recent version of the AWS CLI. Check the option group status after adding the OEM_AGENT option to the option group and applying option to the DB instance by running the following AWS Command Line Interface (AWS CLI) command: aws rds describe-db-instances -db-instance-identifier -query 'DBInstances.' Note: Before proceeding with the troubleshooting steps, run the following pre-checks on your DB instance:ġ. You might receive one of the errors described in this article when using the OEM_AGENT option with your Amazon RDS for Oracle DB instance. Amazon RDS supports the Oracle Enterprise Manager (OEM) Management Agent through use of the OEM_AGENT option.
0 Comments
Leave a Reply. |