- 24 May, 2022
- 0 Comments
- 6 Mins Read
RAC LISTENERS -learnomate
Listeners in RAC
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.
You can modify the configuration of the listeners used by Oracle Clusterware and Oracle RAC with Server Control Utility (SRVCTL) commands, or by using NETCA. Manual editing of the listener.ora file is not required.
Each listener is configured with one or more protocol addresses that specify its listening endpoints. The listener agent dynamically updates endpoints with the listener. Starting with Oracle Database 11g Release 2, the listener.ora file now only contains an IPC key and the following information:
(ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=1521))
The listener.ora file is the same on every node for an Oracle RAC database. Listening endpoints, such as the port numbers, are dynamically registered with the listener.
Before you install Oracle RAC, during the Oracle Grid Infrastructure installation, NETCA creates and starts a default listener in the Grid home called LISTENER. The listener is configured with default protocol listening addresses. The listener is configured to respond to connection requests that are directed to one protocol address specified during installation.
During the Oracle RAC installation, the Oracle RAC database uses the listener in the Grid home, and configures service information about the Oracle RAC database. The database services automatically register their information with the listener, such as the service name, instance names, and load information. Dynamic service registration eliminates the need for static configuration of database services.
1 2 3 4 5 | srvctl config listenerTo change default LISTENER port,user,homesrvctl modify listener -1 LISTENER -p TCP:1545srvctl modify listener -l LISTENER -u rootsrvctl modify listener -1 LISTENER -o /u01/app/oracle/product/19.0.0.0/dbhome_1 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | oracle$cd $ORACLE_HOME/network/adminCat listener.oralsnrctl status LINTENER_primlsnrctl start LISTENER_primalter system set local_listener ='(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.81)(PORT=1522))))' scope=BOTH SID='prim1';alter system set local_listener ='(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.82)(PORT=1522))))' scope=BOTH SID='prim2';alter system register;Show parameter localShow parameter listenerroot$crsctl stat res -t>>>>verify that LISTENER_prim not registered with the cluster |
1 2 3 | 1.crsctl stop crs -f2.ps -ef|grep smon or tns(All services will stop but LISTENER_prim will not stop.we need to manually stop database listener3.crsctl start crs |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | lsnrctl status LISTENER_primlsnrctl stop LISTENER_primlsnrctl status LISTENER_primFail Attemp:(default it will add to GI Home)oracle$srvctl add listener -l LISTENER_prim -p 1522srvctl start listener -l LISTENER_primGrid Ownergrid$srvctl add listener -l LISTENER_prim -p 1522srvctl start listener -l LISTENER_primsrvctl status listener -l LISTENER_primlsnrctl status LISTENER_primcrsctl stat res -toracle$ps -ef|grep tnsgrid $cd /u01/app/oracle/product/19C/dbhome/network/admin>>>>>>>>>>Verify LISTENER_prim added now |
1 2 3 4 5 6 | srvctl add listener -l LISTENER_prim -p 1522srvctl start listener -l LISTENER_primsrvctl status listener -l LISTENER_primlsnrctl status LISTENER_primlsnrctl stop LISTENER_primlsnrctl status LISTENER_prim |
1 2 3 4 | Oracle $lsnrctl status LISTENER_primlsnrctl stop LISTENER_primsrvctl config listener -l LISTENER_prim |
1 2 3 4 5 6 7 | Grid $lsnrctl stop LISTENER_primLsnrctl stop LISTENER_primsrvctl remove listener -l LISTENER_primcdcat listener.ora>>>>>remove manually LISTENER_prim entry |
1 2 3 4 5 | grid $Srvctl add listener -l LISTENER_prim -p 1522 -o grid homeSrvctl config listener -l LISTENER_primSrvctl status listener -l LISTENER_primsrvctl start listener -l LISTENER_prim |
1 2 | grid $srvctl remove listener -l LISTENER_prim |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | oracle $Srvctl add listener -l LISTENER_prim -p 1522 -o u01/app/oracle/product/19C/dbhomesrvctl config listener -l LISTENER_primSrvctl status listener -l LISTENER_primSrvctl start listener -l LISTENER_primsrvctl status LISTENER_primLsnrctl stop LISTENER_primLsnrctl status LISTENER_primLsnrctl start LISTENER_primcrsctl stop crs -f>>>>>will bring down local listener also along with the cluster listenerCrsctl start crs>>>>> will bring up your local listener also along with the cluster listenerVerify:oracle $Cd $ORACLE_HOME/network/adminCat tnsnames.orasqlplus sys/pw@prim_SCAN as sysdbaSqlplus sys/pw@prim_VIP as sysdbaThe SCAN bundleGrid $Srvctl add scan -hAdds SCAN VIP to the oracle ClusterUsage:srvctl add scan -n-n-S //[if1[if2…]]NET address spec for network-h print usagesrvctl modify scan -scanname nodescanNote:SCAN cal only operate on one network/in one subnet. |
How to verify the ASM Listener and SCAN listener?
=================================
Grid $
cd $ORACLE_HOME/network/admin/
Cat listener.ora
Lsnrctl status LISTENER
lsnrctl status LISTENER_SCAN1
Lsnrctl status
>>>Default it will be pointing to GI Listener (LISTENER)
crsctl stat res -t
>>>>verify ora.LISTENER.lsnr and ora.LISTENER_SCAN1.lsnr services
Service Creation at cluster level
=========================
Srvctl add service -d prim -s Myservice -r prim1 -a prim2 -P BASIC
srvctl status service -d prim -s Myservice
srvctl start service -d prim -s Myservice
srvctl status service -d prim -s Myservice
Srvctl config service -d prim -s Myservice
Srvctl modify service -d prim -s Myservice -P NONE
Srvctl remove service -d prim -s Myservice
srvctl add service -d prim -service SRV_RMAN -preferred prim1,prim2
srvctl add service -db prim prim -service Myservice -oldinst prim1 -newinst prim2
Adding local LISTENER LISTENER_prim to the cluster
. oraenv
prim1
Srvctl add listener -l LISTENER_prim -p 1522 -o /u01/app/oracle/product/19C/dbhome
. oraenv
prim2
Srvctl add listener -l LISTENER_prim -p 1522 -o /u01/app/oracle/product/19C/dbhome
Verifying
srvctl config listener -l LISTENER_prim
Ps -ef|grep tns
[/php]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | . oraenvprim1env |grep ORAORACLE_SID=prim1ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/19C/dbhomecd $ORACLE_HOME/network/adminvi listener.oraLISTENER_prim =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.81)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = prim)))ADR_BASE_LISTENER_prim = /u01/app/oracle. oraenvprim2env |grep ORAORACLE_SID=prim2ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/19C/dbhomeLISTENER_prim =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.82)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = prim)))ADR_BASE_LISTENER_prim = /u01/app/oracle |
How to find the SCAN information?
1 | Srvctl config SCAN |
How to find the Listener information?
1 | srvctl config listener |
How to find the network information?
1 | Srvctl config network |