Skip to Main Content

Oracle Database Discussions

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.

what version of Oracle Database Client to use for Windows 11 x64 installs

Wilson FiskFeb 5 2025

Have inherited a project at work that installs a variety of things, including the Oracle Client 11g R2, which I'm assuming is also called “Oracle Database Client”.

The project was developed for Windows 10 and used the 32 bit install for the Oracle Client.

We need to get the install working on Windows 11. Right now the install doesn't work. Hangs during the install of the 11g R2 client and never finishes that installation. The Oracle install log file indicates the install gets to the point where it's trying to register various DLLS, but just stalls at that point and never completes.

Based on what I've read online, it appears we need to upgrade that 11g R2 client to version 19c. Wondering if someone can confirm that?

Info I'm basing this on is on this page: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntcli/software-requirements.html.

Relevant info appears to be in 'Table 2-3 Windows x64 Software Requirements', under 'Operating System' section:
Windows 11 x64 - Pro, Enterprise, and Education editions and Windows Server 2022 x64 - Standard, Datacenter, and Essentials editions are supported starting with Oracle Database 19c Release Update (19.13) or later.

Looking for someone to confirm that so I know what version of the product I should be starting with for the install. Thank you!

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 Feb 5 2025
0 comments
152 views