Solved

lsnrctl

Posted on 2010-11-25
5
1,078 Views
Last Modified: 2012-05-10
What are the different uses of lsnrctl utility..?
0
Comment
Question by:nobleit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 74

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 74

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

623 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