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

[@mayanks6728]

Best explanation ever ,thanks million times

[@VismoTechnologies]

Glad it helped! Keep watching my videos ;)

[@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

[@varunpandeyvarunlens]

if there are no local listener then how client connection happen to the database ---> It will go to physical IP / Node IP if virtual IP(local_listener) is down. Physical IP can't be down if node is up and running.

[@Muhammadilyas-nk4ox]

Thanks Malik it s very informative videos

[@VismoTechnologies]

👍

[@selvagam]

Excellent! Keep it up!

[@mojganmansouri9030]

Excellent... Thanks

[@bhanuprakash6500]

Hi sir, your explanation was simy superb sir.

[@VismoTechnologies]

Thanq u 😀

[@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.

[@VismoTechnologies]

note, Thanks

[@nagendraraob1276]

Thanks for the good session ..

[@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 ...

[@sunilprasadmulage1413]

Nice explanation !!!

[@VismoTechnologies]

Glad you liked it

[@janibashashaik3339]

Excellent Thanks a lot

[@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

[@mohamedsikkendaralikhandaw4854]

Well Done. It helps a lot.

[@BholeBaba_Ke_Bhakt]

Super explanation sir 👍👍👍

[@VismoTechnologies]

Thanks and welcome

[@gopikanagal2141]

gr8 keep it up

[@VismoTechnologies]

Thanks

[@sagarjagtap940]

nicely explain

[@rangad2963]

Super 💖

[@VismoTechnologies]

Thank you! Cheers!

[@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

[@VismoTechnologies]

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

[@venky1202]

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

[@sivaganeshsanthanam1251]

Nice Malik.

[@VismoTechnologies]

Thank you 🙏

[@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

[@VismoTechnologies]

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]

@@VismoTechnologies 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.

[@VismoTechnologies]

@@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]

@@VismoTechnologies 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

[@VismoTechnologies]

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