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!

Datapatch warning while installing 23ai FREE version 23.6

Simon_PNov 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
Post Details
Added on Nov 13 2024
8 comments
890 views