Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 5 down vote favorite

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.

share|improve this question

1 Answer

up vote 4 down vote accepted

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.

share|improve this answer
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 '11 at 15:33
@Niall please feel free to give late answers to any questions that take your fancy ;-) – Jack Douglas♦ Dec 22 '11 at 18:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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