Add Oracle Binary download step if the RPM isn't present about oci-oracle-xe HOT 7 CLOSED

Unfortunately, that is not a solution that will work forever, as older RPM installer files are being removed from Oracle.
For example, there is no 11g R2 RPM file available anymore (despite it not being click-through free).

However, if the checksum calculation fails, either because the file is not present or the checksum is invalid, buildContainerImage.sh could prompt the user whether an automatic download should be attempted. If that fails, it would still be up to the user to provide the installer RPM file.

from oci-oracle-xe.

I needed to build the image for myself and these are the steps I used...

1. From https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinl/procedure-installing-oracle-database-xe.html I found https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinl/procedure-installing-oracle-database-xe.html
2. curl -L https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-21c-1.0-1.ol8.x86_64.rpm -O to grab the rpm
3. I got an error about overlay so I executed sudo apt install fuse-overlayfs per https://unix.stackexchange.com/questions/689181/error-kernel-does-not-support-overlay-fs-overlay-is-not-supported-over-extfs
4. I got an error about buildah and I was running Ubuntu 20.04 - I found https://gist.github.com/sebastianwebber/2c1e9c7df97e05479f22a0d13c00aeca from Google which directed me to https://fabianlee.org/2022/08/02/buildah-installing-buildah-and-podman-on-ubuntu-20-04/ to get buildah
5. I had to add a trusted CA since I'm working inside a corporate network, so I added a couple lines:
6. COPY Issuing-CA.crt /etc/pki/ca-trust/source/anchors/
7. RUN update-ca-trust

Ran successfully, ignore the below log - see next comment
Ultimately didn't complete successfully, this was the final message:

oracle-database-xe-21c-1.0-1.x86_64
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database XE, optionally modify the parameters in '/etc/sysconfig/oracle-xe-21c.conf' and then execute '/etc/init.d/oracle-xe-21c configure' as root.
BUILDER: configuring database
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration failed. Check logs under '/opt/oracle/cfgtoollogs/netca'.
error building at STEP "RUN /install/install.2130.sh "${BUILD_MODE}"": error while running runtime: exit status 1
ERRO[1281] exit status 1

Suggestions @gvenzl ?

from oci-oracle-xe.

So it ran successfully - I'm running in WSL and it using too much memory; I added a .wslconfig file to limit memory and avoid going to swap which eliminated the errors.

Still not accessing EM manager tho, even tho I did add a SID_LIST_listener

from oci-oracle-xe.

Hey @jcrben, which flavor did you build? You need to have SHARED_SERVERS > 0 if you want access to the DB Console.

from oci-oracle-xe.

@gvenzl I ended up having to execute the command suggested at oracle/docker-images#1419 (comment) to see the EM

docker exec -it racnode1 /bin/bash
su - oracle
setfacl -R -m u:grid:rwx <XDB wallet location>
eg. setfacl -R -m u:grid:rwx /u01/app/oracle/product/19.3.0/dbhome_1/admin/ORCLCDB/xdb_wallet

I think it might have been slightly different from that - I have access to the Oracle Support Center via my employer and reviewed doc ID 2680248.1 on Oracle support

I also mentioned that over at #166

from oci-oracle-xe.

Cool, thanks a lot for sharing, @jcrben!

from oci-oracle-xe.

I'm closing this PR as it seems no longer relevant.

Downloading the RPM before the build may adds a nice little touch but ultimately Oracle decides for how long and where to publish these RPMs to, making this proposed mechanism unreliable.

from oci-oracle-xe.