Oracle database Listener Basic commands


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 handlers allocated each instance

Enable trace on listener

Change below parameter in listener level

lsnrctl > show trc_level

lsnrctl > show trc_file
Display the default name of the trace file

lsnrctl > show trc_directory
Display the default trace location of the listener

lsnrctl >set trc_level admin

Comments

  1. Your Affiliate Money Printing Machine is ready -

    And making profit with it is as simple as 1-2-3!

    This is how it works...

    STEP 1. Input into the system which affiliate products the system will advertise
    STEP 2. Add some PUSH button traffic (this LITERALLY takes 2 minutes)
    STEP 3. Watch the affiliate system explode your list and sell your affiliate products for you!

    Are you ready to make money automatically?

    The solution is right here

    ReplyDelete

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2