Enable and Disable log status on Listener in Oracle

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.