web analytics
tnsrctl - Oracle Listeners Management Options
codeling
Posted: Thursday, December 8, 2016 1:35:41 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 738
Points: 3102

The database listener process reads the listener.ora and sqlnet.ora files for its configuration; the database administrator (DBA) manages it by using the lsnrctl command-line utility. You can use the utility to do these things to the listener:

Start

Stop

Check status

There is no direct relationship between the listener process and the database itself; the processes operate independently.

Sponsor
Posted: Thursday, December 8, 2016 1:35:41 PM
codeling
Posted: Thursday, December 8, 2016 1:37:45 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 738
Points: 3102

To start the listener, issue the lsnrctl start command:

c:\> lsnrctl start

If you need to stop the listener, you can issue the lsnrctl stop command:

c:\> lsnrctl stop

To determine what databases the listener is configured to service requests, you can read the listener.ora configuration file. Or you can issue the lsrnctl status command:

c:\> lsnrctl status

codeling
Posted: Thursday, December 8, 2016 1:40:51 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 738
Points: 3102

After changing the listener.ora file, you must restart the listener process. You can do this via the stop and start commands.

Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2017 Digcode.com. All rights reserved.