Monday , December 4 2023

How To Register Listener In Oracle

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.

For this, we can generate two types of log records. These are ” Listener Log ” and ” Trace Log ”

For these log records we will use configuration parameters such as trc_directory, trc_level, log_file, log_directory and log_status.

Recording the Listener service is especially used for trial and error users, and Trace is generally used for debugging.

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.

We may encounter unexpected pauses because it will produce a serious record, and the disk will fill up with this feature turned on.

We follow the below mentioned steps for configuration requirements:

First we will set the location of the Registry directory.

We will give the name for our log file

We will set the log_status status to on.

We will save the changes.

You can use the following parameters for the trace recording feature.

To turn it off, we can set the “Trace level” value to “OFF” instead of deleting the parameters.


About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *