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)