👏👏#dbaChallenge Winners 👏👏 ============================= First Place: @sandeep sindhu You get 100% discount on any one of our paid DBA Genesis video courses. Second Place: @Pushpendra Gaur and @Umesh Dhote You get 80% discount on any one of our paid DBA Genesis video courses. Third Place: @amandeep gera , @prathap reddy and @Naresh D You get 50% discount on any one of our paid DBA Genesis video courses. How to claim your prize: =================== Goto dbagenesis.com >> courses >> select the course you like and send email to support@dbagenesis.com
in the database thre is MMON process which actually calculates the load on the database and save it to the service metrics and then the LREG process communicate the service metrics to the SCAN listener. using the service metric information , the SCAN listener decides which node has the less load.
the perfect, beautiful example for SCAN Thank you so much Arun, after this example, I get a clear idea about SCAN, as per my knowledge (searched in google) Load Balance Advisory is one whos is going to help the scan listener for load balancing
On Oracle RAC environment Load Balancing is something which is critical for distribution of connections between the servers we have. Load Balancing Advisory (LBA) is one of the key components for SCAN listener to decide the best instance for the new incoming connection request.SCAN using details from LBA, identifies the load on each node in the setup and routes the request xyz to the node which has least load.
wao Perfecto, muy bien explicado, yo quería encontrar una explicación sobre como SCAN funcionaba y gracias a Dios encontré este Canal. thank you very much DBA Genesis.
PMON registers with the listener when instance or DB starts .PMON process having/knowing all the load information of each instances of RAC .the Scan listeners will get the information from PMON process about the load of each instances
I always say our database administration is very much analogous/connected to most of our lives. And sir you have presented in such a way that, no one can forget this concept with the airport analogy taken. Awesome explanation. Story remains in mind forever :)
Oracle Net Services provides connection load balancing for database connections. The listener uses the load balancing advisory for connection load balancing.
LREG process which gets registered with the local listener has all the details of the load on each node which helps scan listeners to distribute the load equally.
That respected SCAN listener using details from LBA, identifies the load on each node in the setup and routes the request to node which has least load . PMON of each node updates details about each node in LBA .
PMON of each node records and updates the load in LBA and LBA decides to which local listener connection request to be re-routed. SCAN always re-routes connection request to local listeners.
SCAN listener will check for the least loaded instance. It will then redirect the connection request to the local listener on the node where the least loaded instance is running. Eventually the client will be given the address of the local listener to make the connection with the database instance.
I had given a Interview yesterday the interviewer asked me a question How SCAN works I gave a example similar to the one explained and I told that there is a Load Balancing Advisor (LBA) which has all the details of the load on each node and it routes the connection to the node with least load. It gets the information of the load from the PGA's/client connections to the node and the LBA is update by the PMON background Process. But the interviewer was of the opinion that I have cooked up some new story about scan IP's which he never heard about.
XYZ person in your example is local listener on each node who knows load/number of connections on the respective instances and provide these details to scan listener.
Scan listener using details from LBA, identifies the load on each node in the setup and routes the request to node which has least load like node4. In this case it happened to be node2 with least load or no load and the request is addressed by local listener on this node which helps request to establish a session on instance on node2.
In Oracle RAC, the Clusterware service stores information about the load balance in the Cluster Synchronization Services (CSS) daemon, which is responsible for synchronizing the cluster state across all nodes in the cluster.
Scan always re-route the connection to local listener. Decide to which local listener connection request to be re-routed. PMON of each node record and updates the load in LBA ( Load Balancing Advisor)
pmon process for each instances registers the database services with the default listerner on the local node. And with each scan listener which is specified by remote_listerner parameter. basically client queries the dns to resole the scan name , and scan then selects the least loaded node Note : - the client then directly connects to the dedicated server process on the least loaded node
The Best explanation of RAC SCAN LISTENER any day! Understood it much more better than before. Load Balancing Advisory (LBA) is the answer you are searching for. LBA helps SCAN LISTENER to balance load across the instances in Oracle RAC. Load Balancing Advisory(LBA) is intelligent enough to advice for connection load balancing based on data collected by PMON of all the instances. LBA is definitely mandatory for SCAN listener in Oracle RAC.
Server Side Load balancing: Scan Listeners connects to all instances with all listeners so that instances can spread their load balance advisories to all listeners. Listener uses the advisories to decide which instance should service client request. If listener know from advisories that its local instance is least loaded and should service client request then listener passes client request to local instance. If local instance is over loaded then listener can use TNS redirect to redirect client request to a less loaded instance means remote instance.
Thanks for sharing this info i had always doubt, I knew Pmon register will load the balnce at server level. . but Above that how it Balance . .Now i got it DNS. . .thanks . .
Xyz is none another local listener of the instance node, db instances and services would be registered with remote listeners or scan listeners, hence with the help pmon of the instance its updates the records and load on it in LBA , once LBA knows the status of each node's ,scan listeners would divert the request in round roubin manner to least bother node through local listener of the node, hence establishes a session on instance which has least lode node.
How 3 disks for normal redundancy disk group is managing the heartbeat information from 15 node rac or 5 disks for high redundancy disk group is managing the same heartbeat among 15 node rac ... Please help @Arun..
Load balance adviser will collect load information from each node using local listener and keep in load balance adviser. Scan listener will communicate LBA and get the least load information and then it will establish the connection with that node through local listener
If you could have explained litlle bit more about where VIP, Services, local listener and remote listener fits in above airport example , it would have been great
With the help of Load Balancer Advisory, Scan listener choose the node having less workload. As part of Fast Application Notification (FAN) event transmission features, Oracle 10g RAC uses Oracle Notification Services (ONS) to communicate the status of cluster resources to all participating node applications in the cluster. In Oracle 10gR2, FAN added a new event type, SERVICE_METRIC, whose event payload contains information about the relative workload of each node in the RAC cluster, and this information Load Balancing Advisory uses to determine how to route new connections throughout the clustered database’s instances.
Hi Arun, great going and enjoying your daily DBA show .I wanted to know from you and other sr dba,,s personal experience what is one of the rarest of rare crisis situation a DBA can experience in real-time like site crash or anything that hardly any DBA sees in their entire career which most of the DBA,s are scared of or the situation is very challenging .
Xyz is none another local listener of the instance node, db instances and services would be registered with remote listeners or scan listeners, hence with the help pmon of the instance its updates the records and load on it in LBA , once LBA knows the status of each node's ,scan listeners would divert the request in round roubin manner to least bother node through local listener of the node, hence establishes a session on instance which has least lode node.
👏👏#dbaChallenge Winners 👏👏
=============================
First Place: @sandeep sindhu
You get 100% discount on any one of our paid DBA Genesis video courses.
Second Place: @Pushpendra Gaur and @Umesh Dhote
You get 80% discount on any one of our paid DBA Genesis video courses.
Third Place: @amandeep gera , @prathap reddy and @Naresh D
You get 50% discount on any one of our paid DBA Genesis video courses.
How to claim your prize:
===================
Goto dbagenesis.com >> courses >> select the course you like and send email to support@dbagenesis.com
Hurreh thank you so much sir🕺
@@sandeepsindhu346 congratulations bro
Mail sent sir
in the database thre is MMON process which actually calculates the load on the database and save it to the service metrics and then the LREG process communicate the service metrics to the SCAN listener. using the service metric information , the SCAN listener decides which node has the less load.
Good and superb explanation about scan
i have no word for your talent explanation, Mr.Arun you are a great teacher
Keep watching
the perfect, beautiful example for SCAN Thank you so much Arun, after this example, I get a clear idea about SCAN, as per my knowledge (searched in google) Load Balance Advisory is one whos is going to help the scan listener for load balancing
(LBA) LOAD BALANCING ADVISOR- PMON of each node records and updates the load in LBA it's register in the given example
Thanks friend.I have an interview and don't have time for challenge 🤭🤭
On Oracle RAC environment Load Balancing is something which is critical for distribution of connections between the servers we have. Load Balancing Advisory (LBA) is one of the key components for SCAN listener to decide the best instance for the new incoming connection request.SCAN using details from LBA, identifies the load on each node in the setup and routes the request xyz to the node which has least load.
One of the simply beautiful explanation of SCAN I've ever seen. Kudos Arun!
We love it when our videos help DBAs across the globe!
wao Perfecto, muy bien explicado, yo quería encontrar una explicación sobre como SCAN funcionaba y gracias a Dios encontré este Canal. thank you very much DBA Genesis.
PMON registers with the listener when instance or DB starts .PMON process having/knowing all the load information of each instances of RAC .the Scan listeners will get the information from PMON process about the load of each instances
you are doing an excellent service. God bless!
Thank you!
what a beautiful explanation..no words !!!
Glad you liked it
I always say our database administration is very much analogous/connected to most of our lives. And sir you have presented in such a way that, no one can forget this concept with the airport analogy taken. Awesome explanation. Story remains in mind forever :)
Just wow... Awesome explanation from you.. Very simple with amazing example... I never understood so deeply from any video sir...
You are most welcome! Honoured to help you with the concept !!
Oracle Net Services provides connection load balancing for database connections. The listener uses the load balancing advisory for connection load balancing.
LREG process which gets registered with the local listener has all the details of the load on each node which helps scan listeners to distribute the load equally.
That respected SCAN listener using details from LBA, identifies the load on each node in the setup and routes the request to node which has least load . PMON of each node updates details about each node in LBA .
LBA decides to which local listener the connection to be re-routed from scan listeners and PMON updates the load on each node in LBA.
so beautiful example to explain rac scan ip
PMON of each node records and updates the load in LBA and LBA decides to which local listener connection request to be re-routed. SCAN always re-routes connection request to local listeners.
SCAN Listener use details from LBA, identifies the load on each node in the setup and routes the request to node which has least load.
Perfect
SCAN listener will check for the least loaded instance. It will then redirect the connection request to the local listener on the node where the least loaded instance is running. Eventually the client will be given the address of the local listener to make the connection with the database instance.
I had given a Interview yesterday the interviewer asked me a question How SCAN works I gave a example similar to the one explained and I told that there is a Load Balancing Advisor (LBA) which has all the details of the load on each node and it routes the connection to the node with least load. It gets the information of the load from the PGA's/client connections to the node and the LBA is update by the PMON background Process.
But the interviewer was of the opinion that I have cooked up some new story about scan IP's which he never heard about.
Hahahaaa... Happens!
XYZ person in your example is local listener on each node who knows load/number of connections on the respective instances and provide these details to scan listener.
Scan listener using details from LBA, identifies the load on each node in the setup and routes the request to node which has least load like node4.
In this case it happened to be node2 with least load or no load and the request is addressed by local listener on this node which helps request to establish a session on instance on node2.
In Oracle RAC, the Clusterware service stores information about the load balance in the Cluster Synchronization Services (CSS) daemon, which is responsible for synchronizing the cluster state across all nodes in the cluster.
Scan always re-route the connection to local listener.
Decide to which local listener connection request to be re-routed.
PMON of each node record and updates the load in LBA ( Load Balancing Advisor)
Good one!
pmon process for each instances registers the database services with the default listerner on the local node. And with each scan listener which is specified by remote_listerner parameter.
basically client queries the dns to resole the scan name ,
and scan then selects the least loaded node
Note : - the client then directly connects to the dedicated server process on the least loaded node
The Best explanation of RAC SCAN LISTENER any day! Understood it much more better than before.
Load Balancing Advisory (LBA) is the answer you are searching for. LBA helps SCAN LISTENER to balance load across the instances in Oracle RAC. Load Balancing Advisory(LBA) is intelligent enough to advice for connection load balancing based on data collected by PMON of all the instances. LBA is definitely mandatory for SCAN listener in Oracle RAC.
It internally follows the round-robbin alogorithem for specifying load to connect to session which is having less sessions connected to
I feel that I had just hit the goldmine, new fan of DBA Genesis. Thank You.
Most welcome buddy!
Very good video and really simple! Especially for someone which is completely new to DBA knowledge.
Server Side Load balancing:
Scan Listeners connects to all instances with all listeners so that instances can spread their load balance advisories to all listeners. Listener uses the advisories to decide which instance should service client request. If listener know from advisories that its local instance is least loaded and should service client request then listener passes client request to local instance. If local instance is over loaded then listener can use TNS redirect to redirect client request to a less loaded instance means remote instance.
LBA(Load balancing advisory) for check each node load & provide this node load detail to scan listener.
Very Good. Superb.
Thanks!!
Thanks for sharing this info i had always doubt, I knew Pmon register will load the balnce at server level. . but Above that how it Balance . .Now i got it DNS. . .thanks . .
Thank you! keep watching!
Beautiful explanation 👍
Keep watching
Great explained
Glad you liked it
Nice easily understandable , thanks arun :)
Keep watching
Hi arun what happen if password file is deleted from standby server? will there any impact sync with primary server?how will fix the issue?
Picked up your question for future episodes, will be answering it soon!
Xyz is none another local listener of the instance node, db instances and services would be registered with remote listeners or scan listeners, hence with the help pmon of the instance its updates the records and load on it in LBA , once LBA knows the status of each node's ,scan listeners would divert the request in round roubin manner to least bother node through local listener of the node, hence establishes a session on instance which has least lode node.
What a explanation sir ...hatts off ❤️🙏
Good explanation.
Glad you liked it
Hi Arun, LBA update the information to scan listeners, this information shared from local listener to LBA.
LBA (introduced in 11g) is a memory area basically under shared pool, as PMON provides the statics to LBA
Any link please. I couldnt find anything in oracle docs.
Hi, Could you please give some information about VIP in RAC... Thanks..
Check episode 22 for VIP
@@dbagenesissure...
hi i follow your lectures they are very good i want to see your oracle rac tutorials
LBA load balance adviser pmon on each node update the LBA about the load
Suppose, if I have to set up a RAC with 4 nodes, how many SCAN IPs do I need?
3
Mast😄👍👍👍 trick to understand
Keep watching
Those guys awesome.
Load balancing advisor.PMON of each node update the load of the node to LBA
REMOTE_LISTENER, LOAD BALANCE ADVISER and PMON.
SQL> alter system set remote_listener='SCAN-name:port-number' scope=both
awesome bro
Glad you liked it
Your videos are great ..you 🔥
Thank you so much 😀
LBA ( load balance advisor) ..
It will get least load node details with help of MDnS and pmon..
I have one question , why only 3 scan !!! Why not 4 or 5 ????
Why don't you google it up and let us all know if it is possible or not?
Thank u sir wow explanation
Keep watching
How 3 disks for normal redundancy disk group is managing the heartbeat information from 15 node rac or 5 disks for high redundancy disk group is managing the same heartbeat among 15 node rac ... Please help @Arun..
Get your RAC architecture right, you will have the answer. Its a wrong question you are asking!
@@dbagenesisOLR is the right asnwer..?
Normal =1, External=3 & High= 5
SCAN will use the Load balancing adviser and identifies load in each node in the cluster.
Load balance adviser will collect load information from each node using local listener and keep in load balance adviser. Scan listener will communicate LBA and get the least load information and then it will establish the connection with that node through local listener
services or server pool
Remote listener init parameter
Load balancing advisor LBA ( LBA updated by PMON background process from each nodes) #dba_challenge
LOAD BALANCING ADVISOR WITH THE HELP OF PMON COLLECT DETAILS PUSH TO CLIENT THEN CLIENT DECIDE IT.
Load balance Advisory
LBA
And dns ki round Robin algo
If you could have explained litlle bit more about where VIP, Services, local listener and remote listener fits in above airport example , it would have been great
With the help of Load Balancer Advisory, Scan listener choose the node having less workload.
As part of Fast Application Notification (FAN) event transmission features, Oracle 10g RAC uses Oracle Notification Services (ONS) to communicate the status of cluster resources to all participating node applications in the cluster. In Oracle 10gR2, FAN added a new event type, SERVICE_METRIC, whose event payload contains information about the relative workload of each node in the RAC cluster, and this information Load Balancing Advisory uses to determine how to route new connections throughout the clustered database’s instances.
And each node has its local listener also
He went from a Boeing 777 to an Airbus Beluga, nice.
Once again thank you so much..
Tilt could be how to enter airport fly
This feature is called load balancing.
Genius indeed
Our entire DBA community is Genius! Let's help our fellow friends join this DBA community!
LBA is there. Load balance Advisory
Integration of Oracle Listener with Load Balancing Advisory.
Oracle traffic director and windows load balancer
Connection load balancing
LBA.. Many people already have answered .. :)
Grid Load Balancing (GLB) Service
It Is Rac Scan IP method
The answer is LBA (Load Balancing Advisory)
Hi Arun, great going and enjoying your daily DBA show .I wanted to know from you and other sr dba,,s personal experience what is one of the rarest of rare crisis situation a DBA can experience in real-time like site crash or anything that hardly any DBA sees in their entire career which most of the DBA,s are scared of or the situation is very challenging .
Good one, I guess I would love to speak about one situation in upcoming episodes that all of you should know.
Load balancing advisory process
Load balance adviser.(LBA)
Workload Management relies on the use of Services
LBA(Load Balance Advisor)
You are right buddy!
(LBA) LOAD BALANCING ADVISOR
LBA sir
Load balancing advisor
Management DB Sir
Scan IP it is..
Hi Arun
Node VIP will maintain the current Load on the Host
LBA ( advisor )
LBA
Load Balancer
Ocr and olr
VIP scan it's simple
Load balancer
VIP ip
Vip - virtual ip address that knows load balance of each original ip address of each host.
pmon
Load balancing advisor
Xyz is none another local listener of the instance node, db instances and services would be registered with remote listeners or scan listeners, hence with the help pmon of the instance its updates the records and load on it in LBA , once LBA knows the status of each node's ,scan listeners would divert the request in round roubin manner to least bother node through local listener of the node, hence establishes a session on instance which has least lode node.