- From: Dan Norris <dannorris@xxxxxxxxxxxxx>
- To: "Joel.Patterson@xxxxxxxxxxx" <Joel.Patterson@xxxxxxxxxxx>
- Date: Thu, 15 Oct 2009 12:55:32 -0700
I only set it in RAC environments an then it goes in the spfile.I prefer to set the parameter to the full connect descriptor instead of setting it to a name that is resolved via a name service (i.e. tnsnames). That's a personal preference as I don't see any advantage to making it a lookup.
Dan Typos included courtesy of large thumbs. On Oct 15, 2009, at 12: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
- From: Joel.Patterson