Sample Listener and Tnsnames files in 11g RAC

The contents of Listener.ora and tnsnames.ora in 11g RAC are shown below.



#listener.ora


LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent




#tnsnames.ora

# tnsnames.ora Network Configuration File: /project/oracle/orabase/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.


BVNPRD =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = crs-scan)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = bvnprd)

)

)




#endpoints_listener.ora

LISTENER_IBS-ASH-SR147=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ibs-ash-sr147-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.192.154.205)(PORT=1521)(IP=FIRST)))) # line added by Agent



Have a question or comment? Post it below!