Getting an Error message while creating a oracle db image on WSL distro ubuntu

[altaf369us]

Am i doing something wrong here.

sudo ./buildContainerImage.sh -v 18.4.0 -x Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg. Checking Podman version. Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg. Ignored MD5 checksum.

Container runtime info: Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg. host: arch: amd64 buildahVersion: 1.23.1 cgroupControllers:

• devices cgroupManager: cgroupfs cgroupVersion: v1 conmon: package: 'conmon: /usr/bin/conmon' path: /usr/bin/conmon version: 'conmon version 2.0.25, commit: unknown' cpus: 8 distribution: codename: jammy distribution: ubuntu version: "22.04" eventLogger: file hostname: amohamm1-5490c idMappings: gidmap: null uidmap: null kernel: 4.4.0-19041-Microsoft linkmode: dynamic logDriver: k8s-file memFree: 4532404224 memTotal: 17032581120 ociRuntime: name: crun package: 'crun: /usr/bin/crun' path: /usr/bin/crun version: |- crun version 0.17 commit: 0e9229ae34caaebcb86f1fde18de3acaf18c6d9a spec: 1.0.0 +SYSTEMD +SELINUX +APPARMOR +CAP +SECCOMP +EBPF +YAJL os: linux remoteSocket: path: /run/podman/podman.sock security: apparmorEnabled: false capabilities: CAP_CHOWN,CAP_DAC_OVERRIDE,CAP_FOWNER,CAP_FSETID,CAP_KILL,CAP_NET_BIND_SERVICE,CAP_SETFCAP,CAP_SETGID,CAP_SETPCAP,CAP_SETUID,CAP_SYS_CHROOT rootless: false seccompEnabled: false seccompProfilePath: /usr/share/containers/seccomp.json selinuxEnabled: false serviceIsRemote: false slirp4netns: executable: /usr/bin/slirp4netns package: 'slirp4netns: /usr/bin/slirp4netns' version: |- slirp4netns version 1.0.1 commit: 6a7b16babc95b6a3056b33fb45b74a6f62262dd4 libslirp: 4.6.1 swapFree: 31059124224 swapTotal: 31604994048 uptime: 32h 54m 53.84s (Approximately 1.33 days) plugins: log:
• k8s-file
• none
• journald network:
• bridge
• macvlan volume:
• local registries: {} store: configFile: /etc/containers/storage.conf containerStore: number: 0 paused: 0 running: 0 stopped: 0 graphDriverName: overlay graphOptions: {} graphRoot: /var/lib/containers/storage graphStatus: Backing Filesystem: Native Overlay Diff: "true" Supports d_type: "true" Using metacopy: "false" imageStore: number: 29 runRoot: /run/containers/storage volumePath: /var/lib/containers/storage/volumes version: APIVersion: 3.4.4 Built: 0 BuiltTime: Wed Dec 31 19:00:00 1969 GitCommit: "" GoVersion: go1.17.3 OsArch: linux/amd64 Version: 3.4.4

========================== Building image 'oracle/database:18.4.0-xe' ... Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg. STEP 1/8: FROM oraclelinux:7-slim STEP 2/8: LABEL "provider"="Oracle" "issues"="https://github.com/oracle/docker-images/issues" "volume.data"="/opt/oracle/oradata" "volume.setup.location1"="/opt/oracle/scripts/setup" "volume.setup.location2"="/docker-entrypoint-initdb.d/setup" "volume.startup.location1"="/opt/oracle/scripts/startup" "volume.startup.location2"="/docker-entrypoint-initdb.d/startup" "port.listener"="1521" "port.oemexpress"="5500" "port.apex"="8080" --> ad8f7bb39b6 STEP 3/8: ENV ORACLE_BASE=/opt/oracle ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE ORACLE_SID=XE INSTALL_FILE_1="https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm" RUN_FILE="runOracle.sh" PWD_FILE="setPassword.sh" CONF_FILE="oracle-xe-18c.conf" CHECK_SPACE_FILE="checkSpace.sh" CHECK_DB_FILE="checkDBStatus.sh" INSTALL_DIR="$HOME/install" ORACLE_DOCKER_INSTALL="true" --> dca2812d99b STEP 4/8: ENV PATH=$ORACLE_HOME/bin:$PATH --> 9772817bfa5 STEP 5/8: COPY $CHECK_SPACE_FILE $RUN_FILE $PWD_FILE $CHECK_DB_FILE $CONF_FILE $INSTALL_DIR/ --> e90e39561ba STEP 6/8: RUN chmod ug+x $INSTALL_DIR/.sh && sync && $INSTALL_DIR/$CHECK_SPACE_FILE && cd $INSTALL_DIR && yum -y install expect openssl oracle-database-preinstall-18c && sed -i -e 's/(oracle\s+hard\s+nofile)/# \1/' /etc/security/limits.d/oracle-database-preinstall-18c.conf && unbuffer yum -y install $INSTALL_FILE_1 && yum -y remove expect && rm -rf /var/cache/yum && rm -rf /var/tmp/yum- && mkdir -p $ORACLE_BASE/scripts/setup && mkdir $ORACLE_BASE/scripts/startup && ln -s $ORACLE_BASE/scripts /docker-entrypoint-initdb.d && mkdir -p $ORACLE_BASE/oradata /home/oracle && chown -R oracle:oinstall $ORACLE_BASE /home/oracle && mv $INSTALL_DIR/$RUN_FILE $ORACLE_BASE/ && mv $INSTALL_DIR/$PWD_FILE $ORACLE_BASE/ && mv $INSTALL_DIR/$CHECK_DB_FILE $ORACLE_BASE/ && mv $INSTALL_DIR/$CONF_FILE /etc/sysconfig/ && ln -s $ORACLE_BASE/$PWD_FILE / && cd $HOME && rm -rf $INSTALL_DIR && chmod ug+x $ORACLE_BASE/.sh WARN[0000] pkg/bind: error removing "/var/tmp/buildah4005439925/mnt": directory not empty ERRO[0000] directory not empty error running container: error bind mounting root filesystem from "/var/lib/containers/storage/overlay/dbeeb6e9836b25b3891cb820d6eae8da8dfea05d14b62d41852b0594951c71aa/merged" to "/var/tmp/buildah4005439925/mnt/rootfs": invalid argument Error: error building at STEP "RUN chmod ug+x $INSTALL_DIR/.sh && sync && $INSTALL_DIR/$CHECK_SPACE_FILE && cd $INSTALL_DIR && yum -y install expect openssl oracle-database-preinstall-18c && sed -i -e 's/(oracle\s+hard\s+nofile)/# \1/' /etc/security/limits.d/oracle-database-preinstall-18c.conf && unbuffer yum -y install $INSTALL_FILE_1 && yum -y remove expect && rm -rf /var/cache/yum && rm -rf /var/tmp/yum- && mkdir -p $ORACLE_BASE/scripts/setup && mkdir $ORACLE_BASE/scripts/startup && ln -s $ORACLE_BASE/scripts /docker-entrypoint-initdb.d && mkdir -p $ORACLE_BASE/oradata /home/oracle && chown -R oracle:oinstall $ORACLE_BASE /home/oracle && mv $INSTALL_DIR/$RUN_FILE $ORACLE_BASE/ && mv $INSTALL_DIR/$PWD_FILE $ORACLE_BASE/ && mv $INSTALL_DIR/$CHECK_DB_FILE $ORACLE_BASE/ && mv $INSTALL_DIR/$CONF_FILE /etc/sysconfig/ && ln -s $ORACLE_BASE/$PWD_FILE / && cd $HOME && rm -rf $INSTALL_DIR && chmod ug+x $ORACLE_BASE/.sh": error while running runtime: exit status 1

ERROR: Oracle Database container image was NOT successfully created. ERROR: Check the output and correct any reported problems with the build operation.

[yunus-qureshi]

21.3 XE is also available. Do try that. Also, have you set the required env vars required for podman build

https://github.com/oracle/docker-images/blob/main/OracleDatabase/SingleInstance/README.md#building-the-container-images-using-podman

[altaf369us]

Yes i have, Following is the error i'm getting it now.

[altaf369us]

I have tried with the 21.3 XE, following is the error i'm getting.

[yunus-qureshi]

If you need express edition, pass -x instead of -e

[altaf369us]

forgot to add the SCs, i have tried it with -x, no luck. please find the screen shots. also tried with 18 and 21 XE, getting same error.

[yunus-qureshi]

Have you tried after setting the BUILDAH envs as documented https://github.com/oracle/docker-images/blob/main/OracleDatabase/SingleInstance/README.md#building-the-container-images-using-podman

[altaf369us]

Literally these are the below steps i have tried so far. wont passed after step 8.

Ubuntu for Windows (WSL)

1. cd /mnt/c/Users/myuser/
2. mkdir oracle
3. cd oracle
4. git clone https://github.com/oracle/docker-images.git
5. cd OracleDatabase/SingleInstance/dockerfiles
6. export BUILDAH_FORMAT=docker
7. export BUILDAH_ISOLATION=chroot
8. sudo ./buildContainerImage.sh -v 18.4.0 -x (without sudo failed during package installation)

[altaf369us]

i'm using ubuntu version 22.04 LTS on windows.

[yunus-qureshi]

Don't use sudo in step 8. Try rootless podman

[altaf369us]

seems to be working. have passed that stage where i was getting an error. will share the update. currently installing. pls find SCs below.

[altaf369us]

Its just hang there.

[yunus-qureshi]

May be some resource crunch. Have you allocated enough disk space for Ubuntu/WSL

[altaf369us]

[yunus-qureshi]

It doesn't tell me how much free disk space is available. Also did you try 21.3 XE?

[altaf369us]

I have tried it, it just hang there. please find the free disk info here.

[altaf369us]

I'am able to build oracle xe 18.4.0 database image inside the container. However, I like to know does oracle have The Oracle XE Database 18c server Docker image that contains a pre-built database? like this one https://container-registry.oracle.com/ords/f?p=113:4:115087109343200:::4:P4_REPOSITORY,AI_REPOSITORY,AI_REPOSITORY_NAME,P4_REPOSITORY_NAME,P4_EULA_ID,P4_BUSINESS_AREA_ID:803,803,Oracle%20Database%20Express%20Edition,Oracle%20Database%20Express%20Edition,1,0&cs=36bdIC2zPi95OaD0_Z9htSDJqSOC3ffVUnH3H1Jrg4xnsSOYnaoRFe6zQg0Ahmjccgdsm1o412kzJyaz191UOow

[abhisbyk]

@altaf369us Oracle does not have 18.4 XE image with pre-built database. Oracle database 21.3 XE has a pre-built database and is also available on the container registry.

[altaf369us]

@abhisbyk, Ok thx much

[yunus-qureshi]

@altaf369us is the 21.3 XE image from container-registry working for you?

docker pull container-registry.oracle.com/database/express:latest

[altaf369us]

I have built 18.4.0 XE image container. Now, I would like to know how would i connect to it? is this the suername SYS, SYSTEM and PDBADMIN to connect to Oracle DB? Basically, I just need an assistance in connecting to the DB.

[altaf369us]

[abhisbyk]

To connect with the database, you can use sqlplus. Here, SYS, SYSADMIN and PDBADMIN are users to the DB. Sample commands for database version 18.3 XE are as follows:

sqlplus sys/<your-db-password>@//localhost:1521/XE as sysdba
sqlplus system/<your-db-password>@//localhost:1521/XE
sqlplus pdbadmin/<your-db-password>@//localhost:1521/XEPDB1