Modern Oracle DBA

Listener: Listener process running the database node that listen for incoming the connection on database. The name of the listener listener.ora file Listener file default location “$ORACLE_HOME/network/admin Listener process listen for more than one database. listener.ora file: The default settings for the listener.ora file contains the below parameters Listener name Port number Protocols SID name Host name Listener commands: lsnrctl start <listener_name> Starting the listener lsnrctl stop <listener_name> Stops the listener lsnrctl status <listener_name> Display the status information about the listener. lsnrctl reload We can use add/change without stopping the listener. lsnrctl help Display the list of all listener commands lsnrctl version Display the current listener version lsnrctl services Display the detailed information about services and instance registred and service h