Solved

lsnrctl

Posted on 2010-11-25
5
1,074 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Wrap Oraccle SQL*Plus executable Command 4 83
Oracle - SQL Query with Function 3 34
Oracle - Query link database loop 8 37
Oracle Insert not working 10 22
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

813 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

9 Experts available now in Live!

Get 1:1 Help Now