Listener

Init file of listener: $ORACLE_HOME/network/admin/listener.ora

Log file of listener: $ORACLE_HOME/network/log/

lsnrctl start / status / stop lsnr_name

set current_listener lsnr_name

set password lsnr_password

Example of listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = ORACLE_HOME)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = GLOBAL_NAME)

(ORACLE_HOME = ORACLE_HOME)

(SID_NAME = ORACLE_SID)

)

)