004 - Listeners in Oracle RAC - remote_listener - local_listener - Real Application Cluster Listener

Hi Friends,
Welcome you back on exciting topic, today’s session is on
Listeners in Oracle RAC - Real Application Cluster
=========================================
srvctl config listener
Can you define another port? - YES
[GRID] srvctl modify listener -l LISTENER -p TCP:1545
Can you define another owner? - YES
[GRID] srvctl modify listener -l LISTENER -u root
Can you define another home? - YES, if really needed.
[GRID] srvctl modify listener -l LISTENER -o /u01/app/oracle/product/11.2.0/dbhome_1
Can I add another listener on another port? - YES
[GRID] srvctl add listener -l ListenerK2 -p 1544 -k 2
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=rac1.localdomain.com)(PORT=1522))))' scope=both SID='DEVDB1';
ALTER SYSTEM REGISTER;
#Listener #local_listener #RAC #Exadata #Oracle #Database
Please do follow me and support me on,
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Email: [e-mail]
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...

[@sadanb4876]

Really awesome notes and explanation... Really appreciate sir

[@Mallik034]

Thanks Sadan

[@AbhishekSingh-bx6ov]

Very nice explanation

[@Mallik034]

Thanks and welcome

[@stalinjaviermaciasgomez3676]

Correct me if I'm wrong, please.
If we don´t have a local listener in X node, the SCAN listener will try to establish a connection but it will fail, therefore it will try to connect to another node until it finds an available local_listener to connect to the database.
The advantage of having a local_listener in the nodes is to receive the incoming connections to connect to the database. This can be translated as load balancing, SCAN listener will try to establish a connection to the listener with less load.
Thanks for your tutorials Malik, they have been very useful. Regards.

[@Mallik034]

Nopes its not like that.
If you have local listener then scan will pass the connection to local listener otherwise scan it self will connect to database.

[@Mallik034]

If you need more detailed explanation please ping on our Telegram group @mallik034

[@stalinjaviermaciasgomez3676]

@@Mallik034 how can I join the telegram group?

[@Mallik034]

@@stalinjaviermaciasgomez3676 you can install the Telegram App and search for @mallik034

[@IndiraVlog--]

Nice explained 👍👍

[@SK-lu9wk]

Very informative session. Waiting for some more

[@Mallik034]

Thank you so much for your support 😀

[@PrakashPrasain83]

Very nice demo. If possible, please make videos of showing the major differences/changes in 11gR2 and 12c RAC.

[@Mallik034]

Sure I will do it and upload it soon and also planning to upload 12c and 19c changes. Stay tuned.

[@akashreddy463]

Hi Sir
Can you pls uplaod vedios of crsctl and other background procesess in RAC

[@Mallik034]

@Akash, Sure I will plan to upload shortly.

[@akashreddy463]

@@Mallik034 thank you sir

[@shtldalvi]

Hi Malik , how scan listener connect to local listener to get the information any connecting there and how it communicating can u explain?