Add OracleDatabase/23.4.0-Free project

PaulNeumann commented 1 month ago

Adds an Oracle Database 23ai Free project, based on the OracleDatabase/23.3.0-Free project. Since the 23.3.0-Free rpm is still available for download, this is a new project, rather than an update to the 23.3.0-Free project.

Notable changes from the 23.3.0-Free project:

Use Oracle Linux 9 instead of Oracle Linux 8
Add notes to .env, README.md and Vagrantfile stating that database creation will fail if the password includes special characters
Modify install.sh to prevent auto-generated passwords from containing equals signs

Tested with both VirtualBox and libvirt/KVM.

Closes #505.

I'm happy to make any changes that you'd like.

Signed-off-by: Paul Neumann 38871902+PaulNeumann@users.noreply.github.com

gvenzl commented 1 month ago

Thanks a lot, @PaulNeumann,

Verifying this PR locally at the moment, stay tuned

gvenzl commented 1 month ago

Hey @PaulNeumann,

Unfortunately, the installation fails:

    oracle23ai-free-vagrant: Complete!
    oracle23ai-free-vagrant: INSTALLER: Oracle preinstall and openssl complete
    oracle23ai-free-vagrant: INSTALLER: Environment variables set
    oracle23ai-free-vagrant: Last metadata expiration check: 0:03:23 ago on Mon 13 May 2024 05:49:36 PM -07.
    oracle23ai-free-vagrant: Dependencies resolved.
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant:  Package                        Arch        Version     Repository         Size
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant: Installing:
    oracle23ai-free-vagrant:  oracle-database-free-23ai      x86_64      1.0-1       @commandline      509 M
    oracle23ai-free-vagrant:
    oracle23ai-free-vagrant: Transaction Summary
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant: Install  1 Package
    oracle23ai-free-vagrant:
    oracle23ai-free-vagrant: Total size: 509 M
    oracle23ai-free-vagrant: Installed size: 3.6 G
    oracle23ai-free-vagrant: Downloading Packages:
    oracle23ai-free-vagrant: Running transaction check
    oracle23ai-free-vagrant: Transaction check succeeded.
    oracle23ai-free-vagrant: Running transaction test
    oracle23ai-free-vagrant: Error: Transaction test error:
    oracle23ai-free-vagrant:   package oracle-database-free-23ai-1.0-1.x86_64 does not verify: Payload SHA256 digest: BAD (Expected aed56adc104e7b78babf089765e9a7a9061f32c14e20b7f7dc2ee04d50f581c0 != 3cc9e2a9d4d40e726d4d05d7bdb8b6b737c1bd3c22d666af61497c061d23cb6d)
    oracle23ai-free-vagrant:
The SSH command responded with a non-zero exit status. Vagrant
assumes that this means the command failed. The output for this command
should be in the log above. Please read the output to determine what
went wrong.

Seems to have something to do with the RPM file itself:

[root@localhost vagrant]# uname -a
Linux localhost.localdomain 5.15.0-200.131.27.el9uek.x86_64 #2 SMP Wed Oct 4 22:09:54 PDT 2023 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost vagrant]# rpm --checksig --verbose oracle-database-free-23ai-1.0-1.el9.x86_64.rpm
oracle-database-free-23ai-1.0-1.el9.x86_64.rpm:
    Header V3 RSA/SHA256 Signature, key ID 8d8b756f: OK
    Header SHA256 digest: OK
    Header SHA1 digest: OK
    Payload SHA256 digest: BAD (Expected aed56adc104e7b78babf089765e9a7a9061f32c14e20b7f7dc2ee04d50f581c0 != 3cc9e2a9d4d40e726d4d05d7bdb8b6b737c1bd3c22d666af61497c061d23cb6d)
    Payload SHA256 ALT digest: NOTFOUND
    MD5 digest: BAD (Expected 88f89573aa164ad04c8391d2faa9c085 != 096d4aaf4dcd04c24a45d6fee679bd55)
[root@localhost vagrant]#

I'll need to dig a bit further whether this is localized issue or a general one on Linux 9.

PaulNeumann commented 1 month ago

@gvenzl Thanks for letting me know. I don't think it's an Oracle Linux 9 issue. I provisioned the VM many times during testing, using the 9.3.513 box for VirtualBox and the 9.3.495 box for libvirt. (And I just provisioned it successfully again on libvirt.)

The installer rpm size shown in your output (509 M) is way off, so it seems like something went wrong with the download. Here's what I see:

oracle23ai-free-vagrant: Total size: 1.3 G

Please let me know if there's anything I can do to help.

gvenzl commented 1 month ago

Hey @PaulNeumann,

Yeah, I noticed the same, although that's also what dnf identifies:

    oracle23ai-free-vagrant: INSTALLER: Oracle preinstall and openssl complete
    oracle23ai-free-vagrant: INSTALLER: Environment variables set
    oracle23ai-free-vagrant: Last metadata expiration check: 0:03:23 ago on Mon 13 May 2024 05:49:36 PM -07.
    oracle23ai-free-vagrant: Dependencies resolved.
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant:  Package                        Arch        Version     Repository         Size
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant: Installing:
    oracle23ai-free-vagrant:  oracle-database-free-23ai      x86_64      1.0-1       @commandline      509 M
    oracle23ai-free-vagrant:
    oracle23ai-free-vagrant: Transaction Summary
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant: Install  1 Package
    oracle23ai-free-vagrant:
    oracle23ai-free-vagrant: Total size: 509 M
    oracle23ai-free-vagrant: Installed size: 3.6 G
    oracle23ai-free-vagrant: Downloading Packages:
    oracle23ai-free-vagrant: Running transaction check
    oracle23ai-free-vagrant: Transaction check succeeded.
    oracle23ai-free-vagrant: Running transaction test

It's also strange that it expects a checksum that is not accurate either:

Expected aed56adc104e7b78babf089765e9a7a9061f32c14e20b7f7dc2ee04d50f581c0 while the checksum of the file should actually be 427ac8f337a9aa880e661d2574e9fac1427e9899a34c8459720432905bd30873:

gvenzl@gvenzl-mac Downloads % ls -alh oracle-database-free-23ai-1.0-1.el9.x86_64.rpm
-rw-r--r--@ 1 gvenzl  staff   1.3G May 14 09:19 oracle-database-free-23ai-1.0-1.el9.x86_64.rpm
gvenzl@gvenzl-mac Downloads % sha256sum oracle-database-free-23ai-1.0-1.el9.x86_64.rpm
427ac8f337a9aa880e661d2574e9fac1427e9899a34c8459720432905bd30873  oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

gvenzl commented 1 month ago

Hm, I just noticed that my previous output doesn't highlight the download of the RPM file:

    oracle23ai-free-vagrant: INSTALLER: Oracle preinstall and openssl complete
    oracle23ai-free-vagrant: INSTALLER: Environment variables set
    oracle23ai-free-vagrant: Last metadata expiration check: 0:03:23 ago on Mon 13 May 2024 05:49:36 PM -07.
    oracle23ai-free-vagrant: Dependencies resolved.
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant:  Package                        Arch        Version     Repository         Size
    oracle23ai-free-vagrant: ================================================================================
    oracle23ai-free-vagrant: Installing:
    oracle23ai-free-vagrant:  oracle-database-free-23ai      x86_64      1.0-1       @commandline      509 M

There should be a

echo 'INSTALLER: Downloading Oracle Database software'

I saw I had the RPM file in the folder already, and it was 1.3GB in size, but I've just removed it and am rebuilding.

gvenzl commented 1 month ago

Ok, I think the issue was that I did have the RPM file in the local directory and somehow that was corrupt. After removing it, the provisioning works as expected.

gvenzl commented 1 month ago

Thanks a lot for your contribution, @PaulNeumann

oracle / vagrant-projects

Add OracleDatabase/23.4.0-Free project #506