Checking the Listener status and the listener uptime in Oracle database

Today We talk about Oracle Net Listener

What Is ORACLE NET LISTENER ?

Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server
Using Of Oracle Net Listener Command


Input this command
$  
$ lsnrctl status <Listener name>
Output ( Example)
lsnrctl status LISTENER_PROD
LSNRCTL for HPUX: Version 11.2.0.4.0 – Production on 10-Jun-2016 13:39:35

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PROD.WORLD))
STATUS of the LISTENER
————————
Alias                     LISTENER_PROD
Version                   TNSLSNR for HPUX: Version 11.2.0.4.0 – Production
Start Date                03-JUN-2016 20:10:59

Uptime                    6 days 18 hr. 24 min. 46 sec

Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF




Stay Update with Us for more 🙂

Comment and share with your friends


JOY DUTTA
नमस्ते _/\_ to all . This is JOY DUTTA working in Spark Minda group as a IT Engg from last 4 years , I completed my Diploma from Goverment Polytechnic Dehradun in Computer Science And Engg in 2011.

Well, above i written my Qualification and My JOB Role. now i am tell you about Who am i as a person. I am a fun loving guy who love Acting, Dancing, Hangout with friends, I believe in Smart work Rather Than Hard work. I love computers because I love Computers :)

In short I am interesting guy if you want reveals more about me You should to meet me. if that not possible

Mail me :- joydutta14@gmail.com
or Join me on Facebook:- https://www.facebook.com/joydutta.me

JOY DUTTA

नमस्ते _/\_ to all . This is JOY DUTTA working in Spark Minda group as a IT Engg from last 4 years , I completed my Diploma from Goverment Polytechnic Dehradun in Computer Science And Engg in 2011. Well, above i written my Qualification and My JOB Role. now i am tell you about Who am i as a person. I am a fun loving guy who love Acting, Dancing, Hangout with friends, I believe in Smart work Rather Than Hard work. I love computers because I love Computers :) In short I am interesting guy if you want reveals more about me You should to meet me. if that not possible Mail me :- joydutta14@gmail.com or Join me on Facebook:- https://www.facebook.com/joydutta.me

Leave a Reply

%d bloggers like this: