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.000000
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

« First ‹ Previous 1 2 3 4 5 6

sahbi commented on 2016-08-01 18:14 (UTC)

I guess there is something to change in the PKGBUILD once the rpm has been manually downloaded from Oracle web site. I tried to replace source=('manual://download/file/from/oracle/page/oracle-xe-11.2.0-1.0.x86_64.rpm.zip' by source=('/path/to/my/downloaded/file' but it does not seem to work. Any idea? Thanks!

The_Loko commented on 2016-03-09 12:10 (UTC) (edited on 2016-03-09 12:11 (UTC) by The_Loko)

I hadn't pay attention before, but yes, it seems that the configuration is corrupted after updating the package. I have been looking the documentation but I don't know how to solve this. Maybe creating a backup using the backup scripts included and restoring it later?

itti commented on 2016-03-09 08:42 (UTC)

Have you ever tried updating with a pre-existing package install? Twice in a row now the package upgrade destroyed my existing installation and database. I think it overwrites files that should not be overwritten. (e.g. listener configuration etc.)

The_Loko commented on 2016-03-08 12:38 (UTC)

Didn't notice, it's fixed now. Thanks!

kkl2401 commented on 2016-03-06 10:01 (UTC)

In oracle_env.sh: shouldn't it be export PATH=$PATH:$ORACLE_HOME/bin instead of export PATH=$ORACLE_HOME/bin:$PATH ? Since Oracle bundles for example zip and unzip binaries, they are used instead of the system ones.

« First ‹ Previous 1 2 3 4 5 6