There are certain cases where you have to set it and I only set it only if database instance is otherwise not able to register itself with the required listener. Listeners running on non-default ports or listening on VIPs comes into mind. On Thu, Oct 15, 2009 at 3:25 PM, <Joel.Patterson@xxxxxxxxxxx> wrote: > > > Do all of you have a preference for putting LOCAL_LISTENER in the > tnsnames.ora file, or do you set the spfile? (alter system and remove it > from tnsnames). > > > > Do you use and set LOCAL_LISTENER at all? > > > > Preferences? Why? It seems to add just one more detail to starting, > recovery, so forth. > > > > I will be off now until Wednesday (as to any lack of back and forth by me). > > > > Thank you -- Alex Fatkulin, http://afatkulin.blogspot.com http://www.linkedin.com/in/alexfatkulin -- //www.freelists.org/webpage/oracle-l