Question: I am having trouble writing my
listener.ora file and I wonder if I could see a sample listener.ora
file to use as a template.
Answer: Most people clone their listener.ora file from
existing systems, so this is a good approach.
Here is a sample listener.ora
file for a RAC cluster database:
Listener_Test=
(description=
(load_balance=on)
(address=(protocol=tcp)(host=testlinux1)(port=1521)
(address=(protocol=tcp)(host=testlinux2)(port=1521)
(connect_data=
(service_name=test)))
listener_test1=
(description=
(address=(protocol=tcp)(host=testlinux1)(port=1521)
sid_list_listener_test1=
(sid_list=
(sid_desc=
(oracle-home=/u01/app/oracle/product/9.2.0.2)
(sid_name=test1)))
If a port other than 1521 is utilized, then the
local_listener parameter in that instances local init.ora file must
be set to the same port value. For example, if we used port 1525
instead of 1521, all references to port 1521 in the listener.ora
would be changed to 1525:
local_listener="(address=(port=1525)(protocol=tcp)(host=testlinux1))"
Here are some sample listener.ora files:
LISTENER =
(DESCRIPTION_LIST
=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dnsname)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/xxx)
(PROGRAM = extproc)
)
(SID_DESC
=
(GLOBAL_DBNAME = mysid.com)
(ORACLE_HOME =/u01/app/oracle/product/xxx)
(SID_NAME = mysid)
)
)
Oracle Corporation also provides a
sample listener.ora file for use as a template:
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=sales.us.acme.com)
(ORACLE_HOME=/oracle9i)
(SID_NAME=sales))
(SID_DESC=
(SID_NAME=plsextproc)
(ORACLE_HOME=/oracle9i)
(PROGRAM=extproc)))
|
|
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.
|