Question: What is a the local_listener
parameter and and how does it differ from an ordinary listener?
When do I need to specify a local listener in my spfile?
Answer: A local listener is specified in your
pfile/spfile startup deck when you database an instance with
multiple listeners.
The local_listener init.ora parameter specifies a
network name that resolves to an address or address list of Oracle
Net local listeners and it is used used ONLY when you have multiple
listeners that are running on the same machine as this instance.
The local_listener service name, address or address list
is must be specified in the tnsnames.ora file or you will get an
ORA-00119 error.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
