Always great content. BTW I am enjoying a lot the podcasts. One comment about this video... what if I have 2 instances running in a 32 threads server. I guess if I set cpu_count to 16 for each of them I would go beyond the limitation, right? So in this case I should cape the physical CPU enabling only 16 threads or/and setting each instance cpu_count to 8. What do you think? Regards, Franky
You can install two SE2 on the same server if you license both. The tricky part I you cannot install them on a 4 socket server, not even when this is in a much smaller virtual machine (there are a few provisions for hardware or certified Hypervisors but it’s rather limited)
@@berndeckenfels AFAIK the installation does not matter at all and the same applies to the number of Oracle instances running. You can have a database instance running Oracle DB 18c SE2 and another one running Oracle DB 19c SE2 both on the same server and that would be a scenario of 2 installations. That does not matter from licensing perspective. What matters is how many threads and sockets you are running. That is right, you cannot run SE2 on a 4 socket server. The limitation is 2 sockets up to 16 threads and that is it. But my question is not about that. It is about the configuration required for each instance. In my experience I would never run a SE2 database in a server that has more than 16 threads even if I have defined the cpu_count parameter to 16. Thank you for your addition.
@@FrankyWeber yes you can have multiple instances on the same Hardware without additional fees, but only if the hardware does not exceed the 16 threads (which is hard to buy nowadays)
BTW reaching out to Oracle Contacts does not help much, you get only the response that the license conditions are valid in the written form and they cannot give legal advice absondre from that. (At least that was the way in rhe past when asking for clarifications about multiplexing rules and Java Binary License as Partner!
Always great content. BTW I am enjoying a lot the podcasts. One comment about this video... what if I have 2 instances running in a 32 threads server. I guess if I set cpu_count to 16 for each of them I would go beyond the limitation, right? So in this case I should cape the physical CPU enabling only 16 threads or/and setting each instance cpu_count to 8. What do you think?
Regards,
Franky
You can install two SE2 on the same server if you license both. The tricky part I you cannot install them on a 4 socket server, not even when this is in a much smaller virtual machine (there are a few provisions for hardware or certified Hypervisors but it’s rather limited)
@@berndeckenfels AFAIK the installation does not matter at all and the same applies to the number of Oracle instances running. You can have a database instance running Oracle DB 18c SE2 and another one running Oracle DB 19c SE2 both on the same server and that would be a scenario of 2 installations. That does not matter from licensing perspective. What matters is how many threads and sockets you are running. That is right, you cannot run SE2 on a 4 socket server. The limitation is 2 sockets up to 16 threads and that is it.
But my question is not about that. It is about the configuration required for each instance. In my experience I would never run a SE2 database in a server that has more than 16 threads even if I have defined the cpu_count parameter to 16. Thank you for your addition.
@@FrankyWeber yes you can have multiple instances on the same Hardware without additional fees, but only if the hardware does not exceed the 16 threads (which is hard to buy nowadays)
do you know why the SE2 FAQ still references an upgrade to "RAC" for SE1 customers? seems like an error.
I think single node RAC is included in SE2
With SE we have reworked the HA elements. Check it out here blogs.oracle.com/maa/standard-edition-high-availability-officially-released
thanks!
BTW reaching out to Oracle Contacts does not help much, you get only the response that the license conditions are valid in the written form and they cannot give legal advice absondre from that. (At least that was the way in rhe past when asking for clarifications about multiplexing rules and Java Binary License as Partner!
😂👍🍺