Skip to Main Content

Oracle Database Express Edition (XE)

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.

How to set initial compatible to lower than 18 in 18c XE docker image

4241189Apr 28 2020 — edited May 2 2020

The plan:

we want to create a docker container with oracle18c XE version with configurable compatibility depending on the current project. So an another project, that currently uses oracle 11.2 or 12.2 can use our image with compatible set to the needed version.

First we add a new variable $COMPATIBLE with default value 18.0.0.0.0

I did following steps:

  1. I altered the system and set compatible to a lower version --> of course not possible
  2. I replaced compatibility in $ORACLE_HOME/dbs/init.ora before run the configure command --> the version $COMPATIBLE is incompatible with 18.0.0
  3. So I changed the compatible parameter in the template file /opt/oracle/product/18c/dbhomeXE/assistants/dbca/templates/XE_Database.dbc --> the version $COMPATIBLE is incompatible with 18.0.0
  4. I tried to generate scripts from the template using dbca su -s /bin/bash oracle -c "/opt/oracle/product/18c/dbhomeXE/bin/dbca -silent -generateScripts -gdbName XE -templateName XE_Database.dbc" and run the configuration with the script--> this brought me a lot of failings during the run, so it configures nothing in the end
  5. I recreated the template using dbca and the original XE_Database.dbc template and changed only the compatible parameter, than changed the template name in oracle-xe18 configureĀ  bash script method before run it and still incompatible with 18.0.0. in the tempSeed.ctl

Please help

I asked the guys on github, they sent me here to the community. Thanks in advice

Comments
Post Details
Added on Apr 28 2020
1 comment
540 views