RE: LOCAL_LISTENER

I do not run RAC. None of my databases use the default port 1521. None of my databases have LOCAL_LISTENER set.  

Gleaning through the responses seems to support either not setting it at all, or using the spfile if you do.  

Other than RAC responses, I did not receive reasons to set.. I ran across this when I created an 11g database with the dbca (the runInstaller) and the database would not start... (not right away but after I changed a few things).

Joel Patterson
Database Administrator
904 727-2546

From: Patterson, Joel
Sent: Thursday, October 15, 2009 3:26 PM To: Oracle-L Freelists
Subject: LOCAL_LISTENER    

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

--
http://www.freelists.org/webpage/oracle-l