Listener configuration and commands in Oracle Database
listener.ora file content
--------------------------------------------------
LISTENER_DATABASENAME =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
USE_SID_AS_SERVICE_LISTENER_DBNAME =ON
SID_LIST_LISTENER_DBNAME =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /path/to/oracle/home/dir)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = instance_name)
(ORACLE_HOME = /path/to/oracle/home/dir)
)
)
--------------------------------------------------------------------------------------------------------------------
tnsnames.ora file content :
----------------------------------------
DBNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)(HOST=HOSTNAME)(PORT=1521)
)
(CONNECT_DATA =
(SID = SIDNAME)
(INSTANCE_NAME = INSTANCENAME)
)
)
-----------------------------------------------------------------------------------------------------------------------------
Listener commands:
---------------------------------
$ lsnrctl status
$ lsnrctl start listener_name
$ lsnrctl stop listener_name
$ lsnrctl reload listener_name .......................(if you've modified listener.ora and want implement without stoping the listener)
