An alert from the Oracle Usability Connection Availability is fired there is nothing wrong with the database availability. This happens approximately 15 minutes after starting the agent, but data is still collected in the agent pages.
Foglight Cartridge for Oracle has generated a Fatal alarm for Oracle cluster node MYNODE1-MYINSTANCE1.bnymellon.net on host HOSTNAME. Alarm: DBO - Usability Connection Availability (alarm group: Usability) Severity: Fatal Message: FOG0038OF. Database instance: MYINSTANCE1 on host HOSTNAME, the connection to the instance failed with this error: Failed to establish a Oracle JDBC connection protocol to Host [HOSTNAME-MYINSTANCE1], user account [MYUSER] . Reason : [Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor - Profile:OracleProfile{host='HOSTNAME', instance='MYINSTANCE1', username='MYUSER', asSysDBA=false, ports='1530', properties={oracle.jdbc.ReadTimeout=900000}}]. . [Oracle Error Code = 12505. SQL state : 66000].
Please verify and correct the hostname (if incorrect) in the Oracle RAC node agents
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center