I'm not exactly sure when it happened, but I've started noticing that some of the hosts in my Enterprise Manager grid have a target named UTILITY_DSN. Does anyone know what this is? The one I noticed today appeared after reinstalling the agent. It shows as a datatbase instance, but with a non-existent Oracle Home.

1 Answer 1


I know this is a very late answer, but I've only just seen the question. The name of the target and the circumstances under which it appears suggest to me that you are using heterogenous services (or one of the database specific gateway products) in order to connect to a non-oracle database. The configuration of these links requires the creation of a service in the listener.ora on the database server (amongst other things). When an agent attempts to discover databases on a host it follows the following rules.

  • parse /etc/oratab for databases listed there
  • parse $ORACLE_HOME/network/admin/listener.ora for statically registered databases
  • query the listener via lsnrctl to obtain service names.

Stage 2 of this process will pick up any non-oracle targets defined in listener.ora. You probably want to delete them.

  • 1
    Better late than never! Thanks for the reply. I have not consciously made use of any connections to non-oracle databases that I know of. Perhaps something was installed on these servers that caused this entry to be created. At any rate, I now have something to look for. This is a Windoze shop, so /etc/oratab isn't in play. Good info, thanks again.
    – DCookie
    Dec 22, 2011 at 15:33
  • @Niall please feel free to give late answers to any questions that take your fancy ;-) Dec 22, 2011 at 18:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.