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
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.
Video is very informative.. Thanks !! Suggestion: Please do not use "Cursor selection sound or Click sound" it's very annoying and disturbing the concentration.
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
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 ...
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
@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.
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
@@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.
@@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.
Best explanation ever ,thanks million times
Glad it helped! Keep watching my videos ;)
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
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.
Thanks Malik it s very informative videos
👍
Excellent... Thanks
Hi sir, your explanation was simy superb sir.
Thanq u 😀
Excellent! Keep it up!
Video is very informative.. Thanks !!
Suggestion: Please do not use "Cursor selection sound or Click sound" it's very annoying and disturbing the concentration.
note, Thanks
Thanks for the good session ..
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
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 ...
Nice explanation !!!
Glad you liked it
Excellent Thanks a lot
Well Done. It helps a lot.
I didn't find scan listener configuration. how to configure.
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
Hi Atul, please go to my playlist.
Anyway i have separate playlist for everything
Super explanation sir 👍👍👍
Thanks and welcome
Super 💖
Thank you! Cheers!
nicely explain
gr8 keep it up
Thanks
Why asm listener is default listener
Nice Malik.
Thank you 🙏
Bro itna jyada ads kon lagata hai yrr 😥 maine video dekhni hi bnd kr di
@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.
@@faisalshalla8252 I agree with you. There should not be lot of ads because it creates distraction.
No one seems to have answered your questions. Please share the answers
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
@@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.
@@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.
@@Mallik034 local listeners run on 1521 na ?? This is default ? Am I correct can you pls answer
@@Eira.2010 yes default port is always 1521.
Selam kemey ke
Mouse click is annoying
Its noted and its been already taken care of later videos.
Thanks for you feedback