Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Server & Application Monitor (SAM) > Oracle User Experience Monitor error: ORA-12545 Connect failed because target host or object does not exist

Oracle User Experience Monitor error: ORA-12545 Connect failed because target host or object does not exist

Updated: November 4, 2016

Overview

When monitoring the Oracle RAC instance using the Oracle User Experience monitor with Oracle drivers, the following error displays:

ORA-12545: Connect failed because target host or object does not exist

Environment

  • All versions of SAM
  • Oracle RAC instances

Cause 

The SolarWinds server and the Oracle servers are split across two domains. When SAM attempts to poll the Oracle database residing on the Oracle RAC, it uses the host name which does not fully qualify it. Without it being fully qualified, the Orion server will be unable to resolve it correctly.

 

As this is a RAC instance, some of the host names (if present in same domain), may be able to resolve correctly. When the TAF listener redirects it to another member of the RAC, it is unable to resolve and will throw the ORA-12545 error.

Resolution

  1. Open a Remote Desktop connection to the Orion server or polling engine.
  2. Go to C:\Windows\system32\drivers\etc.
  3. Open the hosts file with Notepad.
  4. Add all possible combinations of the host names and FQDN entries here for the Oracle databases. This ensures that the Oracle driver can always correctly resolve the Oracle database to the correct address.
 

 

Last modified

Tags

Classifications

Public