Package Details: oracle-xe 18.4.0.0.0-1

Git Clone URL: https://aur.archlinux.org/oracle-xe.git (read-only, click to copy)
Package Base: oracle-xe
Description: Oracle Database Express Edition
Upstream URL: https://www.oracle.com/database/
Keywords: database oracle
Licenses: custom
Submitter: The_Loko
Maintainer: None
Last Packager: ttc0419
Votes: 14
Popularity: 0.000001
First Submitted: 2015-11-12 22:21 (UTC)
Last Updated: 2020-11-19 06:20 (UTC)

Pinned Comments

ttc0419 commented on 2022-01-03 16:08 (UTC) (edited on 2022-12-11 04:12 (UTC) by ttc0419)

21c has a lot of breaking changes that prevents the database running on "unsupported" distributions. I have a WIP PKGBUILD on my github and I currently stuck at OS Authentication error. Any help would be appreciated :)

Currently, the easiest way to install it is using the official docker image from oracle.

ArthurBorsboom commented on 2021-11-25 11:03 (UTC)

The previously reported error regarding the systemd service file is still present.

In

/usr/lib/systemd/system/oracle-xe.service

replace: ...exit;... with: ...exit...

Would you mind to fix this?

ttc0419 commented on 2020-11-19 06:23 (UTC) (edited on 2020-11-25 13:25 (UTC) by ttc0419)

Additional Notes:

  • After installing the package use the following command with root to set database password and create database:
su -s /bin/bash oracle -c '/opt/oracle/product/18c/dbhomeXE/bin/dbca -silent \
    -createDatabase -gdbName XE -templateName XE_Database.dbc -characterSet AL32UTF8 \
    -createAsContainerDatabase true -numberOfPDBs 1 -sid XE -pdbName XEPDB1 \
    -J-Doracle.assistants.dbca.validate.ConfigurationParams=false -emConfiguration DBEXPRESS \
    -emExpressPort 5500 -J-Doracle.assistants.dbca.validate.DBCredentials=false -sampleSchema true \
    -customScripts /opt/oracle/product/18c/dbhomeXE/assistants/dbca/postdb_creation.sql'
  • If you are having ORA-12547: TNS:lost contact error when logging into the database with sqlplus, use chmod -R u+s,g+s /opt/oracle/product/18c/dbhomeXE/bin/sqlplus command with root to give suid and guid permission.
  • Backup database files before removing the package.

Cheers

Latest Comments

1 2 3 4 5 6 Next › Last »

rmantingh commented on 2023-06-30 16:16 (UTC)

This package requires an additional dependency libxcrypt-compat (to get libcrypt.so.1). Without it you'll get error ... [FATAL] Error while executing "/opt/oracle/product/18c/dbhomeXE/ord/im/admin/ordlib.sql". Refer to "/opt/oracle/cfgtoollogs/dbca/XE/ordlib0.log" for more details. Error in Process: /opt/oracle/product/18c/dbhomeXE/perl/bin/perl

ttc0419 commented on 2023-03-29 08:41 (UTC) (edited on 2023-03-29 08:42 (UTC) by ttc0419)

@ArthurBorsboom Nope, tried to reach out the oracle forum but they didn't provide any helpful suggestions about how to fix the issues. If you have any ideas how to fix them, feel free to create a MR on the GitHub.

ArthurBorsboom commented on 2023-03-28 09:04 (UTC)

Hi ttc0419,

Have you been able to make progress on the Oracle XE 21c package ?

DragonX256 commented on 2022-12-09 13:01 (UTC)

@ArthurBorsboom No, there isn't any plans. I will disown package now, since I don't have any use of it and I clearly don't have any time to update it.

ArthurBorsboom commented on 2022-12-05 11:15 (UTC)

@DragonX256, are there plans for updating this package to Oracle XE 21c ?

williancristian commented on 2022-08-10 23:12 (UTC)

@mbw I understand I can try, but I may also be putting the wrong data for the connection and I don't know if it would be different from windows or the way I saw it in ubuntu

mbw commented on 2022-08-09 05:06 (UTC)

@williancristian Not sure if this is helpful for you. I am by now using the official docker image, since it was easier to setup, but also got connection errors (timeouts) whenever trying to connect.

I was able to fix them by adding oracle.net.disableOob=true to the JDBC string, as described here: https://github.com/oracle/docker-images/issues/1663

williancristian commented on 2022-08-08 23:51 (UTC)

I would like to know how I can connect dbeaver because it keeps giving connection failure

GuessWhatBBQ commented on 2022-04-17 10:30 (UTC)

For anyone facing the [FATAL] Error while executing "/opt/oracle/product/18c/dbhomeXE/ord/im/admin/ordlib.sql". Refer to "/opt/oracle/cfgtoollogs/dbca/XE/ordlib0.log". You need to install libxcrypt-compat as the perl binary bundled with the rpm depends on legacy api functions for libcrypt.