Skip to Main Content

Oracle Database Free

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.

database 23ai free install on windows 11 iot enterprise cause error ! did it support IOT version ?

NolemJan 13 2025

hi, we try to install oracle database 23ai free on windows 11 iot enterprise 24H2 version ,

  but can not install with error and rollback installation …did it support IOT version ?

installActions2025-01-13_00-51-54AM.log

查詢異常狀況: Indeterminate_OS_ErrorException
查詢異常狀況類別: class oracle.sysman.oii.oiil.OiilQueryException
INFO: [2025年1月13日 上午12:52:16] Adding ExitStatus STOP_INSTALL to the exit status set
INFO: [2025年1月13日 上午12:52:16] Start ClusterVerification cleanup.
INFO: [2025年1月13日 上午12:52:17] ClusterVerification cleanup is done.
INFO: [2025年1月13日 上午12:52:17] Finding the most appropriate exit status for the current application
INFO: [2025年1月13日 上午12:52:17] inventory location isC:\Program Files\Oracle\Inventory
INFO: [2025年1月13日 上午12:52:17] Finding the most appropriate exit status for the current application
INFO: [2025年1月13日 上午12:52:17] Exit Status is -4
INFO: [2025年1月13日 上午12:52:17] Shutdown Oracle Database 23ai 安裝程式

installActions2025-01-13_00-51-54AM.out

[Clone API Thread] [ 2025-01-13 00:52:16.990 TST ] [CVUVariables.getCVUVariable:662] The variable name : <MODE_CLI> is not listed
[Clone API Thread] [ 2025-01-13 00:52:16.990 TST ] [sVerificationUtil.resolve:418] condition variable MODE_CLI not handled
[Clone API Thread] [ 2025-01-13 00:52:16.990 TST ] [CVUVariables.secureVariableValueTrace:817] getting CVUVariableConstant : VAR = MODE_CLI VAL = null
[Clone API Thread] [ 2025-01-13 00:52:16.990 TST ] [CVUVariables.getCVUVariable:662] The variable name : <MODE_API> is not listed
[Clone API Thread] [ 2025-01-13 00:52:16.990 TST ] [sVerificationUtil.resolve:418] condition variable MODE_API not handled
[Clone API Thread] [ 2025-01-13 00:52:16.990 TST ] [CVUVariables.secureVariableValueTrace:817] getting CVUVariableConstant : VAR = MODE_API VAL = null
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [NodeManagerFactory.getNodeManager:215] creating new NodeManager
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [CVUVariables.getCVUVariable:662] The variable name : <MODE_API> is not listed
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [sVerificationUtil.resolve:418] condition variable MODE_API not handled
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [CVUVariables.secureVariableValueTrace:817] getting CVUVariableConstant : VAR = MODE_API VAL = null
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [CVUVariables.getCVUVariable:662] The variable name : <MODE_API> is not listed
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [sVerificationUtil.resolve:418] condition variable MODE_API not handled
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [CVUVariables.secureVariableValueTrace:817] getting CVUVariableConstant : VAR = MODE_API VAL = null
[Clone API Thread] [ 2025-01-13 00:52:16.993 TST ] [NodeManager.<init>:333] Throwing internal framework error because neither CRS nor HA was found to be configured.
[Clone API Thread] [ 2025-01-13 00:52:16.995 TST ] [Task.getNodeManager:2177] NodeManagerException occured. message: PRVF-7508 : 叢集驗證架構內發生內部錯誤
[Clone API Thread] [ 2025-01-13 00:52:16.995 TST ] [Task.getNodeManager:2178] PRVF-7508 : 叢集驗證架構內發生內部錯誤
oracle.cluster.verification.nodemgr.NodeManagerFactory.getNodeManager(NodeManagerFactory.java:221)
oracle.ops.verification.framework.engine.task.Task.getNodeManager(Task.java:2173)
oracle.ops.verification.framework.engine.task.Task.<init>(Task.java:532)
oracle.ops.verification.framework.engine.task.Task.<init>(Task.java:507)
oracle.ops.verification.framework.engine.task.TaskAnonymousProxy.<init>(TaskAnonymousProxy.java:100)
oracle.ops.verification.framework.engine.task.TaskAnonymousProxy.<init>(TaskAnonymousProxy.java:87)
oracle.ops.verification.framework.engine.task.TaskAnonymousProxy.<init>(TaskAnonymousProxy.java:75)
oracle.ops.verification.framework.engine.task.TaskAnonymousProxy.<init>(TaskAnonymousProxy.java:64)
oracle.ops.verification.framework.report.ReportUtil.<clinit>(ReportUtil.java:552)
oracle.ops.verification.framework.CVUStaticResetHelper.resetAll(CVUStaticResetHelper.java:20)
oracle.cluster.verification.ClusterVerification.cleanup(ClusterVerification.java:12794)
oracle.install.library.util.cvu.CVUHelper.cleanup(CVUHelper.java:192)
oracle.install.ivw.common.util.OracleInstaller.shutdown(OracleInstaller.java:547)
oracle.install.commons.util.Application.shutdown(Application.java:1196)
oracle.install.driver.oui.ui.DefaultRetryHandler.doModal(DefaultRetryHandler.java:145)
oracle.sysman.oii.oiic.OiicAPISessionInterfaceManager$CustomRetryHandler.doModal(OiicAPISessionInterfaceManager.java:412)
oracle.sysman.oii.oiic.OiicAPISessionInterfaceManager$CustomRetryHandler.doModal(OiicAPISessionInterfaceManager.java:397)
oracle.sysman.oii.oiis.OiisCompContext.doQuery(OiisCompContext.java:2701)
Components.oracle.has.common.v23_0_0_0_0.CompContext.doCalculation_Calculation1(Unknown Source)
Components.oracle.has.common.v23_0_0_0_0.CompContext.doCalculation(Unknown Source)
oracle.sysman.oii.oiif.oiifb.OiifbCompWizChainCondElem.doCalculation(OiifbCompWizChainCondElem.java:32)
oracle.sysman.oii.oiif.oiifb.OiifbWizChainCondElem.initialize(OiifbWizChainCondElem.java:167)
oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:154)
oracle.sysman.oii.oiis.OiisCompContext.doOperation(OiisCompContext.java:1167)
oracle.sysman.oii.oiif.oiifb.OiifbLinearIterator.iterate(OiifbLinearIterator.java:151)
oracle.sysman.oii.oiic.OiicCompsWizEngine.doOperation(OiicCompsWizEngine.java:194)
oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:173)
oracle.sysman.oii.oiic.OiicPullSession.doOperation(OiicPullSession.java:1370)
oracle.sysman.oii.oiic.OiicCloneAPISession.doCloneAction(OiicCloneAPISession.java:522)
oracle.sysman.oii.oiic.OiicCloneAPISession.access$000(OiicCloneAPISession.java:70)
oracle.sysman.oii.oiic.OiicCloneAPISession$OiicActionsThread.run(OiicCloneAPISession.java:595)

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 Jan 13 2025
3 comments
142 views