No responses/ ideas on this???
Well, let me explain my whole case..
i dont want my users using TNSNAMES for names resolution and come to me saying i am unable to access a particular database if any changes occured. I want all users to use ONAMES first in names.directory_path.
Also, in a high availability environment, i can specify failover stuff in connection thru ONAMES but users using TNSNAMES not knowing the details can make ordinary connection.
Is there any way for the Listener to find out how a service name is resolved (using TNSNAMES/ONAMES/HOSTNAME..) and then block certain requests?
Although its some crazy idea, i just want to know if an option exists!!!

-mano