marrowyung
asked on
Oracle RAC license
hi,
We have oracle enterprise license (see attached) , I am not sure if it included the RAC license, please see attached.
And if include, how many nodes for the RAC is allowed without paying additional money ?
we plan to setup oracle RAC on Windows server but not oracle fail safe! is deploy to Windows limited by the license?
We have oracle enterprise license (see attached) , I am not sure if it included the RAC license, please see attached.
And if include, how many nodes for the RAC is allowed without paying additional money ?
we plan to setup oracle RAC on Windows server but not oracle fail safe! is deploy to Windows limited by the license?
ASKER
so we have 4x CPU Oracle EE license, right ?but the link do not say how many RAC node we can have, am I right?
RAC is not included in Enterprise Edition (EE). The license information you provided doesn't show RAC. So, you will need to purchase it.
In addition, you will need to license EE each node.
Before you ask: I'm not sure if you can take your EE license as-is and split it to run on two servers with 2 CPUs each. You will need to contact your Account Team to confirm if that is possible given your license.
You will likely want some form of Dataguard. Last time I checked and going from memory, some configurations don't require EE to be licensed on all servers. Your Account Team can confirm which configurations need separate licenses and which ones don't.
In addition, you will need to license EE each node.
Before you ask: I'm not sure if you can take your EE license as-is and split it to run on two servers with 2 CPUs each. You will need to contact your Account Team to confirm if that is possible given your license.
You will likely want some form of Dataguard. Last time I checked and going from memory, some configurations don't require EE to be licensed on all servers. Your Account Team can confirm which configurations need separate licenses and which ones don't.
In addition, you will need to license EE each node.
This will depend on how many nodes/cores (units), the RAC will be running ;-)
https://flashdba.com/2013/09/18/the-real-cost-of-oracle-rac/
ASKER
I'm not sure if you can take your EE license as-is and split it to run on two servers with 2 CPUs each
so in total 4 CPU license?
Your Account Team can confirm which configurations need separate licenses and which ones don't.oracle account team you mean ?
so RAC is separate license, and for each oracle nodes in the RAC cluster EACH need an EE license EE?
You will likely want some form of Dataguard.
why data guard now? we are check if there are some kind of oracle on Window 2x nodes FCI cluster but it seems only fail safe can do it! am I right? but fail safe is going to outdate and not support anymore.
so we are looking for oracle failover cluster! only RAC is working well for us, right? or oracle restart ? what is oracle restart for ?
ASKER
This will depend on how many nodes/cores (units),
you mean as long as all DB node we try to form a RAC has oracle EE, then RAC can be install on them ?
RAC is "just" an extra cost option which you have to buy once, but you have to license the "whole" cores which take part within your RAC cluster ;-)
E.e.: 4 servers, each 16 cores = 64 cores * core factor (let's say) 0.5 = 32
So, you'll end up paying for 32 processor licenses ;-)
E.e.: 4 servers, each 16 cores = 64 cores * core factor (let's say) 0.5 = 32
So, you'll end up paying for 32 processor licenses ;-)
ASKER
So, you'll end up paying for 32 processor licenses ;-)
I don't understand, core factor is used to calculate RAC cost (extra cost) ?
so in your example, we have to pay for a license cost = 32 process license for RAC to run on all RAC nodes ? plus the original 4 x servers, each 16 more = 64 core oracle enterprise license for all 4 x servers?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If I can recall that one off the top of my head, this comes with Oracle Clusterware aka Grid Infrastructure as Oracle's built-in tool to auto-start/-shutdown instances/nodes...
>>oracle restart ? what is oracle restart for ?
ASKER
>>please help on this:
I doubt Oracle High Availability Experts will be able to assist with SQL Server clustering.
I doubt Oracle High Availability Experts will be able to assist with SQL Server clustering.
ASKER
hi Alex.
so it only use to restart the oracle service in case it stopped on Windows ?
seems not about failover to another cluster nodes, right? how about
or based on the license we bought, what kind of failover technology from primary to secondary nodes on Windows cluster can be use? assume we use oracle 19c.
Oracle's built-in tool to auto-start/-shutdown instances/nodes...
so it only use to restart the oracle service in case it stopped on Windows ?
seems not about failover to another cluster nodes, right? how about
Oracle Fail Safe ? can do the oracle node on Windows cluster failover for us?
or based on the license we bought, what kind of failover technology from primary to secondary nodes on Windows cluster can be use? assume we use oracle 19c.
ASKER
slightwv ,
We don't have!
and we tried to install oracle latest edition on Window cluster for failover, is it possible ? must use Oracle Fail Safe?
is that right? so RAC cost is calculate based on core factor ?
yes! so based on our license, only Oracle Fail Safe ?
you means the shared storage used by RAC? so if it is not about HA , what is it for ? multi master read?
If you have a valid Support Contract
We don't have!
and we tried to install oracle latest edition on Window cluster for failover, is it possible ? must use Oracle Fail Safe?
so in your example, we have to pay for a license cost = 32 process license for RAC to run on all RAC nodes ? plus the original 4 x servers, each 16 more = 64 core oracle enterprise license for all 4 x servers?
is that right? so RAC cost is calculate based on core factor ?
If we dig deeper, I believe you are looking for High Availability (HA) with no human intervention in the event of a failure.
yes! so based on our license, only Oracle Fail Safe ?
RAC really isn't HA. It has a single point of failure.
you means the shared storage used by RAC? so if it is not about HA , what is it for ? multi master read?
RAC with Dataguard is what Oracle pushes as HA.data guard is the oracle replication component ? and target oracle in remote site (remote site only, right?) should be free dataguard license if we have EE license
I suggest, you take a huge step back and start e.g. here:
https://docs.oracle.com/en/database/oracle/oracle-database/19/haovw/index.html
Some other useful resources can be found here:
http://www.dba-oracle.com/oracle_tips_failover.htm
https://www.oracle.com/technetwork/database/availability/ha12ctopinnovations-2030124.pdf
Btw: Oracle Restart is "just" one of the built-in tools that comes with Clusterware/Grid Infrastructure. It is needed to perform all those operations on the corresponding nodes to startup and shutdown the various instances. Whereas this can be done in some other ways (more than enough shell scripts for *nix can be found via Google); in Windows based systems this is usually handled properly by the Windows services...
https://docs.oracle.com/en/database/oracle/oracle-database/19/haovw/index.html
Some other useful resources can be found here:
http://www.dba-oracle.com/oracle_tips_failover.htm
https://www.oracle.com/technetwork/database/availability/ha12ctopinnovations-2030124.pdf
Btw: Oracle Restart is "just" one of the built-in tools that comes with Clusterware/Grid Infrastructure. It is needed to perform all those operations on the corresponding nodes to startup and shutdown the various instances. Whereas this can be done in some other ways (more than enough shell scripts for *nix can be found via Google); in Windows based systems this is usually handled properly by the Windows services...
>>assume we use oracle 19c.
>>We don't have!
So, the license information you posted above were for newly purchased 19c licenses? Then you should have access to the Sales Team that helped you acquire the license.
If they aren't 19c licenses, then you cannot use 19c with them.
>>shared storage used by RAC? so if it is not about HA , what is it for ?
This is a really deep topic and outside this question. But a quick list: Scalability, allows shared resources, a little bit of HA.
>>data guard is the oracle replication component ?
No. Replicate is now Goldengate. It used to be Streams replication or Advanced replication but those two products have been deprecated.
>>and target oracle in remote site (remote site only, right?) should be free dataguard license if we have EE license
Should be free but isn't.
>>We don't have!
So, the license information you posted above were for newly purchased 19c licenses? Then you should have access to the Sales Team that helped you acquire the license.
If they aren't 19c licenses, then you cannot use 19c with them.
>>shared storage used by RAC? so if it is not about HA , what is it for ?
This is a really deep topic and outside this question. But a quick list: Scalability, allows shared resources, a little bit of HA.
>>data guard is the oracle replication component ?
No. Replicate is now Goldengate. It used to be Streams replication or Advanced replication but those two products have been deprecated.
>>and target oracle in remote site (remote site only, right?) should be free dataguard license if we have EE license
Should be free but isn't.
ASKER
Alex ,
so this is nothing about HA and DR? as it is part of Clusterware !
slightwv ,
so still RAC with Dataguard is HA but how about DR solution? for me data guard is DR.
ok goldengate deprecated!
data guard also replicate to the DR site and mark the DR oracle as OFfline or readonly, right ?
Btw: Oracle Restart is "just" one of the built-in tools that comes with Clusterware/Grid Infrastructure. It is needed to perform all those operations on the corresponding nodes to startup and shutdown the various instances. Whereas this can be done in some other ways (more than enough shell scripts for *nix can be found via Google); in Windows based systems this is usually handled properly by the Windows services...
so this is nothing about HA and DR? as it is part of Clusterware !
slightwv ,
So, the license information you posted above were for newly purchased 19c licenses? Then you should have access to the Sales Team that helped you acquire the license.then talk to sales team, right?
But a quick list: Scalability, allows shared resources, a little bit of HA.shared the SAN, right? from my point of view, if one RAC node down the other RAC node take the call, already HA, what other form of HA should it be ?
so still RAC with Dataguard is HA but how about DR solution? for me data guard is DR.
Replicate is now Goldengate. It used to be Streams replication or Advanced replication but those two products have been deprecated.
ok goldengate deprecated!
data guard also replicate to the DR site and mark the DR oracle as OFfline or readonly, right ?
>>so this is nothing about HA and DR? as it is part of Clusterware !
It is sort of related to HA: If a process or service dies, Restart will attempt to, well, restart it automatically.
>>then talk to sales team, right?
Yes. They will be able to help you figure out what products you need to accomplish what you want and if additional licenses are needed and how many of what license you need.
>>ok goldengate deprecated!
NO. Streams Replication and Advanced Replicate are deprecated. Goldengate is the replacement!
>>so still RAC with Dataguard is HA but how about DR solution? for me data guard is DR.
HA and DR are tightly coupled. I suppose it depends on how you use those terms but they are sort of interchangeable.
>>data guard also replicate to the DR site and mark the DR oracle as OFfline or readonly, right ?
Depends. There is an Active Dataguard that allows the other database to be open readonly.
Everything you need to know is out there. I suggest you spend some time reading up on them:
https://www.oracle.com/database/technologies/high-availability/dataguard.html
It is sort of related to HA: If a process or service dies, Restart will attempt to, well, restart it automatically.
>>then talk to sales team, right?
Yes. They will be able to help you figure out what products you need to accomplish what you want and if additional licenses are needed and how many of what license you need.
>>ok goldengate deprecated!
NO. Streams Replication and Advanced Replicate are deprecated. Goldengate is the replacement!
>>so still RAC with Dataguard is HA but how about DR solution? for me data guard is DR.
HA and DR are tightly coupled. I suppose it depends on how you use those terms but they are sort of interchangeable.
>>data guard also replicate to the DR site and mark the DR oracle as OFfline or readonly, right ?
Depends. There is an Active Dataguard that allows the other database to be open readonly.
Everything you need to know is out there. I suggest you spend some time reading up on them:
https://www.oracle.com/database/technologies/high-availability/dataguard.html
Btw: double check the current price list (I can recall that Golden Gate is horrobly expensive)
>>I can recall that Golden Gate is horrobly expensive
YES, it is!
With an EE license Streams and Advanced replication were free. Oracle took away a "free" product and replaced it with a very expensive one!!!
At my previous assignment I was using Streams Replication for DR and WAS NOT HAPPY when Oracle did that!!!
YES, it is!
With an EE license Streams and Advanced replication were free. Oracle took away a "free" product and replaced it with a very expensive one!!!
At my previous assignment I was using Streams Replication for DR and WAS NOT HAPPY when Oracle did that!!!
ASKER
Alex ,
everything in oracle is expensive! they think their RAC still the best ! but nowadays , MS SQL, mysQL all can do it
but oracle still has sth good! like active data guard, can have additional index in DR site for reporting purpose ! other DB can't !
slightwv (䄆 Netminder) ,
why .....?
this free is not free anymore as golden gate is going to replace them both as you said....
double check the current price list (I can recall that Golden Gate is horrobly expensive)
everything in oracle is expensive! they think their RAC still the best ! but nowadays , MS SQL, mysQL all can do it
but oracle still has sth good! like active data guard, can have additional index in DR site for reporting purpose ! other DB can't !
slightwv (䄆 Netminder) ,
Oracle took away a "free" product and replaced it with a very expensive one!!!
why .....?
With an EE license Streams and Advanced replication were free
this free is not free anymore as golden gate is going to replace them both as you said....
ASKER
it seems the only HA and DR solution for oracle 19c with the license information I post, only one node standard alone oracle EE in the primary site and a DR site by data guards with another single node oracle 19C EE is the ONLY solution we can have ?
>>is the ONLY solution we can have ?
Your Account Team will tell you your options.
Your Account Team will tell you your options.
ASKER
but technically it is a yes ?
I do not know everything Oracle has available so, cannot say what all might be able to do what you want. BUT, from what I do now, I think RAC/Dataguard and/or Goldengate are your "official" methods in 19c.
Prior to 19c, Streams Replication is still around. It is there in 19c but Desupported. Probably wouldn't use it because it is more or les a dead poduct.
I've also heard people created their own processes to do this before Oracle had replication.
Prior to 19c, Streams Replication is still around. It is there in 19c but Desupported. Probably wouldn't use it because it is more or les a dead poduct.
I've also heard people created their own processes to do this before Oracle had replication.
ASKER
is oracle fail safe always used in one oracle nodes only?
as we have data guard license then we can focus on this instead of thinking sth else.
It is there in 19c but Desupported.we are exactly going to use 19c
as we have data guard license then we can focus on this instead of thinking sth else.
ASKER
hi,
any idea on what is the source of fail safe installation? included in the binary of oracle 19c ?
seems this installation page do not have oracle universal installer! then how can I use installer to install fail safe !
https://docs.oracle.com/cd/E67869_01/OFSIG/introduction-and-preinstallation-checklist.htm#OFSIG117
any idea on what is the source of fail safe installation? included in the binary of oracle 19c ?
seems this installation page do not have oracle universal installer! then how can I use installer to install fail safe !
https://docs.oracle.com/cd/E67869_01/OFSIG/introduction-and-preinstallation-checklist.htm#OFSIG117
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
tks both.
Taken from:
https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87