Enable and Disable log status on Listener in Oracle
Listener can be configured in one of three modes:
Database: Provides network access to an Oracle database instance
PLSExtProc: Method for PL/SQL packages to access operating system executable
Executable: Provides network access to operating system executable
Enable or disable log of listener
--For Enable the log of listener
LSNRCTL> set log_status on
--For Disable the log of Listener
LSNRCTL> set log_status off
Remotely administer a Listener of database in oracle
Managed Database Server listener through Oracle Client Software like remote connection with IP address.
lsnrctl status 192.168.1.100
lsnrctl stop 192.168.1.100:1522
Change the log location in Listener
lsrnctl>set log_directory
lsrnctl>set log_file
lsrnctl>set log_status
Enable the logging of the Listener
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "log_status" set to ON
The command completed successfully
Check the log is enabled or disabled for Listener
LSNRCTL> show log_Status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter “log_status” set to ON
The command completed successfully
— Check the location of Log file
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter “log_file” set to D:\oracle\diag\tnslsnr\node1\listener\ale
rt\log.xml
The command completed successfully
–Check the location of directory
LSNRCTL> show log_directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter “log_directory” set to D:\oracle\diag\tnslsnr\node1\listene
r\alert
The command completed successfully
Disable the Listener log
LSNRCTL>
LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
Set the password for listener to make it Secure
LSNRCTL> set current_listener
LSNRCTL> change_password Old password:
New password:
Reenter new password:
LSNRCTL> set password Password:
LSNRCTL> save_config
Note: Following is the parameter need to mentioned in listener file for disable the Operating system authentication. you need to edit listener.ora file.
LOCAL_OS_AUTHENTICATION_ = OFF
For security purpose filter the IP Address which only connect through listener with database
Specify the client address for connectivity
$ORACLE_HOME/network/admin/sqlnet.ora file
tcp.validnode_checking = yes
tcp.invited_nodes = (x.x.x.x | name, x.x.x.x | name)
tcp.excluded_nodes=( x.x.x.x | name, x.x.x.x | name)
Note: Include either the invited_nodes or excluded_nodes, but do not use both.
Listener need to restart for setting the parameters.