004 - Listeners in Oracle RAC - remote_listener - local_listener - Real Application Cluster Listener
ฝัง
- เผยแพร่เมื่อ 21 ส.ค. 2024
- 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: +966 543796525
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
Really awesome notes and explanation... Really appreciate sir
Thanks Sadan
Very nice explanation
Thanks and welcome
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.
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.
If you need more detailed explanation please ping on our Telegram group @mallik034
@@Mallik034 how can I join the telegram group?
@@stalinjaviermaciasgomez3676 you can install the Telegram App and search for @mallik034
Nice explained 👍👍
Very informative session. Waiting for some more
Thank you so much for your support 😀
Very nice demo. If possible, please make videos of showing the major differences/changes in 11gR2 and 12c RAC.
Sure I will do it and upload it soon and also planning to upload 12c and 19c changes. Stay tuned.
Hi Sir
Can you pls uplaod vedios of crsctl and other background procesess in RAC
@Akash, Sure I will plan to upload shortly.
@@Mallik034 thank you sir
Hi Malik , how scan listener connect to local listener to get the information any connecting there and how it communicating can u explain?