Solved

lsnrctl

Posted on 2010-11-25
5
1,073 Views
Last Modified: 2012-05-10
What are the different uses of lsnrctl utility..?
0
Comment
Question by:nobleit
  • 2
  • 2
5 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 34215356
start listener, stop listener, configure listener, show status/options of listener

that's it,  for more info on each of those ...

http://download.oracle.com/docs/cd/E11882_01/network.112/e10835/lsnrctl.htm#i554826
0
 

Author Comment

by:nobleit
ID: 34215392
I started from lsnrctl using start in one window and in another windows started up the database.
Then back to first window stop lsnrctl. Again back to datbase base window. I could see that database is still up. Could you explain the why database is still up?
Thanks..
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 300 total points
ID: 34215412
the listener is a separate process from the database.

they are started independently.  You don't "need" a listener for a database, you don't need a database for a listener.  Of course "using" the database is much easier if you have a listener, and a listener without a database doesn't have much to do when it's listening.

0
 

Author Comment

by:nobleit
ID: 34215468
So it is not interdependant..
0
 
LVL 8

Assisted Solution

by:Rindbaek
Rindbaek earned 200 total points
ID: 34215694
its an independent program and the database runs fine without it.

The listener handles the initial connection between the client software and the database. when the connection is establihed (the session created) then the listener doesn't have anything else to do with that connection.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now