Stops the default listener or a specific listener on all nodes or the specified node. This command can also be used to stop a listener on a noncluster database from the noncluster database home. However, SRVCTL does not accept the -node parameter when run from a noncluster database home.
Displays the status for all SCAN listeners, by default, or a specific listener. Note: This command is only available with Oracle Clusterware.
Start/ Stop / Relocate SCAN listener in Oracle 11gR2 RAC
- Start/ Stop / Relocate SCAN listener in Oracle 11gR2 RAC.
- 1) Check listener status ( login to grid home)
- a) Check the cluster resource status.
- b) Check the scan listener status.
- c) Check the listener home.
- 2) Start scan listener:
- a) Start scan listener.
How to Start and Stop Local Listener and SCAN Listener (RAC Basic Command) First check which services are running from which nodes. Run from the grid user. CRS-4133: Oracle High Availability Services has been stopped.
Displays the
status of
listener resources.
Syntax and Parameters.
| Parameter | Description |
|---|
| -node node_name | Name of a cluster node. Note: This parameter can be used only for Oracle Clusterware. |
| -verbose | Displays verbose output. |
To create a SCAN listener, use the srvctl add scan_listener command. To create a management listener (for the CHM repository), use the srvctl add mgmtlsnr command. Specify a listener name. This parameter is optional.
The ASM network is the communication path in which all the traffic between database instances and ASM instances commence. There will be local ASM listener runs on each node where the flex ASM instance is running.
Just follow the below steps :
- Shutdown Oracle Home process accessing database.
- Shutdown RAC Database Instances on all nodes.
- Shutdown All ASM instances from all nodes.
- Shutdown Node applications running on nodes.
- Shut down the Oracle Cluster ware or CRS.
How Can I Check Whether the Oracle Listener Is Started
- Log in to the SUSE Linux as user oracle.
- On the command line interface (CLI), run the following command to view the state of the Oracle listener: > lsnrctl status Listener name.
ora file is located in the ORACLE_HOME/network/admin directory. The listener. ora file can also be stored the following locations: The directory specified by the TNS_ADMIN environment variable or registry value.
Default
listener name is '
LISTENER'.
Resolution
- Select Listener configuration, click Next.
- Select Add, click Next.
- Choose a listener name, click Next.
- For selected protocols, select TCP, click Next.
- Enter in the port used to connect to the oracle database, click Next.
- Select No to configure another listener, click Next.
The ORA-12541 message reads, “TNS no listener.” This happens if the listener is either down as it attempts to make a connection or if it has not been started or improperly configured. In addition, it may be caused by a connectivity problem with the network.
The process known as Oracle TNSLSNR Executable or Oracle Database (version 10g Express Edition) or Oracle SQL*Net ORAN DLL or OracleXETNSListener belongs to software Oracle Database (version 10g Express Edition, 11g Express Edition) or www.oracle.com or PL/SQL Developer or OracleOraDb11g_home1TNSListener by Oracle (www
An HTTP listener, also known as a network listener, is a listen socket that has an Internet Protocol (IP) address, a port number, a server name, and a default virtual server. Each virtual server provides connections between the server and clients through one or more listeners.
Create a listener in Oracle Database 19c using Oracle Network Manager
- Start Oracle Network Manager from Windows start menu.
- Give a name to the listener and click “OK”.
- Next, select “Listening Locations” and click on “Add Address” to indicate the server remote access details.
: one who listens to someone or something a radio program with many listeners a friend who's a good listener [=who listens attentively and sympathetically] Fanny, being always a very courteous listener, and often the only listener at hand, came in for the complaints and distresses of most of them.—
The listener. ora file is the configuration file for a listener. It can include the protocol addresses it is accepting connection requests on, a list of the database and other services it is listening for, and control parameters used by the listener.
- add SCAN IP to tnsnames. ora for RDBMS $ORACLE_HOME on all three RAC nodes.
- modify the sqlnet.ora to allow ezconnect.
- modify the remote_listener parameter. SQL> alter system set REMOTE_LISTENER='REMOTE_LISTENERS_SCAN' scope=both sid='*';
- Try to use the scan name that failed before, it's ok this time. WTF!
How to Configure an Oracle Grid Infrastructure SCAN Listener
- As the database user, log in to Oracle Database using SQL*Plus.
- Ensure that the local_listener parameter contains the local listener IP number and port number.
- Ensure that the remote_listener parameter refers to the SCAN name and port number.
- On each cluster node, ensure that the tnsnames.
SCAN works by replacing a hostname or IP list with virtual IP addresses (VIP). Unlike a regular listener where the listener is accessed via a DNS hostname or IP address, a SCAN listener uses a list of domain names, allowing Oracle to assign incoming connections to a server using their own least-recently-used algorithm.
The local listener, or default listener, is located in the Grid home when you have Oracle Grid Infrastructure installed. During Oracle Database creation, the LOCAL_LISTENER parameter is automatically configured to point to the local listener for the database.
So in short, always SCAN LISTENER and SCAN VIP are related to each other. Node VIP: Node VIP is the IP address which has capability of relocating to local listener of other node when the current node goes down. You can identify the IP address assigned to node VIP will be a part of LOCAL listener.
Port Numbers and Protocols of Oracle Components
| Default Port Number | Port Range | Protocol |
|---|
| 1521 (same value as the listener) | 1521 | TCP |
| 1630 | 1630 | TCP |
| 3938 | 1830–1849 | HTTP |
| 1158 | 5500–5519 | TCP/HTTP |
How to find Grid Home Location in Oracle ?
- When Cluster is up and running: When Cluster ware is up and running then it becomes easy for a remote DBA to find out the GRID_HOME path using below query.
- When Cluster is not up and Running: What if Cluster is not up and running.
- Ora Inventory Location:
Starting Cluster in exclusive mode do not requires VD and network.
- Following is the syntax.
- -excl Starts clusterware in exclusive mode.
- -nocrs Starts Clusterware with out CRS.
- -cssonly Starts CSS only.
- -wait Wait until the crs started completely and display all progress and status.
SOLUTION
- Connect to node #1, then please check if the CRS/OHAS & services are enabled to autostart as follow (repeat this step on each node):
- If not, then you can enable it as follow (repeat this step on each node):
- Shutdown the services on each node as follow:
Shutdown and Start sequence of Oracle RAC
- To start and stop oracle cluster resources running on all nodes :
- To check the current status of a cluster : [oracle@node1~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online.
CRDS – The CRS Daemon is the main background process for managing the HA operation of the service. Basically, it manages the application resources defined within the cluster. It manages the basic cluster locking, understands the nodes and its membership status. EVMD – This is event management logger.
Useful CRSCTL commands
- STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs.
- Enable/Disable auto restart of CRS.
- Find the cluster name $GRID_HOME/bin/cemutlo -n or $GRID_HOME/bin/olsnodes -c.
Cluster Ready Services (CRS) and cluster synchronization service (CSS) CRS is responsible for managing HA options within the cluster. The crsd process manages CRS operations. CRS manages two kinds of resources: Cluster resources.
Stopping and Starting RAC Services
- emctl stop dbconsole.
- srvctl stop listener -n racnode1.
- srvctl stop database -d RACDB.
- srvctl stop asm -n racnode1 -f.
- srvctl stop asm -n racnode2 -f.
- srvctl stop nodeapps -n racnode1 -f.
- crsctl stop crs.
