for listener.ora file
LISTENER = (ADDRESS = (PROTOCOL = TCP)(HOST = ocm.localdomain)(PORT = 1521))
SID_LIST_LISTENER =(SID_DESC= (SID_NAME = clone)(ORACLE_HOME = /u01/oracle/product/database))
that's all
if the listener has muti address , then add address_list , and address is just one of the entry
below is the normal type of an listener in admin/samples folder.
# LISTENER =
# (ADDRESS_LIST=
# (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
# (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
# SID_LIST_<lsnr>
# List of services the listener knows about and can connect
# clients to. There is no default. See the Net8 Administrator's
# Guide for more information.
#
# SID_LIST_LISTENER=
# (SID_LIST=
# (SID_DESC=
# #BEQUEATH CONFIG
# (GLOBAL_DBNAME=salesdb.mycompany)
# (SID_NAME=sid1)
# (ORACLE_HOME=/private/app/oracle/product/8.0.3)
# #PRESPAWN CONFIG
# (PRESPAWN_MAX=20)
# (PRESPAWN_LIST=
# (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
# )
# )
# )
for tnsnames.ora
ocm=(description=(address=(protocol=tcp)(port=1521)(host=ocm))
(connect_data=(service_name=ocm))
(failover_mode=(type=select)(mode=basic)(retries=10)(delay=10)
)
for tnsnames.ora, key word description can't be omit and just like tns , key word address_list always can be omited. for fail_over see the text upper in red
a concludsion is that all the key words which contain "LIST" can be omited. DESCRIPTION_LIST , ADDRESS_LIST
FAILOVER_MODE Subparameter | Description |
---|---|
Specify a different net service name for backup connections. A backup should be specified when using | |
Specify the type of failover. Three types of Oracle Net failover functionality are available by default to Oracle Call Interface (OCI) applications:
| |
Determines how fast failover occurs from the primary node to the backup node:
| |
| Specify the number of times to attempt to connect after a failover. If Note: If a callback function is registered, then this subparameter is ignored. |
| Specify the amount of time in seconds to wait between connect attempts. If Note: If a callback function is registered, then this subparameter is ignored. |