srvctl stop listener
srvctl stop su Oracle
With the article “srvctl stop listener,” we provide the command to stop the Oracle listener on a node of an RAC through CRS.
As indicated in the article srvctl start listener, the LISTENER is the process that allows network connections to the database.
Specifically, it handles the connection request from the application server to the database. When an external call comes in through the connect string, typically via the hostname, port (usually 1521), and instance name, the LISTENER is contacted. It initially guides the OS process to the DB.
Once the process is communicated on another port of the DB and the application session is generated, the process is detached from the LISTENER, which then resumes its regular function.
In environments without CRS, the command for managing the listener is lsnrctl, through which we can enter the LSNRCTL> shell. Alternatively, without entering the shell, we can directly execute commands to stop, start, or reload the LISTENER.
However, in RAC environments where resources are managed with CRS commands, we should not use the lsnrctl command but srvctl since it’s registered as a service.
Below is the mini-guide for stopping the listener in RAC environments
Before executing the stop, check the status of resources with the command:
crsctl status res -t
The command to execute srvctl stop listener is:
srvctl stop listener -n <nome_nodo> -l <nome_listener>
Example:
srvctl stop listener -n car_test_01 -l LISTENER_DBTESTp1
Once the command prompt is returned, recheck the status of resources with the command:
crsctl status res -t
To view my guides on CRS Commands click here!
At this LINK, instead, you’ll find the SQL queries.
Stay updated on our activities by joining our community (make sure to like our pages, let’s connect, and stay updated on each of our new guides!):
Facebook
Youtube
Linkedin
For those who haven’t done so yet, we recommend saving this site among your bookmarks.
So you’ll always have our solutions to the most common database problems at your fingertips, especially Oracle databases.
0 Comments