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.

Datapatch warning while installing 23ai FREE version 23.6

Simon_DBANov 13 2024

It seems that 23ai FREE version 23.6 is out now:

$ oraversion -compositeVersion
23.6.0.24.10

However, installation seems to give a warning about Datapatch and, while the database is actually created successfully, a non-zero return code is returned:

$ cat /opt/oracle/cfgtoollogs/dbca/FREE/FREE.log
[ 2024-11-13 16:28:55.968 CST ] Prepare for db operation
DBCA_PROGRESS : 10%
[ 2024-11-13 16:28:56.111 CST ] Copying database files
DBCA_PROGRESS : 40%
[ 2024-11-13 16:30:01.753 CST ] Creating and starting Oracle instance
DBCA_PROGRESS : 42%
DBCA_PROGRESS : 46%
DBCA_PROGRESS : 50%
DBCA_PROGRESS : 54%
DBCA_PROGRESS : 60%
[ 2024-11-13 16:30:37.305 CST ] Completing Database Creation
[ 2024-11-13 16:30:40.906 CST ] [WARNING] Datapatch execution has failed. Make sure to rerun the datapatch after database operation. Look at the datapatch logs in "/opt/oracle/cfgtoollogs/sqlpatch" for further details.
DBCA_PROGRESS : 66%
DBCA_PROGRESS : 69%
DBCA_PROGRESS : 70%
[ 2024-11-13 16:33:24.155 CST ] Executing Post Configuration Actions
DBCA_PROGRESS : 100%
[ 2024-11-13 16:33:24.156 CST ] Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE

But no logs are found in the suggested location:

$ ls /opt/oracle/cfgtoollogs/sqlpatch
ls: cannot access '/opt/oracle/cfgtoollogs/sqlpatch': No such file or directory

$ ls /opt/oracle/cfgtoollogs
dbca  netca

FYI @gerald-venzl-oracle - this seems to be a small issue with the latest DBCA. The [WARNING] message itself isn't too bad. But the non-zero return code means that calling scripts will catch it as a failure.

This post has been answered by MartinBach-Oracle on Jan 7 2025
Jump to Answer

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 13 2024
8 comments
443 views