Understanding RAC Listeners || ASM Listener - SCAN Listener - Remote Listener and Local Listener

Hi Friends,
ASM Listener - SCAN Listener - Remote Listener and Local Listener - Real Application Cluster
============================================================================
1. Listeners and Its Properties
2. How client and Listener connectivity happens?
3. How to verify the ASM Listener and SCAN Listener?
4. How to verify Local listener?
5. How to register local listener to cluster?
Questions:
1. If we don’t have local listener then
--- How client connection happens to Database?
2. What is the use of Local Listener?
#scanlistener #scan #remotelistener #locallistener #listenerarchitecture #loadbalancing #RAC #Exadata #Oracle #Database #interconnect #Cachefusion #HA #Loadbalancing #NetworkHeartbeat
Please do follow me and support me on,
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Email: [e-mail]
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com

[@selvagam]

Excellent! Keep it up!

[@nagendraraob1276]

Thanks for the good session ..

[@mojganmansouri9030]

Excellent... Thanks

[@mohamedsikkendaralikhandaw4854]

Well Done. It helps a lot.

[@mayanks6728]

Best explanation ever ,thanks million times

[@Mallik034]

Glad it helped! Keep watching my videos ;)

[@janibashashaik3339]

Excellent Thanks a lot

[@sankarnatarajan313]

Excellent demonstration Thanks!!!
1. if there are no local listener then how client connection happen to the database
The scan listener redirects the connection request to the node that is least loaded so when the local listener does not exists the client connections could be handled by the scan listener my guess.
2. what is the purpose of local listener
The local listener handles client requests that are directed to the specific node if scan listener is not configured. if scan listener is configured then local listener handles the connection request redirected by the scan listener

[@sunilprasadmulage1413]

Nice explanation !!!

[@Mallik034]

Glad you liked it

[@sagarjagtap940]

nicely explain

[@bhanuprakash6500]

Hi sir, your explanation was simy superb sir.

[@Mallik034]

Thanq u 😀

[@gopikanagal2141]

gr8 keep it up

[@Mallik034]

Thanks

[@rangad2963]

Super 💖

[@Mallik034]

Thank you! Cheers!

[@Muhammadilyas-nk4ox]

Thanks Malik it s very informative videos

[@Mallik034]

👍

[@sivaganeshsanthanam1251]

Nice Malik.

[@Mallik034]

Thank you 🙏

[@mahfujalam903]

Thank you so much sir. You saved my day.
I have installed 12CR2 RAC . My clients are unable to connect but tnsping of db is happening.
I think , I must register the local listeners and add them manually to the grid listeners. Am I right sir ?
Air , do u have any documentation about things after installation of RAC and DB of 12C ?
Kindly help me ...

[@BholeBaba_Ke_Bhakt]

Super explanation sir 👍👍👍

[@Mallik034]

Thanks and welcome

[@noushadahamad293]

Dear mallik greate explanation.
but with the help of this video we understand the use of SCAN and local listener but i want to know what is the use of ASM listener. i think ASM listener not play any role in client connections with database.kindly guide me

[@atulawate3243]

dear malik please make seprate palylist for the rac videos... its a very good videos, but its very difficuilt to differentiate it by course. so please make seprate playlist atlist for RAC

[@Mallik034]

Hi Atul, please go to my playlist.
Anyway i have separate playlist for everything

[@sanjayrawat985]

Video is very informative.. Thanks !!
Suggestion: Please do not use "Cursor selection sound or Click sound" it's very annoying and disturbing the concentration.

[@Mallik034]

note, Thanks

[@venky1202]

I didn't find scan listener configuration. how to configure.

[@mohdasim6243]

Why asm listener is default listener

[@belowasmelashgebremariam]

Selam kemey ke

[@Er_Shashank_Singh]

Bro itna jyada ads kon lagata hai yrr 😥 maine video dekhni hi bnd kr di

[@faisalshalla8252]

@singh, anyways we get this amount of quality knowledge from the videos.. atleast ads we can bear. You might go for paid course incase you donot want ad. Please donot take it otherwise. Hope we support the channel. Its for our benefit only.

[@Er_Shashank_Singh]

@@faisalshalla8252 I agree with you. There should not be lot of ads because it creates distraction.

[@kids-kh1ij]

No one seems to have answered your questions. Please share the answers

[@Mallik034]

If you don't have local listener then connection will happens through scan listener
if you want to use the deferent port other than 1521 then you have to use local_listener

[@stalinjaviermaciasgomez3676]

@@Mallik034 I made a test by stopping the local listener on all nodes and trying to establish a connection from the SQL developer, as I was expecting, the connection failed, therefore I conclude that if there is no local listener running, the scan listener won´t be able to connect to the database and the client will receive an error. If I'm wrong, please correct me with the right answer.
Regarding what you said that if there is no local listener running the connection will happen through the scan listener, which worked on the test I did, but only by trying to connect to the database directly from the server.
Best regards.

[@Mallik034]

@@stalinjaviermaciasgomez3676 check your database has set loacl_listener and remote_listener parameter set.
Local_lister should point to local listener and its port
Remote_listener should point to remote_listener and port 1521 should be open.

[@Eira.2010]

@@Mallik034 local listeners run on 1521 na ?? This is default ? Am I correct can you pls answer

[@yoginigavande896]

@@Eira.2010 yes default port is always 1521.

[@Farhan640]

Mouse click is annoying

[@Mallik034]

Its noted and its been already taken care of later videos.
Thanks for you feedback