Can we record incoming transactions through Listener? Yes, another feature of the listener service is that it can record the transactions made on it. So How to Register Listener in Oracle.<\/p>\n
For this, we can generate two types of log records. These are \u201d Listener Log \u201d and \u201d Trace Log \u201d<\/p>\n
For these log records we will use configuration parameters such as trc_directory, trc_level, log_file, log_directory and log_status.<\/p>\n
Recording the Listener service is especially used for trial and error users, and Trace is generally used for debugging.<\/p>\n
When there is a connection problem, it writes detailed information about the connection to the relevant file. But I must say that it is necessary to be careful while using it.<\/p>\n
We may encounter unexpected pauses because it will produce a serious record, and the disk will fill up with this feature turned on.<\/p>\n
We follow the below mentioned steps for configuration requirements:<\/p>\n
First we will set the location of the Registry directory.<\/p>\n
LSNRCTL> set log_directory <$ORACLE_HOME>\/network\/admin\r\n\r\n<\/pre>\nWe will give the name for our log file<\/p>\n
LSNRCTL> set log_file oratest.log\r\n\r\n<\/pre>\nWe will set the log_status status to on.<\/p>\n
LSNRCTL> set log_status on\r\n\r\n<\/pre>\nWe will save the changes.<\/p>\n
LSNRCTL> save_config\r\n\r\n<\/pre>\nYou can use the following parameters for the trace recording feature.<\/p>\n
TRACE_DIRECTORY_LISTENER = <$ORACLE_HOME>\/network\/trace\r\nTRACE_FILE_LISTENER = listener_log.trc\r\nTRACE_LEVEL_ = testdatabase<\/pre>\nTo turn it off, we can set the “Trace level” value to “OFF” instead of deleting the parameters.<\/p>\n
<\/div>\n