Skip to Main Content

Core Infrastructure

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Windows server's VM duplication and Licence key issue

Lucas GianiNov 18 2024

Hello everyone,

It's my first post on that forum so tell me if i put this to the wrong channel.

I read some docs about duplication of instances in OCI but no-one talks about issues with windows product key so here is my demand;

I have to create multiple instances Windows Server os-based. I have already created the first one manually and configure the instance configuration and the internal windows settings in line with my purpose.

To gain some times, i tried to duplicate this instance to x copies of the original one with the same configuration but each copy get the same Windows product key.

So my question is if an option exists in OCI to duplicate 'properly' a Windows Server Instance without the old Windows product key ?

I already tried to :
- Clone the boot volume of original instance and attached it to the new one
- Create an Instance configuration based on my first instance
- Create a Custom Image from the first instance

These 3 options lead to the same results: the Windows product key is kept from an instance to another.

Also, i know that external solution exists for automate this kind of actions like Terraform or Ansible, but before having to use these softwares, i would like to know if OCI propose something which can help me with my issue.

Thanks in advance to treat my demand, do not hesitate to ask if you need more informations.

Comments

MartinBach-Oracle Jan 8 2025

Hi Salomon,

please have a look at this blog post written by @ulrike-schwinn-oracle :

https://blogs.oracle.com/coretec/post/easy-sql-statement-tracking-in23c

I hope this answers your question, if not, please shout!

- Martin

Solomon Yakobson Jan 8 2025

@martinbach-oracle - No, it doesn't answer my question. Article you pointed to shows uses:

SQL> alter system set sql_history_enabled=true scope=both;

And in my post I said “Works fine when enabled on system level”. My question was about

SQL> ALTER SESSION SET SQL_HISTORY_ENABLED = TRUE;

where I showed SQL history was NOT captured even though it should be based on SQL_HISTORY_ENABLED:

Modifiable **ALTER SESSION**, ALTER SYSTEM

SY.

MartinBach-Oracle Jan 8 2025

As per the article I shared the situation is as follows at the moment

  • You must enable SQL history PDB-wide (only a DBA can do that) so there's a certain level of control over the feature
  • Your session has access to the SQL history
  • If you don't want to record anything, set sql_history_enabled to false.

I'm currently assessing if that's intended behaviour (in which case the documentation should be amended) or a feature not working as it should (in which case it needs fixing). The parameter is indeed session-modifyable, but not in the sense you expected.

We'll keep you posted.

- Martin

Solomon Yakobson Jan 8 2025

Do you mean it must be enabled on system level and not on session level and all session can do is disabe it for the session?

SY.

MartinBach-Oracle Jan 14 2025

Yes,

that's correct as of Oracle Database Free 23.6.

- Martin

Solomon Yakobson Jan 14 2025

Thanks Martin, I hope this will be added to 23AI docs soon.

SY.

1 - 6

Post Details

Added on Nov 18 2024
0 comments
65 views